Author - Peter Zaitsev

Need to Connect to a Local MySQL Server? Use Unix Domain Socket!

Unix Socket Domain

When connecting to a local MySQL instance, you have two commonly used methods: use TCP/IP protocol to connect to local address –  “localhost” or 127.0.0.1  – or use Unix Domain Socket.
If you have a choice (if your application supports both methods), use Unix Domain Socket as this is both more secure and more efficient.
How […]

Read more

How to Install ProxySQL From the Percona Repository

install proxysql percona repository

This article describes how to install ProxySQL from the Percona Software Repositories.
Percona Software Repositories contain a ProxySQL version that has passed rigorous Percona tests and is known to be compatible with other Percona Software. We recommend using those builds whenever you’re running ProxySQL with Percona Server for MySQL, Percona XtraDB Cluster, MySQL, or MariaDB.
To […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Three)

MySQL high traffic

This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here, and part two can be found here.  
13. Configure MySQL Server Properly
Complexity:Medium
Potential Impact: High 
A poorly configured MySQL Server can cause severe issues, especially under high load during a traffic […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part Two)

MySQL High Traffic

This is a three-part blog series that focuses on dealing with an unexpected high traffic event as it is happening. Part one can be found here and part three can be found here.
7. Get More Memory
Complexity: Low
Potential Impact: High
If your data does not fit into memory well, your MySQL performance is likely to be […]

Read more

18 Things You Can Do to Remove MySQL Bottlenecks Caused by High Traffic (Part One)

remove MySQL traffic bottlenecks

This is a three-part blog series. Part two is located here, and part three can be found here.
There was no reason to plan for it, but the load on your system increased 100%, 300%, 500%, and your MySQL database has to support it. This is a reality many online systems have to deal with […]

Read more