database sharding & cache

Tagged: Database Cache

Viewing 6 posts - 1 through 6 (of 6 total)

Author

Posts
March 2, 2021 at 11:04 am #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?

March 2, 2021 at 11:06 am #34468

Marko Vasiljevic
Keymaster

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!

March 3, 2021 at 11:13 am #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?

March 3, 2021 at 11:14 am #34512

Marko Vasiljevic
Keymaster

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!

March 4, 2021 at 9:22 am #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?

March 4, 2021 at 9:27 am #34559

Marko Vasiljevic
Keymaster

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!
Author

Posts