I have never done something like this. I currently am running a forum and service which rely on the same database on the same server but as they grow it has become apparent that 1 box is not enough. Plus this will be good experience for when I add on to it even more.
So I have a forum (vbulletin) and a wcf service which uses the user table to get user information when they log into the service.
What should I do for splitting them apart? I imagine having the service connect remotely would be slow. I have read about replication but I am not really sure how to set that up. Also does replication support only doing a single table? As I don't need it replicating the entire database.
I was thinking about getting a stable 3rd server for hosting the mysql database that way if the forum server goes down the service server will still work. But how would that work? Can replication go both ways? Like changes to the replicated database on the forum server will be sent to the database server.