Category: Databases

Adding a custom MySQL prompt

September 1, 2018 by richardvk

Filed under Databases

Last modified September 1, 2018

I often work on multiple database instances at the same time. For example, i might be comparing table definitions between a development and production server, or if using a cluster like Percona XtraDB Cluster, you may have sessions open to each of three (or more) of the node servers at the same time to check their synchronisation statuses. Whatever the use case, its extremely helpful …

MySQLdump, useful tips and summary notes

February 1, 2018 by richardvk

Filed under Databases

Last modified February 5, 2018

Dumping databases for backups is absolutely essential, but like all things in life, you can never get everything you want – there are tradeoffs….   The most important points probably when dumping databases are: We want it to be as quick as possible We want it to have as little as impact as possible (preferably NO impact) on users experience We want a backup that …