Showing entries 1 to 10 of 16
6 Older Entries »
Displaying posts with tag: Tech Blog Post (reset)
MySQL High Availability: Techniques to Ensure Uptime in Critical Systems

A single hour of downtime costs companies an average of $300,000, with critical systems like databases bearing the brunt of this risk. MySQL, widely used for managing essential data, requires high availability (HA) solutions to maintain smooth uptime and avoid disruptions that can lead to financial loss or reputational damage. 

Ensuring the continuous availability of MySQL databases is essential, especially when handling high transaction volumes. ProxySQL, a powerful middleware, provides advanced support on techniques ranging from replication to clustering that assist with MySQL high availability. 

These techniques minimize vulnerabilities, improve fault tolerance, and keep systems running smoothly, even during failures or …

[Read more]
Database Security: Best Practices to Protect Your MySQL Infrastructure

As of 2024, MySQL ranks as the second most popular database management system globally.

MySQL has become a go-to choice for database management due to its dependable performance, stability, and open-source licensing.

However, its popularity also brings significant security challenges like SQL injection attacks and unauthorized data access.

As cyber threats evolve, protecting MySQL infrastructure is more critical than ever. Advanced tools like ProxySQL are vital for addressing these issues. ProxySQL is a high-performance, open-source SQL proxy tailored for MySQL and other database systems sharing the same protocol. It optimizes database traffic by managing queries more efficiently and enhancing performance and security by supporting …

[Read more]
Top 10 Ways to Optimize MySQL Performance with ProxySQL

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 …

[Read more]
Failover comparison in Aurora MySQL 2.10.0 using proxySQL vs Aurora’s cluster endpoint

 

Aurora cluster promises a high availability solution and seamless failover procedure. However, how much is actually the downtime when a failover happens? And how proxySQL can help in minimizing the downtime ? A little sneak peek on the results ProxySQL achieves up to 25x less downtime and the impressive up to ~9800x less errors during unplanned failovers. How proxySQL achieves this: 

  1. Less downtime
  2. “Queueing” feature when an instance in a hostgroup becomes unavailable.

So what is ProxySQL? ProxySQL is a middle layer between the database and the application. ProxySQL protects databases from high traffic spikes, prevents databases from having high number of connections due to the multiplexing feature and minimizes the impact during planned/unexpected failovers or crashes of DBs. 

This blog will continue with measuring the impact of an unexpected …

[Read more]
Releasing ProxySQL 2.2.0

We are proud to announce the latest release of ProxySQL version 2.2.0

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

ProxySQL v2.2.0 is a minor release comprising of backward compatible changes, enhancements and bug fixes. Going forward ProxySQL will be using the common versioning standard “Major.Minor.Patch” and so this is essentially the first minor release of the 2.1 branch and inclues many fixes and features that were added to the 2.0 branches …

[Read more]
Releasing ProxySQL 2.1.1

We are proud to announce the latest release of ProxySQL version 2.1.1 on the 21st of April 2021

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

ProxySQL v2.1.1 is a patch release comprising of minor backward compatible changes and bug fixes. This release is the first patch release of the 2.1 branch and inclues many fixes and features that were introduced in the 2.0.x branches after 2.1 was released.

Be sure to try out the ProxySQL …

[Read more]
Releasing ProxySQL 2.0.18

We are proud to announce the latest release of ProxySQL version 2.0.18 on the 8th of April 2021

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded from the ProxySQL Repository (instructions here) or for a Docker image check out the Official ProxySQL Docker Repository. ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

ProxySQL v2.0.18 is a patch release comprising of minor backward compatible changes and bug fixes.

  • Note: ProxySQL v2.1.0 remains the latest stable GA release.

Be sure to try out the ProxySQL 2.0.18 release and …

[Read more]
Releasing ProxySQL 2.0.17

ProxySQL is proud to announce the latest release of ProxySQL version 2.0.17 on the 9th of February 2021

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, or the Docker image available on our Official ProxySQL Docker Repository.  ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

ProxySQL v2.0.17 is a patch release comprising of minor backward compatible changes and bug fixes. 

Be sure to try out the new ProxySQL 2.0.17 release and …

[Read more]
Releasing ProxySQL 2.0.16

ProxySQL is proud to announce the latest release of ProxySQL version 2.0.16 on the 26th of January 2021

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, or the Docker image available on our Official ProxySQL Docker Repository.  ProxySQL is freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

ProxySQL v2.0.16 is a patch release comprising of minor backward compatible changes and bug fixes. This release brings several fixes to ProxySQL’s Native Galera monitor, AWS Aurora and connection handling.

[Read more]
Releasing ProxySQL 2.0.15

ProxySQL is proud to announce the latest release of ProxySQL version 2.0.15 on the 30th of October 2020

ProxySQL is a high performance, high availability, protocol aware proxy for MySQL, with a GPL license! It can be downloaded here or alternatively from the ProxySQL Repository, and freely usable and accessible according to the GNU GPL v3.0 license.

Release Overview Highlights

ProxySQL v2.0.15 is a patch release comprising of minor backward compatible changes and bug fixes.

The most interesting highlight of this release is the introduction of ARMv8 64-bit packages which have been compiled for CentOS-RHEL 7/8, Debian 9/10 and Ubuntu 18/20 as well as a Docker image available on our …

[Read more]
Showing entries 1 to 10 of 16
6 Older Entries »