Syncronyse differente databases

[madness69]

Hi guys, nice being a part of the forum, my question is, i have a network of differente websites, each of these websites work in the same services.

All there backend, databases are the same, having there same tables, etc. Only thing that changes in them is the CSS for differente design of course. What i need it to do is when one of the websites insert a new product the other sites receives the same product of this website. All these site have the same capability, when site A insert a new product site B and C receives the same product in there databases, when site C insert new product site A and B receives the same product and forward.

How can i achieve this accomplishment, maybe i should put this question in the mysql section but maybe here can help me.

 

Be well

[webbhelp]

I haven't done this before but I will try to help you anyway because I think you will be happy to get a answer anyway =)

 

I would try:

 

First I would connect to the first database and insert it...

Then I would use: mysql_close();

 

And then I would create a new connection

Then I would insert it there.

 

I think that is the only way, but I am not sure!

 

Try =)

[madness69]

Yes, im experimenting, no better way than try, i will try your advice, is the first time i try something like that and proud in doing it, it looks a good challenge, im reading about triggers, it looks interesting.

 

Thanks for the reply

[coupe-r]

Have you looked up Database Mirroring?  You need to set up a Replication Server.  Check this out.

 

http://www.astahost.com/info.php/Mirror-Mysql-Database-Mysql-Server_t5155.html

 

Not sure if this would help you