How to connect to a remote database in WordPress?

Question

I have a WordPress website. I want to split my existing database into two parts and store in a remote database.

How can I set up a remote database connection for existing WordPress?

If it's not possible to split existing database, how can I connect a remote database for future records?

Thank you.

Answer 1

You can set up another connection and use that database the same way you would interact with the WP database with $wpdb.

This example creates an instance in $odb to be used the same as you would use $wpdb:

global $odb;
$db_user = "Your DB Username";
$db_pass = "Your DB Password";
$db_name = "Your DB Name";
$db_host = "Your DB Hostname";
$odb = connect_to_intermediary_db( $db_user, $db_pass, $db_name, $db_host );

function connect_to_intermediary_db( $db_user, $db_pass, $db_name, $db_host ) {
    $db = new wpdb( $db_user, $db_pass, $db_name, $db_host );
    return $db;
}

/*
 * You can now use $odb the same as you would
 * $wpdb, but it is connected to your custom
 * database.
 */