I have setup a Manage MySQL Database primary note and a read-only node and want to use them for my WordPress site.

Does the “read-only node” works automatically as in auto split the read transactions?

If not, how do I setup it so that my WordPress site will make use of the read-only node?

Thank you.

These answers are provided by our Community. If you find them useful, show some love by clicking the heart. If you run into issues leave a comment, or add your own answer to help others.

×
3 answers

Does the “read-only node” works automatically as in auto split the read transactions?

No, usually applications have to route the queries themself. Some ORMs makes this easier. In Node.js, I use Sequelize and see their docs: https://sequelize.org/master/manual/read-replication.html

How do I setup it so that my WordPress site will make use of the read-only node?

As far as I know, WordPress doesn’t have this functionality inbuilt. So you’ll have to route queries manually. See https://wordpress.stackexchange.com/questions/243438/configure-wordpress-to-read-from-database-only-never-write

There also some plugins that do this, like “HyperDB” (I haven’t tried it).

Also worth reading: https://jeffreyeverhart.com/2019/04/10/scaling-wordpress-databases-remote-servers-sharding-replication-ludicrous-db-aws/

Answering my own question.

WordPress site can setup mysql replication (read-only) using HyperDB plugin.

Refer: https://www.interserver.net/tips/kb/high-availability-wordpress-hyperdb/

Submit an Answer