How to Fix MySql

Owned by: Navid Golpayegani

MySQL is a multi-threaded, multi-user SQL database management system which runs as a server and provides access to multiple databases.

 To Test

• Check: Nagios MySQL Service Group
  • Note that the MySQL Master and slave are identified in the Service column.
  • Tip: For additional status information on the Master and Slave, click on their respective stoplight icons in the Actions column.
    
    
• To Fix:  (root permission is required to perform the following procedures)
  Note that the most common problem is that u02 on the master server fills up.
  To Fix u02 :
  
  1. Login to the slave mysql server as: root
  2. At the prompt enter: mysql 
  3. At the prompt, enter: show slave status   A table with an entry of what the latest binary file the slave is reading is (e.g., mysql-bin.XXXXXX) will be displayed. 
  4. Go to the master mysql server (glastlnx01) and login as: root 
  5. At the prompt, enter: purge master logs to mysql-bin.XXXXXX-1   where: XXXXXX is the same as from the slave in the previous command decremented by 1.
     
     
• To Fix All Other Problems: All other problems can usually be fixed by restarting the master mysql server (glastlnx01).
  1. Login to the master mysql server (glastlnx01) as: root
  2. At the command line, enter: /etc/init.d/mysql restart