Hi there,
I am in the midst of creating a forums hosting site.

1. It has to be highly scalable, so I doubt a single MYSQL db with TONS of "subforums that simulate full forums" would do.

2. Also regarding scalablity, I hope to "Add capacity" as and when its needed. So i'll have one server running initially, and when it gets too crowded, i'll get two servers etc.

3. I will be providing a user with a "dashboard" that allows him to view all his subscribed posts across ALL forums. So lets say a user is a member of 25 forums, this dashboard view will allow the user to view all his posts across all the forums.

Does anyone have advice that could point me in the right direction?
I have solved the scalability issue WITHIN a forum (code can handle million + posts easy), but I havent solved the issue of scaling MULTIPLE separate forums.

What about having a single write master with many read-only slaves? Then modify your code so that posts go to the master and everything else happens on the slaves?

Also, does there exist any php package that helps ease the process of "deciding which Server/database to connect to"? For example, someone accesses FORUM A, so the script would automatically know to direct all queries to the DB in SERVER 1 etc, and if i try to access FORUM J, it would connect to SERVER 2 etc. I could easily hard code this, but I was thinking "what if internal IP addresses change, or I decide to migrate a busy forum to a server of its own etc", so perhaps there is a better available packaged solution designed for this task.

Create a table on a "central" server that contains this mapping. This server could also hold the login tables as well...

Just a thought.

--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to