[asterisk-users] Asterisk with MySQL Cluster

[Tilghman Lesher]

On Tuesday 30 November 2010 18:34:17 Duane Larson wrote:
> 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?

Yes, if you refer to configs/extconfig.conf.sample, within the Asterisk 1.8
tree, you'll see that realtime supports multiple lines per realtime family,
scored by consecutive priorities.  1 is the default, but you can have as
many as you'd like.

Additionally, for res_config_odbc, there is a setting in res_odbc.conf
called "negative_connection_cache", which is the length of time that
Asterisk remembers that a connection is down before it will once again
attempt to connect.  The intention, of course, is that once the primary
comes back up, you'll want the Asterisk server to revert back to using it.

-- 
Tilghman Lesher
Digium, Inc. | Senior Software Developer
twitter: Corydon76 | IRC: Corydon76-dig (Freenode)
Check us out at: www.digium.com & www.asterisk.org