Featured
Percona Products
Percona Services
Use Cases
Pablo PaduaIn 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 […]
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 […]
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 […]
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:
|
1 |
mysql> ALTER USER 'testuser'@'localhost' PASSWORD EXPIRE; |
Once this is set to […]
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 […]