In the overall goal to make my forum more redundant, we are looking at options of load balancing web servers and database servers. Has anyone here set up MYSQL in an active-active role or is my only option a MYSQL cluster? If people had done either one of these options, please post here your findings on advantages & disadvantages, and how you accomplished this. I am looking for as much information as possible so a workable solution can be drawn up and we know how much/more hardware we need. My database administrator notes that the VBcode does post sorting by unique index and thusly incompatible with an active-active role. Clustering stores the database in memory and our current working set has tables in excess of 3 gigs and growing! Are we missing something here?
MySQL Consulting - MySQL Database and MySQL Cluster consulting Services::
Tutorial/HowTo on setting up, configuring and administering MySQL Cluster Server design, implement & deploy. Critical, High availability server design
http://www.lod.com/mysql-consulting.htmlHOME |
Thanks! :D
I don't think anyone besides ALanJay http://www.vbulletin.com/forum/member.php?u=9337 has had any experience with mysql clustering via Continuent cluster technology http://www.continuent.com/index.php?option=com_content&task=view&id=211&Itemid=168 not a cheap option at all in 5 figure price range IIRC.
Scaling MySQL is hard. Most large vBulletin owners have found it is much easier to optimize/tweak/hack the vBulletin code and just use one powerful database server, rather than use multiple.
 Nortel Unveils Vision, Strategy for Israeli High-Performance Net
 Busy Friday Leads to Strong Close for Net Stocks
|
PRINT
Add to favorites