(Mike Benshoof) In an earlier post, I discussed the Shared Responsibility Model in the cloud and how it relates to databases. With either IaaS or DBaaS deployments, much of the operational and security burden is shifted away from the DBA to the cloud provider.

(Frederic Descamps) As you could read in this previous post, PHP 7.4 is now completely supporting MySQL 8.0 and the new default authentication plugin.

(Daniel Guzmán Burgos) In a high concurrency world, where more and more users->connections->threads are used, contention is a given. But how do we identify the contention point easily?

(Art van Scheppingen) SELECT … FOR UPDATE has a (not so) surprising side effect on non-existent rows: it could cause a (serious) performance penalty and even prevent you from inserting new rows at all.

(Robert Golebiowski) In the previous blog post of this series, MySQL Encryption: Talking About Keyrings, I described how keyrings work. In this post, I will talk about how master key encryption works and what the pros and cons are of using envelope encryption such as a master key.

(Paul Namuag) This is the second part of a two-part series blog for Maximizing Database Query Efficiency In MySQL. You can read part one here.

(Brian Sumpter) As the world’s most popular open-source database, MySQL has been around the block more than a few times. Traditionally installed in on-premise data centers, recent years have shown a major trend for MySQL in the cloud, and near the top of this list is Amazon RDS.

(Paul Namuag) Slow queries, inefficient queries, or long running queries are problems that regularly plague DBA’s. They are always ubiquitous, yet are an inevitable part of life for anyone responsible for managing a database.

(Frederic Descamps) To avoid infinite replication loops MySQL doesn’t allow you to have log_slave_updates and replicate-same-server-id.

(Mikael Ronstrom) In this part we are going to analyze a bit more complex query than before.