On Tue, 26 Dec 2006, Ben wrote:
On Dec 26, 2006, at 7:30 AM, Marc Evans wrote:
What I have not been able to come up with a good semi-general purpose
solution to is cross-data-center HA.
Why does log shipping not work for you?
Well, it may, but is short, I believe that this comes down to how to deal
with various failure scenarios. For example, consider a situation where a
data center is cut off from communications with other data centers. Do all
data centers need to switch to a read-only operational mode, or is one of
the centers elected the master? What about a pair of islands, wherein 2
seperate sets of data centers are cut off from each other, but see some
subset of other data centers? For a general purpose solution, some form of
multi-master seems logical, but of course, doesn't yet exist.
- Marc
---------------------------(end of broadcast)---------------------------
TIP 9: In versions below 8.0, the planner will ignore your desire to
choose an index scan if your joining column's datatypes do not
match
