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) == | |||
=== basic installation === | |||
First do a normal TS installation | First do a normal TS installation | ||
| Line 12: | Line 14: | ||
telnet sateliteServer 3306 | telnet sateliteServer 3306 | ||
=== synchronizing master and satelite === | |||
Initially the servers should look alike so it is much easier to stream all data across | 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 | mysql -uLocalUser -pLocalPW > mysql -uRemoteUser -pRemotePW | ||
On the SATELITE server reload configutations | |||
mysql -uLocalUser -pLocalPW --tables tslive.systempolicy < policy.sql | |||
Revision as of 09:32, 8 September 2017
setting up a satelite server (work in progress)
basic installation
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