(ravikiran.iyengar) This blog describes how to identify queries that cause a sudden spike in system resources as well as the user and host who executed the culprit query using the Monyog MySQL Monitor and Advisor.

(saikumar.v) In development milestone release (DMR) version 8.0.2 we are changing several replication options. The motivation behind this is simply that we want our users to enjoy default installations with the best efficient setup, configuration and performance.

(Frederic Descamps) A MySQL replication topology can be very complex (never underestimate a DBA’s creativity). But it’s very frequent to use an asynchronous slave from your primary database to run reporting or logical backup… or any kind of read workload you need. It can also be used as delay slave

(Manjot Singh) In this blog post, I’ll look at a comparison of PostgreSQL and MySQL.

(Keith Hollman) I just wanted to share the ‘how to’ in getting to know MySQL Cluster a bit more, via Docker, as mentioned in the docker store install guide:

In this article, we will show you how to configure remote and secure connections for MySQL on Ubuntu 16.04 VPS.

(Geoff Montee) In a previous blog post, I showed how a DBA could configure MySQL or MariaDB to automatically drop old partitions. Some readers provided some feedback on some issues that they’ve run into while doing similar operations. Specifically:

(Krzysztof Ksiazek) When it comes to database infrastructure, we all want it. We all strive to build a highly available setup. Redundancy is the key. We start to implement redundancy at the lowest level and continue up the stack.

(Sheeri K. Cabral) We all know that if we add a MySQL index to speed up a read, we end up making writes slower. How often do we do the analysis to look at how much more work is done?

(Peter Zaitsev) In this blog post, I will look at disk utilization and saturation.