Difference between revisions of "Satelite servers"
Jump to navigation
Jump to search
old>Admin (→=) |
m (8 revisions imported) |
||
| (6 intermediate revisions by one other user not shown) | |||
| Line 1: | Line 1: | ||
== setting up a satelite server (work in progress) == | |||
Add access to the MySQL database | 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 | 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 === | |||
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 === | |||
Latest revision as of 11:55, 10 December 2021
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