Percona

DECEMBER 14, 2023

I played a bit with ChatGPT in February to see how it would respond to random database-related inquiries, and I found it pretty impressive and annoying at the same time. significantly enhanced downgrade compatibility by introducing changes that make it easier for downgraded databases to interoperate with older MongoDB versions.

Database 84

Database Artificial Intelligence Servers Operating System 84

Percona

OCTOBER 18, 2023

Migrating a proprietary database to open source is a major decision that can significantly affect your organization. Today, we’ll be taking a deep dive into the intricacies of database migration, along with specific solutions to help make the process easier.

Open Source 89

Open Source Database Hardware Strategy 89

Percona

DECEMBER 15, 2022

JSON data and relational databases have traditionally been diametric opposites. So many folks were surprised when relational databases started adding a JSON data type to their products. In this multi-part blog series, we will start with an overview of using JSON in a relational database. JSON is popular. Very popular.

Database 90

Database Servers Processing Efficiency 90

Percona

JANUARY 17, 2023

The definition of Percona Advisors by ChatGPT is the following: Percona Advisors can help organizations implement robust security measures to protect their databases and sensitive data. Percona Advisors is an open source framework, meaning you can create your own checks by following our documentation. It is partially true.

Database 101

Database Open Source Monitoring Innovation 101

Percona

NOVEMBER 3, 2023

Sure, database migration is complex, particularly when you’re looking to migrate from a proprietary database to an open source one. Database migration is almost always time-consuming, tedious, and full of potential pitfalls. Database migration is complex Let’s start here. What’s your documentation plan?

Database 81

Database Open Source Benchmarking Strategy 81

Percona

MARCH 23, 2023

When it comes to enterprise-level databases, there are several options available in the market, but PostgreSQL stands out as one of the most popular and reliable choices. PostgreSQL is a free and open source object-relational database management system (ORDBMS) that has existed since the mid-1990s.

Database 113

Database Open Source Traffic Small Business 113

Percona

MARCH 30, 2023

The use of open source databases has increased steadily in recent years. Past trepidation — about perceived vulnerabilities and performance issues — has faded as decision makers realize what an “open source database” really is and what it offers. What is an open source database?

Open Source 73

Open Source Database Storage Scalability 73

Percona

NOVEMBER 1, 2023

sec) However, we can still find a warning in the official documentation , even for the 8.1 Percona Distribution for MySQL is the most complete, stable, scalable, and secure open source MySQL solution available, delivering enterprise-grade database environments for your most critical business applications… and it’s free to use!

Servers 93

Servers Database Cache C++ 93

Scalegrid

NOVEMBER 25, 2019

ScyllaDB is an open-source distributed NoSQL data store, reimplemented from the popular Apache Cassandra database. We’ve heard a lot about this rising database from the DBA community and our users, and decided to become a sponsor for this years Scylla Summit to learn more about the deployment trends from its users.

Big Data 187

Big Data Database Open Source Azure 187

Percona

JUNE 22, 2023

To make data count and to ensure cloud computing is unabated, companies and organizations must have highly available databases. A basic high availability database system provides failover (preferably automatic) from a primary database node to redundant nodes within a cluster. HA is sometimes confused with “fault tolerance.”

Availability 105

Availability Database Open Source Hardware 105

Percona

AUGUST 30, 2023

Data powers everything, and unlike coal and coal combustion, data and databases aren’t going away. In this blog, we’ll focus on the elements of database backup and disaster recovery, and we’ll introduce proven solutions for maintaining business continuity, even amid otherwise dire circumstances.

Database 85

Database Hardware Open Source Strategy 85

Scalegrid

JULY 29, 2019

MySQL is a free open source relational database management system that is leveraged across a majority of WordPress sites, and allows you to query your data such as posts, pages, images, user profiles, and more. Managing a database is hard, as it needs continuous updating, tuning, and monitoring to ensure the performance of your website.

Database 166

Database Cloud Website Azure 166

All Things Distributed

JUNE 21, 2018

A common question that I get is why do we offer so many database products? To do this, they need to be able to use multiple databases and data models within the same application. Seldom can one database fit the needs of multiple distinct use cases. Seldom can one database fit the needs of multiple distinct use cases.

Database 167

Database AWS Games Latency 167

Scalegrid

MARCH 8, 2024

