Hello,
We are using Pro version of the W3 Total Cache plugin and just found this post which states that is possible to use different endpoints for a database cluster.
I have copied dbcluster-config-sample.php file into /wp-content/db-cluster-config.php and removed the comment for the following lines (line 154):
$w3tc_dbcluster_config = array(
‘databases’ => array(
‘master’ => array(
‘host’ => DB_HOST,
‘user’ => DB_USER,
‘password’ => DB_PASSWORD,
‘name’ => DB_NAME
),
‘slave’ => array(
‘host’ => READER_HOST,
‘user’ => DB_USER,
‘password’ => DB_PASSWORD,
‘name’ => DB_NAME,
‘write’ => false,
‘read’ => true,
‘timeout’ => 0.2,
)
I have also declared ‘READER_HOST’ in my wp-config.php config file as follows:
define(‘READER_HOST’, ‘mysql-cluster.eu-west-1.rds.amazonaws.com’ );
Now I’m trying to find the button you mentioned in your post but I’m not able to find the ‘Enable database cluster’ button on the General Settings -> Database Cache page. What am I missing?
We are using the latest 2.3.2 version of the plugin for a WordPress single site, not multisite/network.
Thank you in advance 🙂