jonjonyjon Posted November 24, 2009 Share Posted November 24, 2009 I have looked everywhere to find an answer to this and maybe you guys/girls can help me out. I have a 2 websites running 2 mysql servers. ServerA and Server B. I would like for ServerA to update ServerB whenever something is posted onto it. Both website forums should have the exact same information and should update in realtime or close to realtime when someone posts something on either one of them. Is there a way I can tell the Mysql server to post something onto another mysql server everytime it updates and vis versa? Or...can i have just 1 mysql server to run both websites and update both of them with 2 different themes? Thanks! Quote Link to comment Share on other sites More sharing options...
JustLikeIcarus Posted November 25, 2009 Share Posted November 25, 2009 Well your best solution would be to setup replication. This requires you to enable binary logging for the database. A how-to guide is here http://dev.mysql.com/doc/refman/5.0/en/replication-howto.html Quote Link to comment Share on other sites More sharing options...
jonjonyjon Posted November 25, 2009 Author Share Posted November 25, 2009 Thanks I will give this a try and keep you guys updated. Quote Link to comment 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.