I moved to Digital Ocean from AWS RDS primarily because, unlike Linode and Vultr they boasted managed database solution.
However, I have found the same as all of you; the performance is quite terrible.
If you want a direct comparison you can visit the following:
(8 GB RAM / 2 dedicated CPU / 25 GB Disk - MySQL version 8 - the same as managed)
Digital Ocean Managed Database:
(8 GB RAM / 2 dedicated CPU / 25 GB Disk)
Mariadb 15 on local machine
(4 GB Memory / 2 AMD vCPUs / 50 GB Disk)
As you can see (and test for yourself) the difference in performance is huge.
I uploaded a video showing the difference - DO support said they never got it.
I also gave them the two last sites - they couldn’t see any difference, but explained away any performance drop with considerations of latency etc. etc. etc.
If you go to the shorter threads then there is little difference, but the ones I have posted above are longer threads and so require more queries.
I gave them links to these and then they said it was down to a difference in database engines: Mariadb is quicker than Mysql 8 and suggested I test on a droplet running this.
Then they closed the support ticket as resolved! Clearly they don’t want to accept there is an issue even though it couldn’t be clearer to see.
Yes, after installing Mysql 8 on another droplet you can see it is quicker as they say, but by 0.7s vs 1.5s (mainly down to latency of local to separate droplet) and still nothing like the 28s for their managed service.
I feel that all I get from Digital Ocean is fobbed off with excuses for essentially a poor product.
Are they being deliberately disingenuous about the fact that there are some real performance issues going on here with their managed database service that effectively render it useless?