WordPress.org

Ready to get started?Download WordPress

Forums

W3 Total Cache
db Master-Slave multi host config: W3TC native or HyperDB? (2 posts)

  1. Sergei
    Member
    Posted 6 months ago #

    Hi,

    Our WP setup is a backend server that runs MySQL Master database, and some frontend servers each running a MySQL Slave. HyperDB is used to route frequent reads to a local db, and rare writes to the backend.

    We recently switched from WPSC to W3TC. I was researching an issue with stale page cache, and browsed through plugin files, where I noticed a "dbcluster-config-sample.php" inside "ini" folder of the source. This file contains config sample very similar to that of HyperDB we're currently using.

    To resolve a conflict of HyperDB's "db.php" with that of W3TC I had to modify the plugin code (two lines defining W3TC_INSTALL_FILE_DB and W3TC_ADDIN_FILE_DB in "/inc/define.php", and renaming "wp-content/db.php" to "db-cache.php".

    Question: is W3TC capable of configuring the db to read from one database and write to another? How?

    http://wordpress.org/plugins/w3-total-cache/

  2. wpReg
    Member
    Posted 4 months ago #

    Hi Sergei - I have the same question, can W3TC replace hyperdb for setting up a master/slave MySQL connection? I tried a few tests to see, but I am not sure how to get wp to recognize dbcluster-config-sample.php.

Reply

You must log in to post.

About this Plugin

About this Topic