Tomasz Cholewa

Tomasz Cholewa

DevOps Growth Expert

cloudfact#5

less than 1 minute read

Source

  • AWS docs
  • Google Cloud Platform docs

    There is no official information on read replica limit - this was based on tests

  • Azure docs

Additional facts

  • On both AWS and GCP you can configure HA option - in case of AWS RDS it is fully transparent (you cannot see the instance itself) and synchronous while on GCP it is semisynchronous and the failover instance is visible and manageable
  • GCP additionally is able to replicate to and from externally hosted MySQL instances
  • At the time of publication of this fact, MySQL on Azure was still in preview and didn’t have read replication options

Conclusions

  • When your app uses MySQL and you need to scale reads then GCP has the best offer when it comes to flexibility
  • If you’re cautious and need to provide higher level of availability then multi-region offered by AWS RDS might be the best option
  • Apparently when you use Azure you use Microsoft SQL Server rather than MySQL - it’s not the best platform for apps using this db engine

Leave a comment

You may also enjoy

Co przyniesie rok 2022 dla DevOps

5 minute read

Co to był za rok! Chyba nigdy tyle nie obejrzałem seriali na Netflix siedząc w domu, ale też nigdy nie przeczytałem tak wielu książek. A ilu rzeczy się też n...

Kubernetes for mere mortals

8 minute read

There have been few technologies that have changed the landscape of business and impacted all our daily lives. Of course, the internet is the technology that...