Juha Heinanen wrote:
Christian Schlatter writes:
What issues are you referring to? We are using
openser together
with a > mysql 5.0 cluster for quite some time and never
had any issues.
how do you upgrade your openser tables when new fields are
added/removed, which happens on every new release?
We use a combination of mysql cluster 5.0.x for the location
table and master/slave replication for everything else for
over a year now.
Altering the cluster table is basically done by:
- disabling all except one node at the SIP load balancer and
stop mysql on the disabled nodes
- putting the remaining active node into single-user-mode
- altering the table on this node
- exiting single-user-mode
- putting back the deactivated nodes into the system
You have to schedule that to a time of day where one
proxy/registrar can handle all the traffic, but beside that
it works quite smoothly...
Cheers,
Andreas
This is essentially what we're planning to do, with the exception that
we're developing using 5.1 and all of our tables will be on MySQL
Cluster (since we can use disk-based storage for NDB Cluster). It has
thus far been successful, especially with the upgrade from 1.1.1 to 1.2
recently in our development environment.
It's good to know we're not completely out in the woods...
- Brad
The contents of this e-mail are intended for the named addressee only. It contains
information that may be confidential. Unless you are the named addressee or an authorized
designee, you may not copy or use it, or disclose it to anyone else. If you received it in
error please notify us immediately and then destroy it.