Difference between revisions of "Satelite servers"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
old>Admin
Line 2: Line 2:
== setting up a satelite server (work in progress) ==
== setting up a satelite server (work in progress) ==


=== basic installation ===
=== basic installation Linux ===
First do a normal TS installation
First do a normal TS installation



Revision as of 09:36, 8 September 2017

setting up a satelite server (work in progress)

basic installation Linux

First do a normal TS installation

Add access to the MySQL database

 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