Page 1 of 1
Master and Slave Redundancy Mysql,Psotgres and confiles
Posted: Mon Jul 14, 2014 7:37 am
by 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
Re: Master and Slave Redundancy Mysql,Psotgres and confiles
Posted: Mon Jul 14, 2014 11:43 am
by 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.
Re: Master and Slave Redundancy Mysql,Psotgres and confiles
Posted: Mon Jul 14, 2014 11:55 am
by 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
Re: Master and Slave Redundancy Mysql,Psotgres and confiles
Posted: Mon Jul 14, 2014 12:12 pm
by 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.
Re: Master and Slave Redundancy Mysql,Psotgres and confiles
Posted: Mon Jul 14, 2014 12:18 pm
by angurisudhakar
Ok.. i will try with RSYNC..
Thanks for your quick response .
