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? 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. Link to comment https://forums.phpfreaks.com/topic/232813-daily-sync-mysql-database/#findComment-1199558 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.