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. Have you built a testing environment?

Database 81

Database Open Source Benchmarking Strategy 81

Percona

JUNE 12, 2023

When it comes to access to their applications, users demand instant, reliable, and secure interactions — and that means databases must be highly available. With database high availability (HA), services are largely uninterrupted, and end users are largely satisfied. They’re proven and ready-to-go.

Architecture 94

Architecture Availability Open Source Healthcare 94

Percona

SEPTEMBER 19, 2023

It looks like we succeeded, and I’m happy to announce that Percona Distribution for PostgreSQL 16 is now available! Added support for regular expression matching of user and database names in pg_hba.conf, and user names in pg_ident.conf. We plan to make Percona images for PostgreSQL available on Docker Hub shortly.

Availability 106

Availability Open Source Database Servers 106

Scalegrid

MARCH 12, 2019

Are you deploying PostgreSQL in the cloud and want to understand your options for achieving high availability? In our previous blog post, Managing High Availability in PostgreSQL – Part I , we discussed the capabilities and functioning of PostgreSQL Automatic Failover (PAF) by ClusterLabs. High Availability Test Scenarios.

Availability 147

Availability Servers Open Source Database 147

Percona

OCTOBER 20, 2023

Heck, typing “database migration plan” into Google and reading this blog could constitute planning. In brief, a proper database migration plan includes: Establishing clear objectives: Define what you want to achieve and how open source will get there. Some level of planning is expected when migrating to open source.

Open Source 85

Open Source Database Best Practices Strategy 85

Percona

FEBRUARY 2, 2023

Database security is crucial to protecting sensitive information stored in a database. A critical aspect is authentication, which refers to verifying the identity of a user trying to access the database. PostgreSQL server authentication refers to verifying the identity of a user trying to connect to the PostgreSQL server.

Database 121

Database Servers Testing Programming 121

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

JUNE 22, 2020

MySQL is the all-time number one open source database in the world, and a staple in RDBMS space. MySQL on DigitalOcean is a natural fit, but what’s the best way to deploy your cloud database? In this benchmark, we compare equivalent plan sizes between ScaleGrid MySQL on DigitalOcean and DigitalOcean Managed Databases for MySQL.

Database 217

Database Benchmarking Latency Performance 217

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 114

Database Open Source Traffic Small Business 114

Percona

AUGUST 22, 2023

Estimates vary, but most reports put the average cost of unplanned database downtime at approximately $300,000 to $500,000 per hour, or $5,000 to $8,000 per minute. With so much at stake, database high availability and fault tolerance have become must-have items, but many companies just aren’t certain which one they must have.

Availability 77

Availability Hardware Open Source Database 77

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 90

Open Source Database Hardware Strategy 90

SQL Shack

SEPTEMBER 8, 2020

In this 20th article for the SQL Server Always On Availability Group series, we will cover the steps to restore an existing availability group database. Requirement Suppose we have multiple database environments for a critical application. These environments can be development, stage, UAT (user acceptance testing).

Availability 52

Availability Database Servers Testing 52

Alex Podelko

APRIL 18, 2021

MongoDB has the most advanced continuous performance testing I know about. MongoDB shared a lot of information on how we do performance testing and even open sourced some parts of it. Continuous performance testing is built on the top of Evergreen. 34 (2020), Performance Testing with David Daly , is another good introduction.

Performance Testing 182

Performance Testing Performance Testing Education 182

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

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

Percona

APRIL 28, 2023

Let’s start with a simple introductory comparison: With proprietary (closed source) database software, the public does not have access to the source code; only the company that owns it and those given access can modify it. Myth #2: Proprietary databases are better and therefore more suitable for large enterprises.

Open Source 110

Open Source Database Software Software 110

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

NOVEMBER 3, 2023

Rather than listing the concepts, function calls, etc, available in Citus, which frankly is a bit boring, I’m going to explore scaling out a database system starting with a single host. I won’t cover all the features but show just enough that you’ll want to see more of what you can learn to accomplish for yourself.

Database 103

Database Benchmarking Latency C++ 103

High Scalability

SEPTEMBER 1, 2020

Microsoft Azure is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. MySQL is the number one open source database that’s commonly hosted through Azure instances. We measure latency in ms 95th percentile latency.

Azure 137

Azure Database Benchmarking Performance 137

Percona

JUNE 30, 2023

