0

I currently have a MySQL database hosted on a remote server (Server A). This database have to stay there because this remote server is very secure. Our online website use this database to display information. The website can also insert news fields.

Our local server (Server B) is connected by VPN to server A. And no more connections are allowed by VPN. Server B host also our intranet (this intranet use the database).

On the same network of Server B, we have +- 5 computers that need to query the database. But they can not have a VPN access.

I see 2 options to allow the local computers to query the remote DB.

MySQL Proxy

Installed on Server B. We will redirect the queries to Server A. As server B is connected by VPN it will no create problems.

Master to master replication

The mySQL database hosted on server A will be replicated on server B. Both databases will be used. If the website fill the DB on server A, the changes will be on the DB hosted on B. And vice versa.

What is the best solution? The master to master replication may cause inconsistencies? One solution is more efficient?

Atnaize
  • 148
  • 1
  • 1
  • 8

1 Answers1

0

If you only care about access and no redundancy and/or performance benefits of replication, go with proxy. It's simpler setup - easier to manage.

Fox
  • 3,977
  • 18
  • 23
  • Redundacy is very important but we do not care about the benefits of replication but the access from 2 differents locations. Is the proxy the best solution knowing that redundacy is a very (the most?) important factor? – Atnaize Sep 11 '15 at 08:42
  • If you need the redundancy part out of this solution, then the proxy is no option at all. It provides none ... – Fox Sep 11 '15 at 08:53
  • But if I use the proxy I will have only one database. So do not need of redundacy? No? I do not know if my question was clear – Atnaize Sep 11 '15 at 11:20