Developing two (2) websites with Replicated MySQL database.

[dc_eros]

Hello guys at Bizhat.com

I'm Lysender, a PHP + MySQL intermediate developer.

I want my project website this way: There are two servers, one at the local campus and the other at some free hosting that supports PHP + MySQL. Each websites has its own database, and directory structure with files like user photos and avatars.

I want it this way: Where ever the visitor wishes to visit, his/her accounts and photos are available on both servers.

I'm not asking for source codes or whatever, I'm asking for a technique to make it work. Can anybody help me for that? Post the possible methodologies that can be applied.

Thank you in advance guys.

[vinil]

hi Lysender,

You can use mysql database replication for this.
Use the concept of master slave relication
configure one of the server as master and the other as slave.
Data in master will be replicated to the slave.

2. configure a proxy to redirect requests to 2 webservers.

lemme know if you need any further help

Regards
Vinil

[ftvfatboy]

Thanks vinil for helping people at time..cheers for ur work