Amazon Web Services offers a broad set of global cloud-based products including compute, storage, databases, analytics, networking, mobile, developer tools, management tools, IoT, security and enterprise applications.
Amazon Relational Database Service (Amazon RDS) facilitates the setting up, operating, and scaling of relational databases in the Cloud. It provides cost-efficient and resizable capacity while automating time-consuming administration tasks such as hardware provisioning, database setup, patching and backups. It frees you to focus on your applications, so you can give them the fast performance, high availability, security and compatibility they need.
Amazon RDS is available on several database instance types - optimized for memory, performance or I/O - and provides you with six familiar database engines to choose from, including Amazon Aurora, PostgreSQL, MySQL, MariaDB, Oracle, and Microsoft SQL Server. You can use the AWS Database Migration Service to easily migrate or replicate your existing databases to Amazon RDS.
Amazon Web Services (AWS) Aurora
Amazon Aurora is a relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It delivers up to five times the throughput of standard MySQL and up to three times the throughput of standard PostgreSQL. Amazon Aurora is designed to be compatible with MySQL and with PostgreSQL, so that existing applications and tools can run without requiring modification.
Amazon Aurora is designed to offer greater than 99.99% availability, increasing MySQL and PostgreSQL performance and availability by tightly integrating the database engine with an SSD-backed virtualized storage layer purpose-built for database workloads. Amazon Aurora's storage is fault-tolerant and self-healing, and disk failures are repaired in the background without loss of database availability. Amazon Aurora is designed to automatically detect database crashes and restart without the need for crash recovery or to rebuild the database cache. If the entire instance fails, Amazon Aurora will automatically fail over to one of up to 15 read replicas.
Google Cloud SQL
Cloud SQL is a fully-managed database service that makes it easy to set up, maintain, manage, and administer your relational PostgreSQL and MySQL databases in the Cloud. Cloud SQL offers perks like high performance, scalability, and convenience. Hosted on Google Cloud Platform, Cloud SQL provides a database infrastructure for applications running anywhere.
Letting Google manage your database allows you to focus on your applications. Cloud SQL is ideal for Wordpress sites, e-commerce applications, CRM tools, geospatial applications, and any other application that is compatible with MySQL or PostgreSQL.
Oracle Cloud MySQL Service
Oracle, the makers of MySQL, provide their own cloud service as well. Oracle Cloud provides leading-edge capabilities in software as a service, platform as a service, infrastructure as a service, and data as a service. Oracle MySQL Cloud Service is a simple, automated, integrated and enterprise-ready database service, built on Oracle MySQL Enterprise Edition and powered by Oracle Cloud.
Automate administrative tasks such as provisioning, patching and backup via MySQL Cloud Service web console, command line or simple REST API.
Automated Backup and Recovery:
Use MySQL Enterprise Backup to deliver hot, online, non-blocking backups with high performance.
Use MySQL Enterprise Monitor, Query Analyzer and MySQL Workbench to manage and monitor the performance and availability of all your MySQL instances.
Microsoft Azure Database for MySQL
Although Microsoft's cloud services are mainly aimed at Microsoft products, Azure Database for MySQL provides fully managed, enterprise-ready community MySQL database as a service. The MySQL Community edition helps you easily move to the Cloud, using languages and frameworks of your choice. On top of that, you get built-in high availability and dynamic scaling, helping you easily adjust to changes in customer demands. Azure Database for MySQL also boasts excellent security and compliance, including Azure IP advantage, as well as a global presence. The service comes with a flexible pricing model, so you can choose resources for your workload with no hidden cost.
Exitas MySQL Cloud
Exitas is an independent Belgian provider of ICT management services that supplies organizations with the technology, the people and the processes to build Information and communication technology (ICT) infrastructures.
Exitas' MySQL Cloud service allows you to scale CPU, memory and even storage both up or down via the MySQL Cloud Interface. MySQL Cloud Service is completely backed by the MySQL Engineering Team.
Being based on MySQL Enterprise Edition means that you are able to use all the security features it provides, including:
Guard against SQL injection and other cyber security threats.
Protect sensitive data at all stages: in database, in backup, during transfer and even at rest.
Keep a detailed audit trail of the MySQL access and usage.
Authenticate users using your existing directory services and security rules.
Backup and restore your MySQL Databases with the click of a button.
Alibaba Cloud ApsaraDB for RDS - FAIL!
Alibaba Cloud is China's largest public cloud service provider and the cloud computing arm and a business unit of Alibaba Group. Alibaba Cloud provides a comprehensive suite of global cloud computing services to help power and grow businesses.
Alibaba Cloud ApsaraDB for RDS (Relational Database Service) is the name of Alibaba's on-demand database service. ApsaraDB for RDS is a ready-to-use service that is offered on MySQL, SQL Server and PostgreSQL. RDS handles routine database tasks such as provisioning, patch up, backup, recovery, failure detection and repair.
I signed up for a few weeks using their offer of $300 free credit so that I could evaluate their service for a client. When my credit card bill came in, I was shocked to see a charge of around $20. I immediately contacted Alibaba's support, who were less-than helpful. I contacted support a few more times to resolve the issue, and was met with the same apathy each and every time. I eventually managed to delete my DB instances, but not before incurring another $20 charge. I can’t recommend them until they improve their customer service.
Each and every day, new cloud-based database providers are cropping up to meet the demands of Big Data. Companies both large and small love database as a service (DBaaS) because it frees them from having to dedicate their own infrastructure towards data storage, while providing the ability to scale their databases (DBs) into ever-increasing capacities - all with minimal hassle.
Both the types of services and DBs offered can vary quite a bit by DBaaS provider. Some offer relational, SQL databases, while others are focused on NoSQL databases. Others specialize in various open source databases. This slideshow will focus on those which cater - at least in part - to MySQL users.