Search Postgresql Archives

Re: Choosing PostgreSQL as the database for our next project

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



Johnny Ljunggren wrote:
William Yu wrote:

What I'm not sure about though is what would happen with 2 slaves if main goes down AND the connection between center 1 & 2 is also disconnected. Others with more experience with the various master/slave replication solutions might want to chime in now on how it would work.


Well, this might be a problem, because there is no connection between center 1 and 2, so they will basically live their own lives as long as the connection to main center is down.

This would mean your system goes from Master-Slave to Multi-Master if your main DB goes down. Roll your own replication time.

---------------------------(end of broadcast)---------------------------
TIP 1: if posting/reading through Usenet, please send an appropriate
      subscribe-nomail command to majordomo@xxxxxxxxxxxxxx so that your
      message can get through to the mailing list cleanly

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]
[Index of Archives]     [Postgresql Jobs]     [Postgresql Admin]     [Postgresql Performance]     [Linux Clusters]     [PHP Home]     [PHP on Windows]     [Kernel Newbies]     [PHP Classes]     [PHP Books]     [PHP Databases]     [Postgresql & PHP]     [Yosemite]
  Powered by Linux