With MySQL point-in-time recovery , you can restore your database to the moment before the problem occurs. Preparation for PITR is crucial and involves enabling binary logging and creating a full database backup. STATEMENT level – at which only SQL statements causing changes in data are documented succinctly.

Database 162

Database Strategy Servers Best Practices 162

Percona

JULY 31, 2023

Open source database architects usually do not implement business logic in their databases. This is in stark contrast to many commercial databases where this is a common practice. In the first case, all the heuristics are kept at the application layer, and the database has little or no effect on the data quality.

Database 73

Database Open Source Servers Code 73

All Things Distributed

OCTOBER 8, 2014

We are introducing native support for document model like JSON into DynamoDB, the ability to add / remove global secondary indexes, adding more flexible scaling options, and increasing the item size limit to 400KB. The original Dynamo paper inspired many database solutions, which are now popularly referred to as NoSQL databases.

Availability 145

Availability Performance Scalability AWS 145

Percona

MAY 2, 2023

That’s why it’s essential to implement the best practices and strategies for MongoDB database backups. Why are MongoDB database backups important? Regular database backups are essential to protect against data loss caused by system failures, human errors, natural disasters, or cyber-attacks.

Best Practices 52

Best Practices Database Storage Servers 52

Scalegrid

DECEMBER 28, 2023

Managing vast datasets effectively is an essential requirement for modern applications, and MongoDB , a leading NoSQL database, offers robust solutions for this requirement. Offset-based involves utilizing functions such as skip , limit and a query which indicates how many documents should be skipped or returned at maximum.

Best Practices 130

Best Practices Efficiency Strategy Speed 130

Percona

JANUARY 24, 2023

Databases on Kubernetes continue their rising trend. Point-in-time recovery Point-in-time recovery (PITR) allows you to reduce your Point Recovery Objective by restoring or rolling back the database to a specific transaction or time. But snapshots cannot provide you with the same RPO as native database mechanisms.

Database 65

Database Storage Open Source AWS 65

HammerDB

OCTOBER 23, 2023

HammerDB uses stored procedures to achieve maximum throughput when benchmarking your database. However, there can be a lack of understanding of the benefits that stored procedures bring or if you have a benchmarking tool or database that doesn’t support stored procedures, then you have nothing to compare against.

Benchmarking 62

Benchmarking Database Network C++ 62

DZone

FEBRUARY 5, 2023

Cosmos DB is a multimodal database in Azure that supports schema-less storage. By default, Cosmos DB containers tend to index all the fields of a document uploaded. Cosmos DB can be a good candidate for a key-value store. We can limit the index properties only to id and partitionkey to make the container a pure key-value store.

Azure 243

Azure Storage C++ Performance Testing 243

Scalegrid

JANUARY 19, 2024

For example, memory-resident databases without persistent disks, such as Redis cluster setups or Apache Spark installations, rely on stand-alone machines. To traditional relational databases, where rollbacks are less likely to cause data loss, MongoDB differs significantly.

Database 130

Database Network Servers Monitoring 130

Dynatrace

MARCH 27, 2024

As teams and their structure and metadata are often maintained in a dedicated database, such as Microsoft Entra ID (formerly Azure Active Directory) or ServiceNow. A dedicated workflow allows automatic synchronization of the database information with Dynatrace and keeps the ownership team information up-to-date.

Best Practices 204

Best Practices Azure Database Code 204

The Morning Paper

MARCH 3, 2020

Millions of tiny databases , Brooker et al., It takes you through the thinking processes and engineering practices behind the design of a key part of the control plane for AWS Elastic Block Storage (EBS): the Physalia database that stores configuration information. NSDI’20. This paper is a real joy to read. a majority of nodes).

Database 106

Database AWS Network Design 106

Percona

OCTOBER 10, 2023

