MySQL Workbench - A Swiss Army Knife DBA Tool for non-DBAs

By Dave Stokes

Elevator Pitch

Are you in charge of a MySQL database but not a database administrator? Then you need a copy of MySQL Workbench (free). Workbench is designed to take away the drudgery of CLI admin work, shows you what is going on with your servers graphically, and walks you through tasks to save you time!

Description

Are you in charge of a MySQL database but not a database administrator? Then you need a copy of MySQL Workbench (free). Workbench is designed to take away the drudgery of CLI admin work, shows you what is going on with your servers graphically, and walks you through tasks to save you time and effort! Come learn how to document and reverse engineer databases. Finally see how to discover who is hogging the resources of your server, which indexes are redundant, and understand what processes are lock which tables. Plus you will see the MySQL Utilities that can copy databases, run diffs on schemas, set up automatic fail over between servers, and hunt down bad processes. This tool is designed to aid those who do not have time to dig through manual pages but still need to keep their databases flying.