Not too bad, but to really be getting your money’s worth (automatic failover) you need to spend more money. Cost & Why Managed MySQL is Importantįor our test we used the most basic configuration that DigitalOcean offers:Īll of this and not having to manage MySQL for $15/month. 99% of requests finish in less than 2.6 secondsĪs expected performance is slightly worse here due to fewer resources on the dedicated MySQL machine, but not in a huge way. Now let’s look at the response time distribution. Once we hit that level, the database charts were showing 100% CPU saturation and thats when we started to see the error rate increase. Things go sideways at ~50 req/s.Īll things considered, 50 req/s against a WordPress site with no caching isn’t all that bad. These expectations were confirmed with the load test.
Knowing that fewer resources were allocated, it was expected that performance would actually be a bit worse on the dedicated MySQL instance. For this blog post we went with the minimum possible configuration (1GB RAM, 1vCPU). When setting up a managed MySQL database on DigitalOcean you get the option to select the underlying hardware that powers it. Given how many failing requests we had and zero caching, the ones that did manage to get through didn’t perform too poorly. Things fall apart at around ~70 req/secįor completeness, let’s also take a look at the response time distribution. Without caching the results are predictably bad, but that is to be expected. The server configuration is as follows:Ī test of 400 concurrent users was run using Kernl’s WordPress Load Testing service. To get things started let’s do a baseline performance test where the MySQL database is on the same box as the Nginx server. In addition to that your database is isolated to your private network so that outside requests can’t access it by default. Security – MySQL best practices for security are automatically followed by DigitalOcean.Automated Failover – If for some reason your primary database node fails, you will automatically fail over to your warm spare.Automated Daily Backups – No need to set up your own backups.Horizontal Scalability – Site growing fast? You can spin up read-only nodes to help scale out read operations.Simple Setup – With a few simple clicks you can have a high quality MySQL cluster set up.There are a lot of reasons to use Digital Ocean’s Managed MySQL (or some other offering) including: There are ton of different options out there, but for this post we’re going to look at Digital Ocean’s Managed MySQL. One way to de-risk this portion of your WordPress site is by going with a managed MySQL offering. If you aren’t adept at managing MySQL, it can be a serious risk for you and your clients. The database is the most important part of any WordPress site. Want to performance test your own WordPress installation? Try Kernl’s WordPress Load Testing service.
0 kommentar(er)
