Figured I'd try asking this in here.

Here is what I want to accomplish:

Originally Posted by neo_

So I currently have a pretty prosperous forum. And I am wanting to make to make a sister site for it, it is going to be on a different host with a different domain. However this is how I want it to be setup. When one user registers for one site, he will be able to login to the other with the same username. When a user gets banned from one site, he gets banned from the other likewise How would I be able to set this up? Thanks

In response, I was instructed to "Setup two-way replication for all tables which store the information about users"


Well, my MySQL knowledge isn't that advance yet. How do I go about setting something like this up? And is this the most efficient way to do accomplish my goal?

Originally Posted by neo_

Well, my MySQL knowledge isn't that advance yet.

MySQL itself isn't very advanced yet. Use PHP to write to both databases at the same time where it would normally write to just one.

MySQL is more advanced than some think

http://www.onlamp.com/pub/a/onlamp/2...plication.html