MySQL Replication can be fragile: whenever it encounters a connectivity error, it will retry and if it is a serious error, it will simply stop. Obviously in the latter case, you will need to repair the broken replication yourself.

(Vadim Tkachenko) In this blog post, we’ll discuss fixing MySQL scalability problems using either ProxySQL or thread pool.

(Ike Walker) I’ve seen some confusion on what constitutes a keyword or a reserved word in MySQL. The manual defines them, and has a complete list. Reserved words are a special subset of keywords, and you can’t use a reserved word as an identifier unless you quote it with backticks.

(Miguel Angel Nieto) In this blog, we’ll discuss how to find the MySQL 5.7 root password.

The majority of DBA’s perform health checks every now and then. Usually, it would happen on a daily or weekly basis. We previously discussed why such checks are important and what they should include.

(Vadim Tkachenko) In this post, we’ll look at the results from some MySQL 5.7 read-write benchmarks.

(Gabriela D’Ávila) A few weeks ago my friend Frank de Jonge told me he managed to improve an import into a MySQL server down from more than 10 hours to 16 minutes. According to him it had to do with several field types (too long fields to really small data), the amount of indexes, and constraints on

(Muhammad Irfan) In this blog post, we’ll discuss the possible reasons for MySQL “Got an error reading communication packet” errors, and how to address them.

(Vadim Tkachenko) In this blog post, we’ll discuss ProxySQL versus MaxScale for OLTP RO workloads.

(Giuseppe Maxia) MySQL Sandbox 3.1.07 adds several options to execute shell or SQL commands during the sandbox installation.