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

"Please Note:

At the specific request of Ibexa we are changing this projects name to "Exponential" or "Exponential (CMS)" effective as of August, 11th 2025.
This project is not associated with the original eZ Publish software or its original developer, eZ Systems or Ibexa".

Update on-line database - replication ?

Previous topic

Setup & design

Next topic

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 Exponential 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 Exponential 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

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 Exponential 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 Exponential 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