Automatically Synchronizing MySQL database between two servers. Possible?

I just got another server and one site will use a database which will be updated on another server (for another site). It's updated several times a day so manual updating is not efficent.

Is it possible for me to set it up so via cron a connection is made and database x is synchronized to void any server lag time when users visit the site? It takes a few seconds right now for every search and I rather speed it up. Not to mention that if the server where the db is stored goes down, this site is effectively down too.

has anyone tried and doen this? if yes, please advise.

thanks

 

 

 

 

Top