I have 24 working on 25 MU-Multi Site installs running and every thing was fine (Kudos 2 WP & WPMU) until...... I got to many users ? at about 2500 - 3000 the databases start being un-processable (to big ? for mySQL ?) at 7000+ users they even load, for example (a execute database repair from cpanel )will go clear off the CPanel page (is that a server issue ?) any way I tried every thing I can find Like casheing and compressing and I even upgraded my server account to a twice the size account (a much bigger one !) and I still can't load mySQL it times out or ?? or it says the database has 7000+ tables why is that to many ? (from this post " http://www.sitepoint.com/forums/showthread.php?p=4787558#post4787558 " it does NOT sound like this is my problem ) Where do they Host I think I need a better mySQL host. I am on a HostGator reseller Silver account now. Where or what Host do they use ? and how much is it a month-year ?. My sites are all on separate cpanel accounts in said reseller account.
In said post they refer to "We use MySQL Server with databases that contain 50 million records. We also know of users who use MySQL Server with 60,000 tables and about 5,000,000,000 rows."
I want a server with mySQL capability's like that ! Where do I go who do I contact !
Is there a way to keep this from happening ? Like splitting the database at every 2000th user added maybe ??