I'm looking for a way to separate my users and usermeta table to be in a different database than my main WP install. The end goal is sharing these table over a number of WP installs.
From what I read, HyperDB should allow for this, however their documentation is a little sparse when it comes to creating and linking datasets --- which is where I believe I should be looking.
I've tried something along the lines of this without success:
$wpdb->add_database(array( 'host' => DB_HOST, 'user' => DB_USER, 'password' => DB_PASSWORD, 'name' => 'my_user_db_name', 'write' => 0, 'read' => 1, 'dataset' => 'user', 'timeout' => 0.2, )); $wpdb->add_table( $user, $wpdb->base_prefix . 'users' ); $wpdb->add_table( $user, $wpdb->base_prefix . 'usermeta' );
But this wasn't successful. Any help would be appreciated. Thanks in advance. ~Cam