(RADIATOR) sql database backup

[Andy De Petter]

Jesús M Díaz wrote:

> Hi all,
> 
> I know that subject has been already discussed, but i have not clear
> ideas about it, yet.
> 
> I run two Radiator Servers over two hosts. They both use a sql db
> (MySql), and I have a backup of that database, but ... if Radiator is
> up but MySql is down, how could Radiator use the secondary sql db?
> 
> When Radiator runs as a Proxy Radius, it can be configured to use a
> second server (or more) if the first one goes down. I think it could
> be a useful option something like that with sql access. If we could
> configure more then one 'DBSource' Radiator could use ther first one,
> and, if it does nos answer, then the second, and so on
> 
> There is any way to do that now? Someone have any idea about it?
> 
> Thnak you.
> 
> 
> Jesus M Diaz <jesus.diaz at telia-iberia.com>
> 
> Telia Iberia, S.A.
> Planificación y Diseño de Red
> Tfno: +34 91 623 2909
> Fax: +34 91 623 2911
> 
> 
> ===
> Archive at http://www.open.com.au/archives/radiator/
> Announcements on radiator-announce at open.com.au
> To unsubscribe, email 'majordomo at open.com.au' with
> 'unsubscribe radiator' in the body of the message.
> 

Use 2 DBSource's in your AuthBy clause.


DBSource        dbi:mysql:YOURDB1:YOURIP1
DBUsername      YOURUSER1
DBAuth          YOURPASS1

DBSource 
dbi:mysql:YOURDB2:YOURIP2
DBUsername 
YOURUSER2
DBAuth 
	YOURPASS2

etc...

Radiator will take the next one, if the first goes down, and start all 
over again, once it has reached its last one afaik (with a "pause" in 
between, if they are all down).

hth,

-Andy

-- 

*** DISCLAIMER ***
This e-mail and any attachments thereto may contain information, which
is confidential and/or protected by intellectual property rights and
are intended for the sole use of the recipient(s) named above. Any use
of the information contained herein (including, but not limited to,
total or partial reproduction, communication or distribution in any
form) by persons other than the designated recipient(s) is prohibited.
If you have received this e-mail in error, please notify the sender
either by telephone or by e-mail and delete the material from any
computer. Thank you for your cooperation.



===
Archive at http://www.open.com.au/archives/radiator/
Announcements on radiator-announce at open.com.au
To unsubscribe, email 'majordomo at open.com.au' with
'unsubscribe radiator' in the body of the message.