(Rob Gravelle) Both the Importing XML Data into MySQL Tables Using a Stored Procedure and the Enhance Your MySQL XML Import Procedures using Prepared Statements tutorials described a way to overcome MySQL’s import restrictions using the “proc-friendly” Load_File() and ExtractValue() functions.

(Shlomi Noach) I read with interest MySQL High Availability tools – Comparing MHA, MRM and ClusterControl by SeveralNines. I thought there was a missing piece in the comparison: orchestrator, and that as result the comparion was missing scope and context.

(Alexey Stroganov) In this blog post, we’ll look at some of the available PMP profiling tools.

(Krzysztof Ksiazek) We previously compared two high availability solutions for MySQL – MHA and MariaDB Replication Manager and looked into how they performed fail-over. In this blog post, we’ll see how ClusterControl stacks up against these solutions.

(Daniel van Eeden) The mysql_sha256_password doesn’t use the nonce system which is used for mysql_new_password, but instead forces the use of RSA or SSL.

(Lalit) Following are the few best practices and basic commands for MySQL Administration.

(Sheeri K. Cabral) MySQL environments are notorious for being understaffed – MySQL is everywhere, and an organization is lucky if they have one full-time DBA, as opposed to a developer or sysadmin/SRE responsible for it.

(Alexey Stroganov) In this blog post, we’ll look at the performance of SST data transfer using encryption.

(Fernando Ipar) One of the interesting features introduced in MySQL 5.7 is that innodb_buffer_pool_size is a dynamic variable (since 5.7.5, to be more specific). Yet, past experience tells us that just because a variable is dynamic, it does not make it is safe to change it on the fly.

(Nilnandan Joshi) This post is just following up my previous blog post which describes how to setup 3-nodes MariaDB Galera Cluster with MySQL-Sandbox on single server.