Difference between revisions of "Satelite servers"

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


== setting up a satelite server (work in progress) ==
== 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 ===
=== basic installation Linux ===
First do a normal TS installation
First do a normal TS installationon the SATELITE server


Add access to the MySQL database
Add access to the MySQL database on the SATELITE server


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


Test access from the master server
Test access from the MASTER server


   telnet sateliteServer 3306
   telnet sateliteServer 3306


=== synchronizing master and satelite ===
=== synchronizing master and satelite ===

Revision as of 10:38, 8 September 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