I am new to DBA role, and wanted to know if there was any commands (or free software) that come with Mysql 5.5 (master/slave/slave) replication to quickly get familiar with
the database, and also making sure my.cnf is set up with the correct parameters.
Mysql – What would be the first things you do to find out about an MYSQL environment you are taking over
MySQLmysql-5.5mysql-workbench
Related Question
- Mysql replication – Error No. 1146&1062
- MySQL 5.5 – How to Disable UTF8MB4 Entirely
- Mysql – What are the ports and directionality of the TCP connections used in MySQL replication
- Mysql – Remove master role from MySQL server
- MySQL Master-Master Replication – Handling Duplicate Key Issues
- Mysql – Non-Replicating commands from (master) Mysql 5.5.40 to (slave) MariaDB 10.0.19
- Mysql – Master slave replication with different thesql version is on both slave and master
- Mysql – Broken Slave MySQL : How To Fix MySQL Replication (BINLOG) error in the Slave
Best Answer
The pt-mysql-summary tool from Percona toolkit gives you a very nice overview of your running server.
It will tell you stuff like what the major config params are set to, what technologies ara available in your server, take a 10 second status sample, analyze your schema etc.
Also worth to run pt-duplicate-key-checker at least once, to detect redundant keys.
I'm authoring the common_schema tool for MySQL, which also offers some diagnostics: the redundant_keys view is parallel to pt-duplicate-key-checker; the data_size_per_schema view will tell you, well, the datasize per schema; the auto_increment_columns view will tell you about "free space" in your AUTO_INCREMENT columns; and more.
Watching the processes as they go, using
innotop
or the old-timermytop
is also worthwhile: get to know the processes that run most, the longest etc.