How to split database and data between two servers

Just thought I’d put this out there as I couldn’t find any info on the intertubes. There is plenty of info on how to do it on Drupal but not WordPress. Maybe I’m just stupid, but I though someone might need the info also.

Problem: We had to split our data and database between two servers and I couldn’t figure out how to get the database to connect to the new server. Where did I punch in the IP numbers.

Solution: Open WP-config and change DB_HOST from localhost to the IP address of the server where the databases are. So now you know ??

// ** MySQL settings - You can get this info from your web host ** //

/** MySQL hostname */
define('DB_HOST', 'The IP address of the server where
the database is located. 192.xxx.xxx.xxx');