CODEWITHSUNDEEP
phpmysqlsynchronization
jxmallett
jxmallett

Reputation: 4165

Synchronised local copy of MySQL / PHP website

I have a web based CRM coded in PHP, running off a MySQL database. The server is hosted in the same city as the company HQ but the company's internet connection is average (10Mbps down, 2Mbps up, 30ms ping to the server, all on a good day). The boss is happy with the results but now wants it to 'run super fast in the office' but we still need it to be viewable on the internet.

Short of moving the web server from our host and on to the local office network, which isn't a great option because then it would be super slow for everyone outside of the office, does anyone know a way to achieve this? I was thinking of setting up a local copy of the site and having the MySQL databases synchronise, but this sounds like a logistical nightmare.

Any ideas would be much appreciated! Happy to provide more info if needed.

Upvotes: 0

Views: 132

Answers (2)

Zak
Zak

Reputation: 25205

I am not joking around here.

Step 1) Have your boss define in written format what super fast means. This could(should?) include page load times for specific pages.

Step 2) Determine where there is a deficiency in speed. You think you know, but you don't. Measure it and record results. Use firebug in firefox to check page load and transfer times.

Step 3) Identify how you can speed up the app based on SPECIFIC measurements you looked at.

Upvotes: 1

Eric J.
Eric J.

Reputation: 150108

You can setup dual-master replication with MySQL to accomplish this.

I would not attempt it without a fast, reliable line (which it sees you have). I would certainly setup and load test temporary servers to prove the configuration works.

For more information

http://devel.reinikainen.net/40

http://www.neocodesoftware.com/replication/

Upvotes: 1

Related Questions