(RADIATOR) High Availability with MySQL

[Hartmaier Alexander]

Hi!

We use two radiator servers which both connect to an Oracle database which will use Veritas Cluster software soon.
The last years it was just an Oracle db with Data Guard (replicates all db changes to another db node, must be switched manually in case of primary db failure, which never happened).

I'm sure you're looking for a cheaper solution (our Oracle db isn't only used for radiator) and maybe you try heartbeat2 which is very configurable for the db ha part.

To sync the config changes we've written a simple script.

-Alex


> -----Original Message-----
> From: owner-radiator at open.com.au [mailto:owner-radiator at open.com.au] On
> Behalf Of Joe (Mobile)
> Sent: Sunday, January 21, 2007 8:54 AM
> To: radiator at open.com.au
> Subject: (RADIATOR) High Availability with MySQL
> 
> We've got our Radiator setup to work with a database as backend for
> authentication and accounting. Now my only concern is that high
> availability and redundancy isn't warranted in the current single
> machine setup. Therefore I'm desperately searching for ways to achieve
> this with minimal to mediocre costs.
> 
> I've searched and read a bit about high availability on this list, but
> most of the posts are quite out-dated and only a few mention actual
> working setups beyond pure theory. So I was wondering if someone had
> such a setup running or could give a few thoughts about the available
> options.
> 
> I've read that multiple Radiator instances can work together out of
> one database - is that right? Are there any MySQL redundancy options
> out there other than MySQL Cluster (which has quite a few limitations
> and needs tremendous amounts of RAM) or chain replication (which is a
> horror to bring back online after an outage)?
> 
> I've also heard about a product from emicnetworks (now called
> continuent) which also have an open sourece solutution (see
> continuent.org) for building a special type of database cluster, but I
> haven't found anyone who used it and could give a few thoughts about
> it. Has anyone here worked with that and had success?
> 
> Any help would be much appreciated!
> 
> --
> 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.

*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
T-Systems Austria GesmbH   Rennweg 97-99, 1030 Wien
Handelsgericht Wien, FN 79340b
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*
Notice: This e-mail contains information that is confidential and may be privileged.
If you are not the intended recipient, please notify the sender and then delete this e-mail immediately.
*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*"*


--
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.