HyperDB lets you split whole tables across different databases but it won’t split a single table. You wouldn’t want that anyway because that means wordpress would have to query multiple databases to find a single post. However, depending on how your site is set up, you might be able to work around that by creating … Read more
In the name of bad practices, I’m going to advise that you immediately rule out these using raw SQL queries with remote databases in the same page. It would be slow, insecure, and a hassle to maintain. That you’ve landed yourself in a predicament where a combination of hyperDB+multisite is not an option demonstrates that … Read more
I believe Crazycoolcam spelled the table incorrectly, user_meta vs usermeta. You may also want to define the else case, what happens if the table is not user. Try this: <?php $wpdb->add_database(array( //Connect to Users Database ‘host’ => DB_HOST, // I am using the same host for my two DBs ‘user’ => DB_USER, // I am … Read more
Have a look into how WordPress.com do it – they released all the software they use under open licensing, and it’ll let you scale up in future as you need it – far as I know, DB replication is pretty easy to build in. If in doubt, email Matt (ma.tt) – the WP team are … Read more
You didn’t mention a HyperDB revision so I’m assuming trunk @337290. HyperDB’s SRTM feature (send reads to master) works two ways. First, it keeps track of which tables have received writes during the current script and sends all subsequent reads for those tables to the master. Second, it gives you a way to force all … Read more