We upgraded our MySQL-based law database system a couple weeks ago. We’re now running a cluster with a writer and reader so that the failure of one server doesn’t result in downtime for our users. This new cluster-based system is approximately 15x faster than the old one due to a much higher amount of RAM (necessary to accommodate our rapidly growing index of laws and translations). Although we’ve updated many other parts of the system, we had been running on the same HDD-based MySQL system since October of last year. Our new system is SSD-based and has far higher throughput.
Users will primarily see the difference in how much quicker the “Related Laws” feature is. We’ve measured the performance at about 15x the previous MySQL server system. Thanks to our cloud-based infrastructure and standardized components it was quite easy to make the transition. Within about two days we went from experimenting to a full transition (and no reported downtime from users).