Dear wpmudev team,
We run a Wordpress multisite with over 1200 websites. Unfortunately, due to the high number of websites, our database is probably overloaded and the load time increases, the more sites on the multisite run. As a superadmin, we often get 500 errors in the backend.
Can you give us some tips on how we can optimize the database structure?
Should we distribute the sites to multiple databases?
Or maybe we should even use several Wordpress multisite installations?
We grow very fast. By 2030, we expect to have 60,000 websites. Therefore, we should now already set up a structure that will be sufficient in the long term for these goals.
At the moment we are already using a test, staging and live system on a fast server (12 CPU cores, 256 GB RAM, 400 GB SSD storage (2 x 400 GB in RAID1), 100,000 IOPS). But here too we have the problem that backups and reflections of the systems take many hours.
It would be great if you could give us some tips database and server structure. Also like articles or forum posts, etc.
Founder of Spreadmind