Hello,
I have been considering a replacement for our mysql databases that
receive queries from live internet apps. mysql replication has
demonstrated itself to be much too fragile to maintain, especially
across datacenters (private T3 link between).
My question is, is it possible to configure mysql cluster with say a
configuration like this?
Location A <-T3-> Location B
2 MySQL API Nodes 2 MySQL API Nodes
3 Storage Nodes (one also master) 3 Storage Nodes (...)
Is it possible to configure the system without using mysql replication
and partition the data where each location can run successfully if the
other location is unavailable or gets blown up etc.
Eg, T3 goes down, or Location A is unavailable. What happens when
Location A comes back online? Will the data be resync'd?
I am guessing this is not possible, that I would have to continue
running mysql replication between the two datacenters and run them as
two discreet clusters. I would love it if someone would smack me down
and tell me I am oh so wrong. :)
--
Richard F. Rebel
rrebel@stripped
t. 212.239.0000
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
Attachment: [application/pgp-signature] This is a digitally signed message part signature.asc
