Managing a MySQL NDB Cluster installation with its potential for multiple nodes and sites can prove challenging for most DBAs. MySQL Cluster Manager was developed to alleviate this challenge. MySQL Cluster Manager, or MCM, is a component of MySQL NDB Cluster Carrier Grade Edition, and provides a command-line interface that automates common management tasks, including […]

Galera Cluster Enterprise Edition (EE) has had support for Non-Blocking Operations (NBO) schema upgradesever since the first release of Galera Cluster Enterprise Edition (EE). It is reasonably well documented, and we think more people will benefit from using it, of course. Schema changes tend to always remain a daunting task when you have large databases to manage.

To compare between Total Order Isolation (TOI), the default, with NBO that is available in Galera Cluster Enterprise Edition (EE), we create a test table:

CREATE TABLE large;
USE large;

CREATE TABLE test_table (
    id INT PRIMARY KEY AUTO_INCREMENT,
    data VARCHAR(255),
    num1 INT,
    num2 INT,
    created_at TIMESTAMP DEFAULT CURRENT_TIMESTAMP
);

Then we …

MySQL is a widely used database management tool; however, as your application grows, maintaining optimal performance may become more challenging.  Thankfully

There has been much discussion recently about the stability and performance of the latest MySQL releases. Many database professionals are voicing concerns, especially after encountering several issues in the newer versions. Issues with MySQL 8.0.38 Let’s start with some important news from Marco Tusa. In one of his blog posts, Marco strongly advised against upgrading […]

MySQL allows you to convert spatial data from one coordinate system, known as a Spatial Reference System (SRS), to another. This function is particularly useful when dealing with data from different sources or when you need to visualise data in a specific projection. In this blog post we will explain in detail how you can […]

We are excited to announce a new MySQL Implementation Certified Associate certification. This certification is designed specifically for administrators and data professionals who want to install, configure, and manage MySQL in the Enterprise, both on premises and in the cloud. MySQL Enterprise Edition MySQL powers the most demanding Web, E-commerce, SaaS and Online Transaction Processing […]

MySQL Implementation Oracle Certified Associate Exam

Historically, Percona has been providing our customers with enterprise-grade solutions for MySQL that meet the highest standards of compatibility and compliance. To follow this commitment, Percona now offers RHEL9-certified builds for the users of Percona software for MySQL. These builds have been rigorously tested and are available as rpm packages, ensuring seamless integration with your […]

The release of Percona Server for MySQL 8.4.0 includes the new UUID_VX component, which implements UUID versions 1, 3, 4, 5, 6, and 7 according to recently published RFC 9562. UUIDs (Universally Unique Identifiers) are unique identifiers that can be generated independently without a central authority or coordination with other parties. Unlike sequential integer identifiers, which […]