Tagged: Database Cache
- March 2, 2021 at 11:04 am #34426MikeGuest
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?March 2, 2021 at 11:06 am #34468
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!March 3, 2021 at 11:13 am #34490MikeGuest
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?March 3, 2021 at 11:14 am #34512
With W3TC PRO you may use a cluster of MySQL servers when a single MySQL instance can’t handle all your traffic.
Thanks!March 4, 2021 at 9:22 am #34514Mike SaundersGuest
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?March 4, 2021 at 9:27 am #34559
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.
- The topic ‘database sharding & cache’ is closed to new replies.