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
_______________________________________________
Users mailing list
[email protected]
http://openser.org/cgi-bin/mailman/listinfo/users
