Satelite servers

From TempusServa wiki
Jump to navigation Jump to search

setting up a satelite server (work in progress)

The following guide explains how a master / satelite server is set up.

It is assumed that you allready have the MASTER server running.

basic installation Linux

First do a normal TS installationon the SATELITE server

Add access to the MySQL database on the SATELITE server

 iptables -A INPUT -i eth0 -p tcp -m tcp --dport 3306 -j ACCEPT
 sudo /etc/init.d/networking restart

Test access from the MASTER server

 telnet sateliteServer 3306

synchronizing master and satelite

Initially the servers should look alike so it is much easier to stream all data across

On the SATELITE server dump configutations to a file

 mysqldump -uLocalUser -pLocalPW --tables tslive.systempolicy > policy.sql  

On the MASTER server stream all data

 mysql -uLocalUser -pLocalPW > mysql -uRemoteUser -pRemotePW

On the SATELITE server reload configutations

 mysql -uLocalUser -pLocalPW --tables tslive.systempolicy < policy.sql


changes to master server

changes to slave server

testing the setup