Drupal Development - Staging - Production Server
patPrzybilla - June 4, 2008 - 19:54
| Project: | Database Replication |
| Version: | 5.x-0.1 |
| Component: | Miscellaneous |
| Category: | support request |
| Priority: | normal |
| Assigned: | Unassigned |
| Status: | active |
Jump to:
Description
Hey Guys,
has anybody tested this module as solution for development production server?
Would be great if someone could post his experiences.
#1
I'd like to do that if it is v6.x
#2
This module has only been used and tested on Drupal 5 (5.5 currently) - it is in-use in a live, global environment.
We have a master server in the UK, a SQL Proxy behind it to dump unwanted tables before replicating to slaves in France, Belgium, Romania and New Zealand.
It has a built-in heartbeat to check replication is functioning - in the event of a failure, a status flag is set and the site theme altered to indicate to slaves a "Read Only" status.
So far it has worked without incident.
Occasionally it has been necessary to re-construct the DB by taking a dump from the relay.
We use the module in conjunction with DBFM.