imperium2335 Posted April 10, 2011 Share Posted April 10, 2011 Hi, I have the general gist on how to connect to another database on another server but I would like to know what can be done to minimize latency. i.e. is there a way to prioritise requests from one IP (website) above all else, or what about a dedicated VPN connection etc? Quote Link to comment https://forums.phpfreaks.com/topic/233256-connecting-to-a-database-on-another-website/ Share on other sites More sharing options...
vicodin Posted April 10, 2011 Share Posted April 10, 2011 I would defintly create a VPN just for security reasons and then setup the database to replicate to each other so you can have all the info local instead of sending them to the other database. Quote Link to comment https://forums.phpfreaks.com/topic/233256-connecting-to-a-database-on-another-website/#findComment-1199673 Share on other sites More sharing options...
imperium2335 Posted April 10, 2011 Author Share Posted April 10, 2011 How would you set it to replicate? We are about to launch about 15 websites around the world and we want them to draw from and update one central database which is located in our main office. With a secure connection, would that just be adding a port number provided by the hosting company to the end of the ip? e.g. mysql_connect('123.123.123.123:1313' etc? To do this sort of thing would it guarantee success if we hosted our sites on dedicated servers? kind regards. Quote Link to comment https://forums.phpfreaks.com/topic/233256-connecting-to-a-database-on-another-website/#findComment-1199686 Share on other sites More sharing options...
fenway Posted April 19, 2011 Share Posted April 19, 2011 Replication is built into mysql. Quote Link to comment https://forums.phpfreaks.com/topic/233256-connecting-to-a-database-on-another-website/#findComment-1203426 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.