1. Can mySQL be set up to replicate through a firewall?
2. What exactly does it mean when manual reads mySQL only supports 1 was replication. I am concerned about that.
server A lives inside firewall
server B lives outside firewall
web users connect to server B
server B collects their data send changes to server A.
Administrators/content authors work on Server A. If content changes on server A, will those changes be replicated over to server B.
Can the above scenario be implemented with mySQL or do I need to use postgres?
How do you get sql data replicated through a firewall?
2. What exactly does it mean when manual reads mySQL only supports 1 was replication. I am concerned about that.
server A lives inside firewall
server B lives outside firewall
web users connect to server B
server B collects their data send changes to server A.
Administrators/content authors work on Server A. If content changes on server A, will those changes be replicated over to server B.
Can the above scenario be implemented with mySQL or do I need to use postgres?
How do you get sql data replicated through a firewall?