mysql> create database if not exists atsaloux; Query OK, 1 row affected (0.02 Jobs documentation has quite a few details for failure handling, retries, deadlines, etc. Other names may be trademarks of their respective owners. Type 'help;' or 'h' for help. Type 'c' to clear the current input statement. drop_triggers:10000:0.25,copy_rows:10000:0.25,swap_tables:10000:0.25,update_foreign_keys:10000:0.25,analyze_table:10000:0.25

Database 92

Database Performance C++ Engineering 92

Dynatrace

MARCH 20, 2024

External dependencies Many applications rely on external services, such as databases, APIs, or third-party services. For instance, deploying a new version of a web application that introduces inefficient database queries could lead to increased response times and decreased user satisfaction.

Open Source 273

Open Source Hardware DevOps Infrastructure 273

Percona

OCTOBER 11, 2023

KiB config 240.00 KiB local 468.00 KiB mongoshake 56.00 KiB sample_airbnb 52.20 MiB sample_analytics 9.21 MiB sample_geospatial 984.00 KiB sample_guides 40.00 KiB sample_mflix 108.17 MiB sample_restaurants 5.57 MiB sample_supplies 980.00 KiB sample_training 40.50 MiB sample_weatherdata 2.39 KiB config 240.00 KiB local 468.00 KiB mongoshake 56.00

Database 84

Database Open Source Testing Servers 84

Percona

DECEMBER 18, 2023

These days, there’s been a lot of talk in the industry about setting up one’s database system on PostgreSQL. It can perform ETL transforms from one database to another and, under certain special circumstances, can even be implemented as a poor man’s replication solution. MYSQL: OS: Ubuntu 16.04 MySQL version 5.7

Open Source 118

Open Source Database Architecture Design 118

Dynatrace

JANUARY 16, 2023

The strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Strongest Kubernetes growth areas are security, databases, and CI/CD technologies. Of the organizations in the Kubernetes survey, 71% run databases and caches in Kubernetes, representing a +48% year-over-year increase. Java, Go, and Node.js

Open Source 347

Open Source Java Operating System Programming 347

DZone

SEPTEMBER 6, 2022

For example, each deliverable in the project, like the requirements, design, code, documents, user interface, etc., Testing can also be divided based on the sub-stages or activities in testing, for instance, test case generation and design, test case execution and verification building of the testing database, etc. should be tested.

Testing 246

Testing Programming Design Code 246

Percona Community

OCTOBER 19, 2020

Abstract MySQL Document Store enables us to work with SQL relational tables and schema-less JSON collections. So instead of having a mixed bag of databases, you can just rely on MySQL, where the JSON documents can be stored in collections and managed with CRUD operations. • London 10:00 a.m. • New Delhi 2:30 p.m.

Database 40

Database 40

Dynatrace

JANUARY 31, 2024

With PowerConnect, collecting data from SAP systems and fueling the Dynatrace platform, Dynatrace automatically uncovers the topology model of the SAP landscape, providing a clear and comprehensive view of the relationships and dependencies among different systems, servers, databases, applications, and interfaces.

Java 194

Java Analytics Best Practices Monitoring 194

Percona

JUNE 20, 2023

Percona Operator for PostgreSQL offers a powerful solution for managing and scaling PostgreSQL databases in a Kubernetes environment, making it an ideal choice for developer use cases. I will use the regular kubectl approach: $ kubectl apply --server-side -f deploy/bundle.yaml Django application would require its own user and database.

Database 112

Database Open Source Engineering Efficiency 112

Dynatrace

OCTOBER 7, 2021

This means you no longer have to provision, scale, and maintain servers to run your applications, databases, and storage systems. Amazon DynamoDB: DynamoDB is a key-value and document database capable of handling more than 10 trillion requests per day and has the capacity to manage 20 million requests per second.

Serverless 286

Serverless AWS Lambda Storage 286

Percona

OCTOBER 5, 2023

Today’s businesses face two major challenges when it comes to managing databases: vendor lock-in of public cloud providers and the inherent complexity of running and managing databases. Furthermore, managing a myriad of databases across multiple environments poses a daunting task, requiring significant effort and resources.

Open Source 90

Open Source Social Media Database Media 90

Percona

FEBRUARY 23, 2023

If you ever had to make a quick ad-hoc backup of your MongoDB databases, but there was not enough disk space on the local disk to do so, this blog post may provide some handy tips to save you from headaches. while not overloading the CPU capacity on the production database. 0 document(s) failed to restore. %H-%M)/db2.zst

AWS 118

AWS Storage Database Open Source 118

Percona

MARCH 25, 2024

Indexes in MongoDB play a crucial role in improving the query performance and increasing the overall database efficiency. Without indexes, MongoDB will perform a collection scan, i.e., it will read all the documents to find if they match the condition specified in the query and cause low response time.

Efficiency 79

Efficiency Database Performance 79