I labbed this up and it does look like it's possible.
*** Note: Make sure that you have known-good backups/vm snapshots before making any modifications and perform this in a test environment until your confident you don't have any outstanding issues!
https://assets.nagios.com/downloads/nag ... ios-XI.pdf
Here's what I did:
- Installed XI on two separate servers:
XI1 - 192.168.232.21
XI2 - 192.168.232.37
DB - 192.168.232.23
- Followed the offload instructions for both of them:
https://assets.nagios.com/downloads/nag ... Server.pdf
When it came time to create the databases:
DB Server:
Code: Select all
create database nagios_a;
create database nagios_b;
create database nagiosql_a;
create database nagiosql_b;
create database nagiosxi_a;
create database nagiosxi_b;
GRANT ALL ON nagios_a.* TO nagios@'192.168.232.21' IDENTIFIED BY 'nagios';
GRANT ALL ON nagios_b.* TO nagios@'192.168.232.37' IDENTIFIED BY 'nagios';
GRANT ALL ON nagiosql_a.* TO nagiosql@'192.168.232.21' IDENTIFIED BY 'nagiosql';
GRANT ALL ON nagiosql_b.* TO nagiosql@'192.168.232.37' IDENTIFIED BY 'nagiosql';
GRANT ALL ON nagiosxi_a.* TO nagiosxi@'192.168.232.21' IDENTIFIED BY 'nagiosxi';
GRANT ALL ON nagiosxi_b.* TO nagiosxi@'192.168.232.37' IDENTIFIED BY 'nagiosxi';
Then
check the connectivity status from
XI1:
Code: Select all
echo 'STATUS;' | mysql -u nagios -p'nagios' -h 192.168.232.23 nagios_a
echo 'STATUS;' | mysql -u nagiosql -p'nagiosql' -h 192.168.232.23 nagiosql_a
echo 'STATUS;' | mysql -u nagiosxi -p'nagiosxi' -h 192.168.232.23 nagiosxi_a
Then
check the connectivity status from
XI2:
Code: Select all
echo 'STATUS;' | mysql -u nagios -p'nagios' -h 192.168.232.23 nagios_b
echo 'STATUS;' | mysql -u nagiosql -p'nagiosql' -h 192.168.232.23 nagiosql_b
echo 'STATUS;' | mysql -u nagiosxi -p'nagiosxi' -h 192.168.232.23 nagiosxi_b
If there are any connectivity issues from the above commands they need to be fixed before moving onto the next portion.
Migrate the data:
On XI1:
Code: Select all
mysqldump -u root -p'nagiosxi' nagios | mysql -u nagios -p'nagios' -h 192.168.232.23 nagios_a
mysqldump -u root -p'nagiosxi' nagiosql | mysql -u nagiosql -p'nagiosql' -h 192.168.232.23 nagiosql_a
mysqldump -u root -p'nagiosxi' nagiosxi | mysql -u nagiosxi -p'nagiosxi' -h 192.168.232.23 nagiosxi_a
On XI2:
Code: Select all
mysqldump -u root -p'nagiosxi' nagios | mysql -u nagios -p'nagios' -h 192.168.232.23 nagios_b
mysqldump -u root -p'nagiosxi' nagiosql | mysql -u nagiosql -p'nagiosql' -h 192.168.232.23 nagiosql_b
mysqldump -u root -p'nagiosxi' nagiosxi | mysql -u nagiosxi -p'nagiosxi' -h 192.168.232.23 nagiosxi_b
Now
update the config files on
XI1 AND
XI2 following the
2 – Adjust Settings on Nagios Server on page
8 and follow to the end of the guide, make sure to use the proper DB names:
On
XI1 - Use nagios_a, nagiosql_a, and nagiosxi_a for the DB names in all of the config files
On
XI2 - Use nagios_b, nagiosql_b, and nagiosxi_b for the DB names in all of the config files
If you are having problems, please include these files from both servers:
Code: Select all
/usr/local/nagios/etc/ndo2db.cfg
/usr/local/nagiosxi/html/config.inc.php
/var/www/html/nagiosql/config/settings.php
/root/scripts/automysqlbackup
Thank you