Different Database Setup for Write/Read

Random stuff about serendipity. Discussion, Questions, Paraphernalia.
Post Reply
tweyand
Posts: 1
Joined: Mon Nov 12, 2007 11:44 am
Location: Hamburg, Germany

Different Database Setup for Write/Read

Post 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
kleinerChemiker
Regular
Posts: 765
Joined: Tue Oct 17, 2006 2:36 pm
Location: Vienna/Austria
Contact:

Post 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.
garvinhicking
Core Developer
Posts: 30022
Joined: Tue Sep 16, 2003 9:45 pm
Location: Cologne, Germany
Contact:

Re: Different Database Setup for Write/Read

Post 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
# Garvin Hicking (s9y Developer)
# Did I help you? Consider making me happy: http://wishes.garv.in/
# or use my PayPal account "paypal {at} supergarv (dot) de"
# My "other" hobby: http://flickr.garv.in/
Post Reply