After an additional 6 months of working with the system and some serious sitting and staring through my monitor, I've determined what would help me tremendously in keeping DBs in sync.
Here is the high-level primary use case:
Step 1
Take a snapshot of the master database
Update a component(s) in the master
Take post snapshot of the master DB
Step 2
Compare snapshots
Flag changed tables and show differences
Deselect changed tables that you do not want to update in slaves
Pre-Generate sql that would sync the tables
Edit the sql to adjust changes that would be applied to the slaves
Provide keywords that can populate data from JMS configs & templates, Joomla config, etc
Step 3
Select an individual, series, or all slaves under a template
For each slave generate the sql to apply to the slave DB using the DB name and table prefix stored in JMS
Substitute keywords with data in configs etc
Select to review the sql before applying to each slave or to just run them all
Return status of executions
It would be the user's responsibility to backup the database before performing the update.
Thoughts??
As the utility matures could add the following capabilities:
Emulate the update and show results
Option to backup slave DB
Do a snapshot of slave before and after for full analysis (testing only)
Undo or restore capability
Forum
