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 e-mail is confidential and may well also be legally privileged. If you have received it in error, you are on notice of its status. Please notify us immediately by reply e-mail and then delete this message from your system. Please do not copy it or use it for any purposes, or disclose its contents to any other person: to do so could be a breach of confidence. Thank you for your cooperation. Information pursuant to paragraph 14 Austrian Companies Code: UPC Austria GmbH; Registered Office: Wolfganggasse 58-60, 1120 Vienna Company Register Number: FN 189858d at the Commercial Court of Vienna