I have a client that really (really, REALLY!) wants to use a standard database server through a specific hosting company. That company offers vanilla installs of PostgreSQl and MySQL only.
The client has several running instances of web application software. They want those applications to be able to share a certain portion of their data.
That data is kept in a small handful of tables on each instance's database.
I immediately thought of some type of data replication or synchronization. Master-Slave or Master-Master replication would work fine. MySQL federation would probably work too.
But the problem comes back again to the hosting company. We won't have superuser access on the OS or the DB server, nor will we be able to modify the DB server's configuration files.
Question: Without superuser access or access to the DB server's configuration files, is it possible to set up some type of data synchronization?
Everything I've read so far suggests that this is impossible. But, perhaps there's a method I've overlooked?
Note: If it helps, each app's database will be hosted on the same DB server.