I do not know if it’s because I do not speak English, but do not really understand anything he says here, is a video explaining it would be too much to ask? thanks
wget http://svn.wp-plugins.org/hyperdb/trunk/db-config.php
wget http://svn.wp-plugins.org/hyperdb/trunk/db.php
vi /var/www/wordpress/wp-config.php:
find
/** MySQL hostname */
define('DB_HOST', '<Your Database Host Name>');
add beneath it, using the read replica endpoint:
define('DB_HOST_READ_REPLICA', '<Your Database Read Replica Host Name>');
vi /var/www/db-config.php:
find
$wpdb->add_database(array(
'host' => DB_HOST, // If port is other than 3306, use host:port.
'user' => DB_USER,
'password' => DB_PASSWORD,
'name' => DB_NAME,
'write' => 0,
'read' => 1,
'dataset' => 'global',
'timeout' => 0.2,
));
and change it to include
'host' => DB_HOST_READ_REPLICA, // If port is other than 3306, use host:port.
mv db-config.php /var/www/wordpress/
mv db.php /var/www/wordpress/wp-content/
np
Make sure to secure db.php before installing plugins:
chmod a-w /var/www/wordpress/wp-content/db.php