PyraX Posted April 5, 2011 Share Posted April 5, 2011 Hey Guys, Ok so here is my issue. Server 1 has the mysql database and is constantly collecting data currently 148.9 MiB (win2008 server with Appserv installed) Server 2 has all my php files and domain eg. http://www.example.com (Linux/cpanel) Server 2 connects to server 1 for data on every page which causes a massive delay in page load time Resolving domain to server 1 is not an option What I want to do is great a new mysql database on Server 2 that syncs daily from Server 1 automatically How do I do this? Quote Link to comment https://forums.phpfreaks.com/topic/232813-daily-sync-mysql-database/ Share on other sites More sharing options...
vicodin Posted April 10, 2011 Share Posted April 10, 2011 Google MySQL Clustering. Quote Link to comment https://forums.phpfreaks.com/topic/232813-daily-sync-mysql-database/#findComment-1199558 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.