Forums / Setup & design / Update on-line database - replication ?

Update on-line database - replication ?

Author Message

Alexandre Cunha

Monday 17 April 2006 6:03:13 am

Hi,

Im not sure if mysql replication is the solution for my problem. Need your advice.

This is my scenario:

site A - Online site on a shared hosting service. Using mysql 4.0.25 and ezpublish 3.7.4. This site is only updated my surfers with coments and forum messages.
site B - The developement and publishing machine with mysql 4.1.13 and ezpublish 3.7.4. This site is updated only by publishers.

I use rsync to update changes from B to A (design, settings and stored images).

Every week I need update any content changes and new articles (database related) from B to A. I want run a script to do this.

Is replication solution for this, or have a more simple solution ?
What are your sugestions ?
Thanks,

axel

http://AlexandreCunha.com

Gabriel Ambuehl

Monday 17 April 2006 6:59:50 am

I don't think MySQL replication can even be setup without root access to the database server, so that's probably not very feasible.

Visit http://triligon.org