Viewing 6 posts - 1 through 6 (of 6 total)
  • Author
    Posts
  • #34426
    Mike
    Guest

    Hi,

    We have pro version of W3TC. Is there any way to make it work with multiple databases?

    Hyper Db allows sharding wordpress across multiple databases but it adds db.php to same place W3TC adds it so they can’t be used at same time.

    How can I have database caching enabled with multiple databases?

    #34468

    Hello Mike,
    Using more than one plugin for this is not recommended.
    If you are planning to use the mentioned plugin you should disable W3TC db caching as both plugins are using the same drop-in – db.php.

    Thanks!

    #34490
    Mike
    Guest

    Hi Marko,

    Thanks fo the reply.

    I saw mention that W3TC support multiple databases but I can’t see it in docs. Can you confirm W3TC only works with a single database?

    #34512

    Hello Mike,
    With W3TC PRO you may use a cluster of MySQL servers when a single MySQL instance can’t handle all your traffic.

    Choosing a Database Caching Method in W3 Total Cache

    Thanks!

    #34514
    Mike Saunders
    Guest

    Thanks. I have a pro license already but I am really finding it difficult to find any documentation of how to setup database cluster. We are using AWS MySQL Aurora and have multiple read/write replicas.

    The page you linked me to says it is possible if buying pro but it does not give any instructions. Do you have any documentation on mysql cluster setup?

    #34559

    Hello Mike,

    There is an example config wp-content/plugins/w3-total-cache/ini/dbcluster-config-sample.php

    Once edited create /wp-content/db-cluster-config.php and paste the config there. It should work after these steps.

    Thanks!

     

Viewing 6 posts - 1 through 6 (of 6 total)
  • The topic ‘database sharding & cache’ is closed to new replies.