Percona

JANUARY 11, 2024

In my previous article, Comparisons of Proxies for MySQL, I showed how MySQL Router was the lesser performing Proxy in the comparison. From that time to now, we had several MySQL releases and, of course, also some new MySQL Router ones.Most importantly, we also had MySQL Router going back to being a level 7 proxy […]

Performance 92

Performance Benchmarking Availability Servers 92

Percona

JULY 27, 2023

This is a Quick Peek at what Oracle delivered with MySQL 8.0.34 MySQL previously released software quarterly as part of a continuous delivery system where new features were made available. The release with the new features will be called the Innovation series, and MySQL 8.1.0 Quick reminder The End of Life for MySQL 8.0

Servers 84

Servers Open Source Tuning Cache 84

Percona

APRIL 4, 2023

The first step for many is looking into the new reserved words in MySQL 8.0. As MySQL gets new functionality or the project matures, there are new additions to the list of reserved words you can not use as column names. It is recommended that you use the util.checkForServerUpgrade() in the MySQL Shell to check for these Reserved Words.

Open Source 118

Open Source Database Servers Scalability 118

Percona

SEPTEMBER 26, 2023

This blog post discusses the limitations of the MySQL Clone plugin. The MySQL clone plugin significantly simplifies the process of replica provisioning. Debugging options, such as innodb_force_recovery , could cause clone operation failure at further steps, as reported in MySQL Bug 109035.

Servers 109

Servers Network Cache Processing 109

Percona

MARCH 1, 2023

Oracle’s MySQL 5.7 The Era of MySQL 5.x x will be over, and only MySQL 8.0 So if you are running MySQL, you need to consider upgrading to version 8.0 There are many other features that you want to have in MySQL 8.0 But before going with the MySQL Community Edition, you should look at Percona Server for MySQL.

Servers 120

Servers Open Source Tuning C++ 120

Percona

FEBRUARY 15, 2023

Previously, I wrote about our Terraform provider to deploy Percona Server for MySQL ( Percona Server for MySQL: Automatic Cloud Deployment With Terraform ) and Percona Monitoring and Management ( Deploying Percona Monitoring and Management (PMM) With Terraform ). Download Percona Distribution for MySQL Today

Open Source 124

Open Source AWS Scalability Servers 124

Percona

AUGUST 8, 2023

Memory Memory is one of the easier resources to predict and forecast and one of the few places where an algorithm might help you, but for this, we need to know a bit about how MySQL uses memory. MySQL has two main memory consumers. The most common is the queries that you run against MySQL itself.

Traffic 90

Traffic Cache Monitoring Database 90

Percona

JANUARY 2, 2024

Fortunately, in Percona Server for MySQL , this feature is free to use. The auditing plugin overview has been explained in the blog post Percona’s MySQL Audit Log Plugin – An Enterprise Feature at a Community Price. mysql> SET PERSIST audit_log_include_commands = 'drop_db,drop_table'; Query OK, 0 rows affected (0.04

Servers 85

Servers Database Open Source Scalability 85

Percona

SEPTEMBER 19, 2023

Now, since backup speed and compactness are important for busy, important databases, Percona’s open source physical backup solution – Percona XtraBackup (PXB) , takes into account all these aspects and benefits MySQL world with its exceptional capabilities! root@ip-xxx-xx-xx-xx ~]# mysqlsh -uroot -p MySQL Shell 8.0.33

C++ 107

C++ Servers Storage Speed 107

Percona

JUNE 26, 2023

Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. It offers highlights, critical information, links to the full release notes, and direct links to the software or service itself to download. Percona Server for MySQL 8.0.33-25 Take a look!

Servers 72

Servers Open Source Scalability Database 72

Percona

JUNE 22, 2023

As a MySQL database administrator, keeping a close eye on the performance of your MySQL server is crucial to ensure optimal database operations. A monitoring tool like Percona Monitoring and Management (PMM) is a popular choice among open source options for effectively monitoring MySQL performance.

Performance 106

Performance Monitoring Traffic Database 106

Percona

JANUARY 19, 2023

Recently Oracle released new versions of their software and there are some things of note. MySQL 8.032 is not a major change but you do need to be aware of some changes just in case they have the potential to send you into the court of Murphy’s Law. upgrade issue fixed “Upgrading from MySQL 5.7 to MySQL 8.0

Database 106

Database Servers Engineering Code 106

Percona

NOVEMBER 1, 2023

