The only thing I found workable, is to use a hostname (i.e. asterisk_sql) and update /etc/hosts according to which SQL server is up or down.
It's a bit of a hassle, and it would be easier if Asterisk supported fallback SQL servers, but once done it works well. Mike From: asterisk-users-boun...@lists.digium.com [mailto:asterisk-users-boun...@lists.digium.com] On Behalf Of Duane Larson Sent: Tuesday, November 30, 2010 7:34 PM To: Asterisk Users Mailing List - Non-Commercial Discussion Subject: [asterisk-users] Asterisk with MySQL Cluster I have MySQL Cluster set up for OpenSIPS which allows for the best Redundant High-Availability. I was wondering if it's possible for Asterisk to also use multiple database servers for Realtime? Currently with Realtime I am only able to point to a single IP address for a database. If that database server goes down that Asterisk is pointed to then Asterisk won't be able to do anything. Any options within Asterisk 1.8 to make it more fault tolerant when it comes to Realtime and databases?
-- _____________________________________________________________________ -- Bandwidth and Colocation Provided by http://www.api-digital.com -- New to Asterisk? Join us for a live introductory webinar every Thurs: http://www.asterisk.org/hello asterisk-users mailing list To UNSUBSCRIBE or update options visit: http://lists.digium.com/mailman/listinfo/asterisk-users