|
From: Thibault M. <thi...@ec...> - 2014-04-30 15:12:17
|
Hi, I am setting up a High Availability (HA) architecture and I use PG-XC. Thank you very much for your work, it works fine and you are the only one active project for synchronous multi master replication. I don't understand why GTM proxies and GTM standby don't reconnect/promote themselves in case of GTM crash. At the moment, I use shell script to do this but I am not enthusiast with this because of maintenance trouble in future. Is there any reason of this lack of automation ? Still about HA feature, I realized that when all cluster start, if GTM doesn't work neither does GTM standby. Obviously database doesn't work in that case. I also made a script to handle this situation and change GTM standby config in order to transform it in GTM before starting. (Not using promote command, only changing configuration file). Maybe I missed something to make it work ? If not, could it be a new feature for future release ? You can find my script on my puppet module for postgres-xc : https://forge.puppetlabs.com/echoes/postgres_xc or https://github.com/echoes-tech/puppet-postgres_xc. Best regards, Thibault Marquand |