Im going to be starting up a multisite that Im planning ahead and preparing for high traffic as well as high userloads.... I am a member over at wpmu so I have access to multidb but I was curious... would hyperdb be better?
My understanding is multidb, splits the various info up between diffrent databases but a table is still a table and cant be split
HyperDB splits up tables I believe over diffrent servers? Correct me if Im wrong... but which would be more efficient and offer the most gain?
Also if Hyperdb how easily can it be installed after the site is up and running, I mean if I plan to add SQL dbs later but after the userload warrents it. in multidbs case its not an issue as it hosts them all on 1 server but if multidb requires multiple servers then Id rather keep costs down till I need more.
Sorry if I didnt understand the fundamentals of whats goin on but all this does get a bit confusing on the pros and cons of everything and such... and Id like to hear from somoene who knows the real benefits behind these various options.