Chapter 10. Restore the Database

Procedure

1. Execute the following to restore the database tables. Ensure the openstack_database.sql file name includes the appropriate timestamp.

   [root@overcloud-controller-0]# mysql -u root < openstack_database.sql
   [root@overcloud-controller-0]# mysql -u root < grants.sql

   Copy to Clipboard Toggle word wrap

2. Execute clustercheck on the current node.

   [root@overcloud-controller-0]# /bin/clustercheck

   Copy to Clipboard Toggle word wrap

3. Test clustercheck via xinetd.d:

   curl overcloud-controller-0.example.com:9200
   curl overcloud-controller-1.example.com:9200
   curl overcloud-controller-2.example.com:9200

   Copy to Clipboard Toggle word wrap

4. Finally, remove the iptables rule from each node to restore access to database.

   [root@overcloud-controller-0]# iptables -D INPUT -d 192.168.1.10 -p tcp --dport 3306 -j DROP
   [root@overcloud-controller-1]# iptables -D INPUT -d 192.168.1.10 -p tcp --dport 3306 -j DROP
   [root@overcloud-controller-2]# iptables -D INPUT -d 192.168.1.10 -p tcp --dport 3306 -j DROP

   Copy to Clipboard Toggle word wrap