Difference between revisions of "Satelite servers"
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 | 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 | Test access from the MASTER server | ||
telnet sateliteServer 3306 | telnet sateliteServer 3306 | ||
=== synchronizing master and satelite === | === synchronizing master and satelite === | ||
Revision as of 09: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