Обсуждение: Synchronization Master -> Slave
I've serious problems with slow link between continents, and twice a week I have to manually reestablish the slave, by running the following script:
------------------------------------------------------------------------------------------------------------------------------------------
psql -c "SELECT pg_start_backup('standby_sync', true)"
rsync --progress -a ${PGDATA}/* root@server2.mycompany.com:/opt/pgsql/slave1/ --exclude postmaster.pid --exclude postgresql.conf --exclude pg_hba.conf --exclude pg_log --exclude pg_xlog
psql -c "SELECT pg_stop_backup()"
------------------------------------------------------------------------------------------------------------------------------------------
Point is not to analyze the connection issues between the continents, but if there is a way better to synchronize these servers, and avoid to transport 8Gb of data between them when syncronizing.
The rsync above can be optimized? Both servers are CentOS 5 with OpenVPN established between them (this is one of the problems: the VPN keep falling several times a day, and then finally, the sender and receiver process just vanish in the air - and I had no time to investigate the vanishment).
Thanks in advance for your help,
------------------------------------------------------------------------------------------------------------------------------------------
psql -c "SELECT pg_start_backup('standby_sync', true)"
rsync --progress -a ${PGDATA}/* root@server2.mycompany.com:/opt/pgsql/slave1/ --exclude postmaster.pid --exclude postgresql.conf --exclude pg_hba.conf --exclude pg_log --exclude pg_xlog
psql -c "SELECT pg_stop_backup()"
------------------------------------------------------------------------------------------------------------------------------------------
Point is not to analyze the connection issues between the continents, but if there is a way better to synchronize these servers, and avoid to transport 8Gb of data between them when syncronizing.
The rsync above can be optimized? Both servers are CentOS 5 with OpenVPN established between them (this is one of the problems: the VPN keep falling several times a day, and then finally, the sender and receiver process just vanish in the air - and I had no time to investigate the vanishment).
Thanks in advance for your help,
--
Edson Carlos Ericksson Richter SimKorp Informática Ltda | |
Fone: | (51) 3366-7964 |
Celular: | (51)9318-9766/(51) 8585-0796 |
![]() |
Вложения
Check your hotmail inbox. You have an answer there.
--
Sergey Konoplev
a database and software architect
http://www.linkedin.com/in/grayhemp
Jabber: gray.ru@gmail.com Skype: gray-hemp Phone: +79160686204
On Thu, Jul 19, 2012 at 3:35 PM, Edson Richter <richter@simkorp.com.br> wrote:
I've serious problems with slow link between continents, and twice a week I have to manually reestablish the slave, by running the following script:
------------------------------------------------------------------------------------------------------------------------------------------
psql -c "SELECT pg_start_backup('standby_sync', true)"
rsync --progress -a ${PGDATA}/* root@server2.mycompany.com:/opt/pgsql/slave1/ --exclude postmaster.pid --exclude postgresql.conf --exclude pg_hba.conf --exclude pg_log --exclude pg_xlog
psql -c "SELECT pg_stop_backup()"
------------------------------------------------------------------------------------------------------------------------------------------
Point is not to analyze the connection issues between the continents, but if there is a way better to synchronize these servers, and avoid to transport 8Gb of data between them when syncronizing.
The rsync above can be optimized? Both servers are CentOS 5 with OpenVPN established between them (this is one of the problems: the VPN keep falling several times a day, and then finally, the sender and receiver process just vanish in the air - and I had no time to investigate the vanishment).
Thanks in advance for your help,--
Edson Carlos Ericksson Richter
SimKorp Informática LtdaFone: (51) 3366-7964 Celular: (51)9318-9766/(51) 8585-0796
Sergey Konoplev
a database and software architect
http://www.linkedin.com/in/grayhemp
Jabber: gray.ru@gmail.com Skype: gray-hemp Phone: +79160686204