Percona, a leading provider of open-source database software and services, announced the general availability of Percona Operator for PostgreSQL version 2. Kubernetes provides many benefits, such as automation and scalability, but it also introduces new complexities when it comes to managing databases.

Availability 92

Availability Open Source Azure Hardware 92

Scalegrid

NOVEMBER 12, 2019

PostgreSQL is an amazing relational database. However, beyond just the features, there are other important aspects of a database that need to be considered. However, beyond just the features, there are other important aspects of a database that need to be considered. Feature-wise, it is up there with the best, if not the best.

Database 184

Database Open Source Storage Servers 184

Percona

AUGUST 2, 2023

Restoring a MySQL database backup is a crucial task that can sometimes be time-consuming, especially for large databases. Linux native Input/Output (I/O) statistics Pipe viewer utility By following these approaches, we can effectively monitor the restoration process and manage your MySQL database restoration efficiently.

Database 80

Database Monitoring C++ Speed 80

Percona

FEBRUARY 24, 2023

Today, we are excited to announce the release of Percona Monitoring and Management (PMM) V2.35 , including a tech preview of label-based access control, the general availability of Helm Chart, and a range of enhancements to our Database as a Service (DBaaS) offerings, among other improvements and features.

Availability 93

Availability Metrics Monitoring Open Source 93

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.

Database 106

Database AWS Network Design 106

Percona

JANUARY 25, 2023

Database administrators often need to identify inactive databases and users to save resources. This can be done using various methods to determine which databases and users are frequently accessed. We can save disk space and other resources by purging inactive databases and users.

Database 94

Database C++ Servers Open Source 94

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

has been free from the issue since the very first release (I tested back, including the first GA release 8.0.13-3 Fortunately, there was a fix in version 8.0.24 addressing this problem. sec) mysql > analyze table sbtest1; + -+ + -+ -+ | Table | Op | Msg_type | Msg_text | + -+ + -+ -+ | db1.sbtest1 x are all safe.

Servers 94

Servers Database Cache C++ 94

Percona

OCTOBER 16, 2023

In the spirit of open and transparent communication, we would appreciate your feedback and invite PostgreSQL users to test the extension and provide feedback either via the GitHub repository or in the forum. This is something that is available in other databases but not provided in upstream, vanilla Postgres. What is TDE?

Open Source 110

Open Source Testing Database Design 110

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

HammerDB

JULY 5, 2022

Python is a popular programming language, especially for beginners, and consequently we see it occurring in places where it just shouldn’t be used, such as database benchmarking. We use stored procedures because, as the introductory post shows, using single SQL statements turns our database benchmark into a network test).

Benchmarking 98

Benchmarking Database C++ Virtualization 98

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. Three distinct modes are available within MySQL when setting up your binary logs’ format.

Database 162

Database Strategy Servers Best Practices 162

Percona

OCTOBER 19, 2023

In this guide, we will demonstrate how to establish a Citus database spanning multiple nodes by using Percona Distribution for PostgreSQL. This setup empowers your database to efficiently manage increased data volumes, enhance performance, and maintain availability. 1ubuntu1~20.04.1) 1ubuntu1~20.04.1)

Scalability 83

Scalability Database Open Source Traffic 83

Scalegrid

JULY 8, 2020

If you must kill the script at this point, there are two options available: SCRIPT KILL command can be used to stop a script that hasn’t yet done any writes. The complete information on methods to kill the script execution and related behavior are available in the documentation. Behavior on Sentinel-Monitored High Availability Systems.

Servers 239

Servers Database Availability Monitoring 239

Scalegrid

JULY 29, 2020

PgBouncer defines one pool per user+database combination. This is shared between all clients, so a pooled connection is available to all clients. A client benefits from a pooled connection only if it connects to a child which has previously served a connection for this database+user combination. High availability.

Benchmarking 246

Benchmarking Database Performance Testing Availability 246

Scalegrid

FEBRUARY 1, 2024

MySQL is a popular open-source relational database management system for online applications and data warehousing. Because of this, preserving the availability and integrity of the data stored in MySQL databases requires regular backups. Having MySQL backups for your database can speed up and simplify the recovery process.

Best Practices 130

Best Practices Storage Strategy Database 130

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

SQL Shack

DECEMBER 14, 2020

In this 39th article for SQL Server Always On Availability Group series, we will learn to configure SSISDB in the highly available AG groups. You can configure multiple environments such as test, production, execute package, view progress and […].

Availability 60

Availability Servers Database Testing 60