As businesses and applications increasingly rely on MySQL databases to manage their critical data, ensuring data reliability and availability becomes paramount. In this blog, we will review all of the potential MySQL backup and restore strategies, the cornerstones of any application. Why Do MySQL Backups Matter?

Best Practices 80

Best Practices Storage Strategy Database 80

Percona

MAY 15, 2023

Historically MySQL is great in horizontal READ scale. The main reason behind this is that MySQL is a relational database system (RDBMS), and any data that is going to be written in it must respect the RDBMS rules. In the MySQL open source ecosystem, we have only two consolidated ways to perform sharding — Vitess and ProxySQL.

Traffic 125

Traffic Scalability Database Servers 125

Percona

APRIL 3, 2024

While this can be caused by a multitude of factors, it is more often than not caused by a bad or slow MySQL […] This blog was originally published in June 2020 and was updated in April 2024.One One of the most common support tickets we get at Percona is the infamous “database is running slower” ticket.

Tuning 52

Tuning Database Monitoring Software 52

Percona

MARCH 13, 2023

When we need to upgrade from MySQL 5.7 to MySQL 8, we could choose to do an in-place upgrade or set up another MySQL 8 server(s) from the existing running MySQL 5.7 This article will explain how to set up MySQL 8 as a replica from an existing MySQL 5.7 server with Percona XtraBackup. and xtrabackup 2.4

Servers 106

Servers C++ Storage Systems 106

Percona

NOVEMBER 1, 2023

