(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.
Tag: Open Source
‘MySQL High Availability tools’ followup, the missing piece: orchestrator
(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.
Evaluation of PMP Profiling Tools
(Alexey Stroganov) In this blog post, we’ll look at some of the available PMP profiling tools.
MySQL High Availability tools – Comparing MHA, MRM and ClusterControl
(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.
Network attacks on MySQL, Part 5: Attack on SHA256 based passwords
(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.
Basics of MySQL Administration and best practices
(Lalit) Following are the few best practices and basic commands for MySQL Administration.
MySQL DevOps First Step: Revision Control
(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.
Performance Evaluation of SST Data Transfer: With Encryption (Part 2)
(Alexey Stroganov) In this blog post, we’ll look at the performance of SST data transfer using encryption.
Experiments with MySQL 5.7’s Online Buffer Pool Resize
(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.
How to setup MaxScale with MariaDB Galera Cluster
(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.
