MySQL Workbench Alternatives – ClusterControl Database User Management
MySQL user and privilege management is very critical for authentication, authorization and accounting purposes. Since MySQL 8.0, there are now two types of database user privileges: Static privileges - The common global, schema and administrative...
MySQL Workbench Alternatives – ClusterControl Configuration Management
MySQL configuration management consists of two major components - MySQL configuration files and runtime configuration. Applying configuration changes on the runtime environment can be done through MySQL server clients with no privilege for session variables...
Preparing a MySQL or MariaDB Server for Production – Part Two
In the previous blog, we have covered some tips and tricks to prepare a MySQL server for production usage from a system administrator perspective. This blog post is the continuation... Use a Database Backup Tool...
How to Restore a Single MySQL Table Using mysqldump?
Mysqldump is the most popular logical backup tool for MySQL. It is included in the MySQL distribution, so it’s ready for use on all of the MySQL instances. Logical backups are not, however, the fastest...
Preparing a MySQL or MariaDB Server for Production – Part One
It is extremely important to install and configure a production MySQL server with the necessary packages and tools to smooth-out the operations in the long run. We have seen many cases where troubleshooting or tuning...
Database Backups 101: What is Point in Time Recovery?
Point-in-Time Recovery (PITR) allows a database administrator to restore or recover a set of data from a backup from a particular time in the past, using a tool or a system. Once PITR starts logging...
How to Replace an Intermediate MySQL or MariaDB Master with a Binlog Server using MaxScale
Binary logs (binlogs) contain records of all changes to the databases. They are necessary for replication and can also be used to restore data after a backup. A binlog server is basically a binary log...
How to Fix a Lock Wait Timeout Exceeded Error in MySQL
One of the most common InnoDB errors is InnoDB lock wait timeout exceeded, for example: SQLSTATE[HY000]: General error: 1205 Lock wait timeout exceeded; try restarting transaction The above simply means the transaction has reached the...
How to Rebuild an Inconsistent MySQL Slave?
MySQL slaves may become inconsistent. You can try to avoid it, but it’s really hard. Setting super_read_only and using row-based replication can help a lot, but no matter what you do, it is still possible...
Setting Up a Geo-Distributed Database Cluster Using MySQL Replication
A single point of failure (SPOF) is a common reason why organizations are working towards distributing the presence of their database environments to another location geographically. It's part of the Disaster Recovery and Business Continuity...
Using MariaDB Flashback on a MySQL Server
MariaDB has introduced a very cool feature called Flashback. Flashback is a feature that will allow instances, databases or tables to be rolled back to an old snapshot. Traditionally, to perform a point-in-time recovery (PITR),...
How to Protect Your MySQL & MariaDB Database Against Cyberattacks When on a Public Network
It is sometimes inevitable to run MySQL database servers on a public or exposed network. This is a common setup in a shared hosting environment, where a server is configured with multiple services and often...