Master & Slave database setup with Strapi

Questions and Answers Strapi Backend
2

I would suggest MariaDB Galera clusters over MySQL clustering, and if you really want to take it to the next level using ProxySQL to split read/writes.

This is a bit of an old network/software layout I did for my previous deployment of a hobby project, but is still quite a powerful layout for both load balancing and fault tolerance (minus my firewall being a single point of failure, but it was a bare metal deployment)

image
image601×746 68.9 KB

The driving factor in why I ran this layout was:

  • I had a physical firewall (PFSense)
  • I had 3 “Virtual Machine hosts” running XCP-NG (Xenserver FOSS Fork)
  • Each of the Strapi, Nginx, and ProxySQL (minus 1) where distributed on the 3 hosts
  • I had 2 Hosts dedicated to the database and 1 virtual machine
  • Each of the dedicated DB hosts held one Write and one Read DB VM (these hosts had a lot of SSD based storage for speed)
  • The Arbitrator node was in a virtual machine on the primary VM pool as it only handled Backups/Scripts/arbitration and would never see application traffic unless the other 4 died (in which case I much bigger problems)
  • ProxySQL handles the bulk read/write split and connection pools with an active/failure config for maintenance downtime.

Over the course of 3 years I had a grand total of about 30 minutes of downtime (hard down). And at peak traffic I was handling between 3 to 4 million requests per month or about 1.6 requests per second (It was much higher during active load times as I typically saw a decrease in traffic for about an 8 hour period).

Each of the Strapi virtual machines ran a PM2 cluster of 4 nodes for a grand total of 12 Strapi backend “instances” (admin panel was served as a static resource from Nginx).

All of this is for a hobby project as a 3rd party API for a video game called Elite Dangerous :stuck_out_tongue:

To answer the bulk of your question, Strapi supports whatever Knex and Tarn support (minus certain other databases like MSSQL/Oracle SQL). While I have not tested MySQL clustering because I find the single master system a bit dated, if Knex supports it then Strapi will. If all else fails:

1 Like