Class::DBI::Replication (MySQL) with 0.96?

[prev] [thread] [next] [Date index for 2004/10/14]

Hello Smart People!

It happens that I have to build a new project based on an existing 
database infrastructure that uses MySQL replication. The system is 
designed so that database writes should all go to the master MySQL 
server, but reads should be done against slave servers (to save load on 
the master).

I noticed that there is a Class::DBI::Replication module on CPAN, but 
that it is quite old and had only one release. I was wondering if this 
module might still work with the latest CDBI? Is anyone currently using 
it? I don't mind hacking it a bit if I have to, but if it is a lost 
cause, I would rather not waste the time.

Does anyone have some experience with such a setup? If so, how are you 
handling the read vs write connections?

TIA,
Vince V.