Difference between revisions of "Satelite servers"

From TempusServa wiki
Jump to navigation Jump to search
old>Admin
old>Admin
Line 32: Line 32:


   mysql -uLocalUser -pLocalPW --tables tslive.systempolicy < policy.sql
   mysql -uLocalUser -pLocalPW --tables tslive.systempolicy < policy.sql
=== changes to master server ===
=== changes to slave server ===
=== testing the setup ===

Revision as of 07:53, 9 November 2017

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