Page 1 of 1

Different Database Setup for Write/Read

Posted: Mon Nov 12, 2007 12:04 pm
by tweyand
Hi,
i have a question, about an rather unusal Database Setup.

We have several Webservers which have an local Mysql for readaccess but writing to the Database should only be to an Dedicated Master SQL Server.

Has anyone ever tried such configuration with serendipity? Is it posible to write a plugin for such an modification - or is this kind of change to "fundamental"?

Thanks
Tim

Posted: Mon Nov 12, 2007 12:51 pm
by kleinerChemiker
i dont think, a plugin cann do this, because plugin configuration is stored in the db.

but s9y uses a small db abstraction. maybe you could rewrite it to fit your needs.

Re: Different Database Setup for Write/Read

Posted: Mon Nov 12, 2007 12:53 pm
by garvinhicking
Hi!

You should definitely check out http://jan.kneschke.de/2007/10/29/mysql-proxy-das-modul !

It's a fundamental thing that is too hard to do on scriptlevel.

Regards,
Garvin