Has anyone leveraged SymmetricDS in their development and production efforts so as to keep the environments synchronized?
We have a number of WordPress sites that need to be kept in synch. In our scenario we have a "master" wordpress project that is developed between a few developers and this master get's duplicated out on new deployments as well as pushed out to update old deployments. We have been considering using ManageWP or the Duplicator plugin, however it just is not optimal in really getting updates out in a tracked fashion that we'd like to see.
Our goal is to use Git + some kind of db synchronization (appears it will be SymmetricDS) in order to synchronize the code and databases while leaving the config files specific to the sites, similar to how Rails devs handle the deployment convention generally.
But with this, I was hoping to find someone who may be using SymmetricDS with some degree of success already in such a scenario who could share some light on how they have it set up so as to handle the custom database components that WordPress will have from site to site and dev site to prod site. It seems to be possible given the customization factor of SymmetricDS, but not yet clear.