Replication - if the master fails...

2002-12-04 Thread Stephen Patterson
We're currently operating 1 MySQL server and are investigating methods for having a primary and secondary server (with the secondary taking over if the primary fails). I know about replication in MySQL, and was thinking of using that to keep the secondary in sync, if the primary should fail, i

Re: Perl DBI or C++ API Help!

2002-12-04 Thread Stephen Patterson
Sarah Killcoyne wrote: I need to be able to connect to mysql through a perl or C++ script without knowing the name of the database to connect to. I can't seem to find a way to do this. Is it possible to either: look up database names so I can pick one before connecting or connect without a data