Master and Slave Redundancy Mysql,Psotgres and confiles

[angurisudhakar]

Hi,


In NagiosXI Master and slave failover ,I need solution for a Master and Slave redundancy for Mysql DB ,Postgres and all the conf files of master is down.


Please help me out in this.


Thanks,
Sudhakar Anguri

[abrist]

You could use a drbd volume for them - just symlink their old location to the drbd volume. Otherwise, you will have to offload the dbs, setup db replication, and then make sure both XI servers can reach the db cluster, but only 1 at a time may write to them. This is easiest done with a virtual ip as you can lock down the db to just the virtual ip - that way, whichever sever is master (has the vip) is the only one that can talk to the db.

[angurisudhakar]

Ok thanks for input Mysql DB i will use DRBD or Replication either one i will use.

But I need hosts and service conf file ,how it will replicate in slave server.


Thanks,
Sudhakar Anguri

[abrist]

You have a number of options:
1. Rsync the config files folder.
2. Host the nagios ./etc folder on a drbd volume
3. Cron job?
4. etc.
There are many, many ways.

[angurisudhakar]

Ok.. i will try with RSYNC..

Thanks for your quick response .