Restore Controller to Default Settings

This article describes how to restore a Controller to default settings. It can be if for some reason the CMON DB has been corrupted and you quickly want to get it up again.

Pre-requisites:

• a deployment package 
• the controller server is reachable by ssh

Process:

There are 11 steps to restore the controller:

In this example our deployment package is located in /root/s9s-galera-percona-2.4.0

1. make sure the cc mysql server is stopped 
2. cp -rf <MYSQL_DATADIR>/mysql <MYSQL_DATADIR>/mysql-bak 
3. rm -rf <MYSQL_DATADIR>/cmon 
4. rm -rf <MYSQL_DATADIR>/dcps 
5. rm -rf <MYSQL_DATADIR>/ib*
6. Start the mysql server and make sure it is started:
service mysql start
mysql -ucmon -p -h127.0.0.1  

Go into your deployment package, e.g: 
6. cd s9s-galera-percona-2.4.0/mysql/scripts/install 
7. ./install-cmon.sh -s 
8. service cmon restart
9. cat s9s-galera-percona-2.4.0/mysql/scripts/install/.s9s/config |grep token
10. Register the UI: 
https://<CC IP ADDR>/cmonapi/