[asterisk-dev] Realtime Failover - Multiple DSNs

[Tilghman Lesher]

On Monday 27 June 2011 04:26:50 Stuart Elvish wrote:
> This was originally posted on the asterisk-users list but I didn't
> receive any responses. Here's hoping that someone on the dev list can
> point me in the right direction.
> 
> I currently have 3 servers setup to provide a small MySQL cluster. I
> can easily run custom database queries via func_odbc and res_odbc with
> failover DSN's (up to five) but I can't seem to add any failover DSN's
> into the realtime configuration file (extconfig.conf). Has anyone been
> able to configure either the standard ODBC driver or Asterisk to use a
> failover DSN for realtime system configuration?
> 
> Currently my extconfig.conf has a setup something similar to this:
> sippeers => odbc,mysql-asterisk,sipendpoints but being

sippeers => odbc,mysql1,sipendpoints,1
sippeers => odbc,mysql2,sipendpoints,2
sippeers => odbc,mysql3,sipendpoints,3

and in res_odbc.conf:

[mysql1]
...
negative_connection_cache => 300

[mysql2]
...
negative_connection_cache => 300

-- 
Tilghman