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

Thankfully, ProxySQL provides many features that can help optimize MySQL performance and functions as a high-performance MySQL proxy. Let us understand the scope of improvement and how you can optimize MySQL performance using the powerful ProxySQL.

The Challenge of MySQL Performance

MySQL can face performance challenges under heavy load or complex query workloads. Conventional optimization techniques often reach their limits, necessitating additional strategies. Under such circumstances, ProxySQL can address these challenges and significantly enhance MySQL performance.   

ProxySQL is a high-performance open-source SQL proxy that organizations can use to optimize the MySQL database performance.

10 Ways ProxySQL Can Optimize …

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 […]

Auditing is one of the key concerns with Security & Compliance for many organizations.    This article is written to share a tutorial how to do audit log archiving by reading the audit log.   The tutorial is for demo purpose only.   The audit archiving process is to read the audit log using audit_log_read function.   The […]

Sharing an example of how to do audit log archiving to table and thereafter to dump the archived table to Object Storage using MySQL Shell utility