MySQL Server – Community Edition The problem applies to all versions of the upstream MySQL Community up to 8.0.23. Here is an example scenario you may end up here: mysql > select @@version,@@version_comment; + --+ + | @@version | @@version_comment | + --+ + | 5.7.43 | MySQL Community Server (GPL) | + --+ + 1 row in set (0.00

Servers 98

Servers Database Cache C++ 98

Percona

FEBRUARY 12, 2024

You know about MySQL; we know about MySQL. Because MySQL is so popular, you might be considering migrating your database to MySQL Community Edition or MySQL Enterprise. After all, it’s been the most popular database system for years now. If […]

Database 87

Database Systems Software Software 87

Percona

DECEMBER 4, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. Percona Distribution for MySQL (PS- based variant) 8.1.0

Open Source 81

Open Source Azure Servers Programming 81

Percona

DECEMBER 11, 2023

A quick configuration change may do the trick in improving the performance of your AWS RDS for MySQL instance. While this discussion primarily targets MySQL instances, the principles are also relevant to PostgreSQL and MariaDB instances. and later v10 versions MySQL: 8.0.28 2xlarge c5.2xlarge MySQL 8.0.31 Get in touch

AWS 99

AWS Benchmarking Performance Traffic 99

Percona

APRIL 14, 2023

A shared characteristic in most (if not all) databases, be them traditional relational databases like Oracle, MySQL, and PostgreSQL or some kind of NoSQL-style database like MongoDB, is the use of a caching mechanism to keep (a copy of) part of the data in memory. How do you know if your MySQL database caching is operating efficiently?

Cache 92

Cache Efficiency Database Monitoring 92

Percona

AUGUST 18, 2023

This blog describes how to configure systemd for multiple instances of MySQL. With package installations of MySQL using YUM or APT, it’s easy to manage MySQL with systemctl, but how will you manage it when you install from the generic binaries? Better failure handling, similar cost. 10-Linux.x86_64.ssl101.tar.gz

Programming 86

Programming Servers Database Hardware 86

Percona

JUNE 12, 2023

Open source databases provide great foundations for high availability — without the pitfalls of vendor lock-in that can come with proprietary software. However, open source software doesn’t typically include built-in HA solutions. This blog provides links to such architectures — for MySQL and PostgreSQL software.

Architecture 98

Architecture Availability Open Source Healthcare 98

Scalegrid

JANUARY 3, 2020

Monitoring your MySQL database performance in real-time helps you immediately identify problems and other factors that could be causing issues now or in the future. This is usually done through monitoring software and tools either built-in to the database management software or installed from third-party providers.

Monitoring 164

Monitoring Metrics Servers Database 164

Percona Community

MARCH 14, 2023

Inconsistent data and GTIDs with mysqldump Marcelo Altmann (Senior Software Engineer) fixed the bug when data and GTIDs backed up by mysqldump were inconsistent. came out recently and had some important bugfixes contributed by Perconians. Here is a brief overview of the work done.

Software Engineering 109

Software Engineering Servers Engineering Software 109

Percona

JULY 27, 2023

On July 18th, Oracle released its first pair of MySQL LTS and Innovation releases. ( For more, check out A Quick Peek at MySQL 8.0.34 and MySQL 8.1.0.) So, the next immediate question that comes to mind is: Is Percona going to follow the same release pattern as “upstream“ MySQL? The short answer is “yes.”

Innovation 72

Innovation Servers Open Source Software 72

Percona

JULY 15, 2023

Starting from MySQL 8.0.13, functional indexes are supported. In this article, I will first explain an overview of indexes in MySQL and cover the MySQL CREATE INDEX before diving into showing what functional indexes are and how they work. Want to learn more about MySQL indexes? An index on that column can not be used.

Virtualization 78

Virtualization Speed Database Efficiency 78

Percona

AUGUST 4, 2023

In this blog post, we will look at the lifecycle and release management for MySQL and MariaDB servers — where we are now and relevant historical background. It is worth noting both MySQL and MariaDB have Community and Enterprise versions. This was a departure from matching MySQL versions, as was happening with MySQL 5.1

Database 80

Database Servers Innovation Open Source 80

Percona

AUGUST 7, 2023

Percona software is designed for peak performance, uncompromised security, limitless scalability, and disaster-proofed availability. Our Release Roundups showcase the latest Percona software updates, tools, and features to help you manage and deploy our software. Percona Distribution for MySQL (PXC-based variant) 8.0.33

Open Source 86

Open Source Scalability Servers Database 86

Percona

DECEMBER 8, 2023

In this article, we will demonstrate how to achieve asynchronous replication automatic source failover when our replica is a Percona Server for MySQL (PS) and the source is a Percona XtraDB Cluster (PXC) cluster, using virtual IP (VIP) managed by Keepalived. Why not use the below MySQL built-in functionality instead of Keepalived?

Servers 89

Servers Virtualization Open Source Scalability 89

Percona

SEPTEMBER 20, 2023

If you’re a DBA, one of your “easiest” tasks is to stop/start MySQL during a maintenance window, but even that could lead to unwanted scenarios if you modify some dynamic parameters at some point in your instance. grep conn /etc/my.cnf max_connections=200 And before the dynamic change, MySQL is running with the same value.

Open Source 93

Open Source Servers Scalability Database 93

Percona

JUNE 15, 2023

Sometimes we might need to install/upgrade Percona Server for MySQL /MySQL 8 to a particular version in a test or production environment. Install Percona Server for MySQL 8 specific version packages via repository. Download specific Percona Server for MySQL 8 tarball packages and install them manually. bullseye amd64 1.7

Servers 85

Servers C++ Database Systems 85

Percona

OCTOBER 10, 2023

In this blog post, I’ll provide some thoughts on how schema changes can be performed when running MySQL on Kubernetes I won’t focus on DIRECT ALTERs as it is pretty straightforward to apply them. You can just connect to the MySQL service POD and perform the ALTER. Your MySQL connection id is 256 Server version: 8.0.32-24.2

Database 97

Database Performance C++ Engineering 97

Percona

APRIL 26, 2023

Even though open source software is firmly in the mainstream, used widely by businesses, governments, and everyone who owns a cell phone or computer, the question repeatedly arises: “Is open source software safe?” Is open source software as stable as other software? Is open source software secure?

Open Source 85

Open Source Software Software Social Media 85

Percona

APRIL 20, 2023

As we approach end of life for MySQL 5.7 later this year, many businesses are currently working towards upgrading to MySQL 8. As there is no procedure for downgrading from MySQL 8 other than restoring a backup, testing and validation are more critical than previous major version upgrades.

Open Source 92

Open Source Best Practices Servers Database 92

Percona

SEPTEMBER 1, 2023

MySQL server performance can sometimes be perplexing, and if you’ve ever wondered about the role of triggers in influencing your MySQL server’s memory allocation, this post is for you. What is a Trigger in MySQL? A Trigger in MySQL is a database object that plays a pivotal role in database management.

Cache 61

Cache Database Games Healthcare 61

Percona

OCTOBER 31, 2023

Percona has a mission to provide the best open source database software, support, and services so our users can innovate freely. Continuing this trajectory into the future improvements in the development of our software products will require many decisions. We are proud of how far we have come over the last 16+ years.

Open Source 91

Open Source Database Operating System Programming 91