Author - Pablo Padua

The mysqlpump Utility

mysqlpump

In this blog, we’ll look at the
mysqlpump utility.

mysqlpump is a utility that performs logical backups (which means backing up your data as SQL statements instead of a raw copy of data files). It was added in MySQL Server version 5.7.8, and can be used to dump a database or a set of databases to a file and […]

Read more

How to Move a MySQL Partition from One Table to Another

Move a MySQL Partition

In this blog post we’ll look at how to move a MySQL partition from one table to another, for MySQL versions before 5.7.
Up to version 5.7, MySQL had a limitation that made it impossible to directly exchange partitions between partitioned tables. Now and then, we get questions about how to import an .ibd for use […]

Read more

Using the MySQL super_read_only system variable

super_read_only system variable

This blog post will discuss how to use the MySQL super_read_only system variable.
It is well known that replica servers in a master/slave configuration, to avoid breaking replication due to duplicate keys, missing rows or other similar issues, should not receive write queries. It’s a good practice to set
read_only=1 on slave servers to prevent any […]

Read more

MySQL password expiration features to help you comply with PCI-DSS

password_expired feature which allows to set a user’s password as expired.
This has been added to the mysql.user table and its default value it’s “N.” You can change it to “Y” using the
ALTER USER statement.
Here’s an quick example on how to set expiration date for a MySQL user account:

Shell

mysql> ALTER USER ‘testuser’@’localhost’ PASSWORD EXPIRE;

1

mysql> ALTER […]

Read more

How to upgrade your master server with minimal downtime

Here’s a step-by-step guide on how to invert roles for master and slave so you can perform a master server upgrade, and then switch roles back to the original setup.
* While following this guide consider server-A as your original master and server-B as your original slave. We will assume server-B already produces binlogs and that […]

Read more