(Olivier Dasini) Since 8.0.16, MySQL Server supports a validate-config option that enables the startup configuration to be checked for problems without running the server in normal operational mode:

(Matthew Lang) Performing schema changes often requires extended downtime for applications. This is due to MySQL needing to rebuild tables for common schema change operations.

(Nawaz Ahmed) This blog is aimed at explaining an overview of cross replication between PostgreSQL and MySQL, and further discussing the methods of configuring cross replication between the two database servers.

(Frederic Descamps) Do you know that it’s possible to get information from the CPUs of your MySQL Server from SQL ?

(Uday Varagani) Foreign key related issues are very common when dealing with DDL changes in MySQL using Percona toolkit.

(Federico Razzoli) There are many non-obvious ways to return values from MySQL stored procedures, and each of them solves particular problems.

(Frederic Descamps) If you just migrated to MySQL 8.0, you may have seen that the default authentication plugin has been changed to a more secure one: caching_sha2_password and I’ve already written some articles about it.

(abhinav prasad gupta) We might have different scenarios once we need to stop MySQL service before performing either server or database activity like patching/upgrade.

(Uday Varagani) Recently, I received a support request where the customer wanted to convert an INTEGER column to BIGINT on two tables. These tables are related by a foreign key, and it is a 3 node PXC cluster.

(Federico Razzoli) Before reading this article, I suggest to read Indexes bad practices, if you missed it.