Uploaded byMariaDB plc
Getting started in the cloud for developers
The document outlines MariaDB's cloud options for developers, emphasizing the importance of defining requirements such as application interfaces, scalability, security, and support across various environments. It compares AWS RDS MariaDB with options like AWS Aurora, highlighting significant cost differences and limitations related to configuration and performance. Additionally, it discusses other cloud providers and managed services offered by MariaDB, including performance auditing and optimization services.
Getting started in the cloud for developers
- 1. MARIADB Cloud Choices for Developers ThomasBoyd Director, Technical Marketing MariaDB Corporation
- 2. Agenda ● Define yourRequirements ● AWS MariaDB Options ● Other Public Cloud Providers ○ Microsoft Azure ○ Google Cloud ○ Alibaba ○ Rackspace ● MariaDB Managed Services Offerings ● Containers, Kubernetes and the future of Cloud
- 3.
- 4. What’s Important ● ApplicationInterface(s) ○ SQL Support ○ Integrations ● Scale and Performance ● High Availability ● Security ● Support For for Dev Environments? For for Prod Environments? For for Test/QA Environments?
- 5. Which Edition meetsRequirements? MariaDB Server MariaDB Enterprise Server MariaDB Platform Proprietary Pretenders
- 6. What Configuration(s)? ● Master/Slave ●Multi-Master Clustering ● Storage Engines ● Encryption settings ● Multi-zone
- 7. You have alot of power at your fingertips! vs
- 8. Shared and SandboxEnvironments
- 9. AWS Aurora &RDS
- 10. Bait and Switch:Aurora != MariaDB
- 11. RDS MariaDB meanspaying MORE Instance Type EC2 Price RDS Price Increase m5.large $0.096 $0.171 78% m5.xlarge $0.192 $0.342 78% m5.2xlarge $0.384 $0.684 78% m5.4xlarge $0.768 $1.368 78% m5.12xlarge $2.304 $4.104 78% m5.24xlarge $4.608 $8.208 78% Provisioned IOPS $0.065 $0.100 54%
- 12. RDS MariaDB meansgetting LESS ● No access to machine/vm tuning ● Limited access to changing DB configuration parameters ● No access to more advanced instance types ● Delayed access to recent releases ● Performance degradation at higher levels of concurrency ● No multi-master MariaDB Cluster ● No advanced proxy, db firewall ● No access to expert DB support
- 13. Why do Peoplechoose RDS (and Aurora) ● Easy of Setup and Operations ○ Wizard driven creation ○ Wizard driven backup and restore ● Perceived headcount savings
- 14. Use AWS forIaaS ● Excellent selection and pricing of instances ● Most mature networking and storage options ● Easy to provision
- 15. How to getRunning on EC2 ● AMI Marketplace is a mess! ● Provision EC2 machine(s) required for cluster ○ Provisioned IOPS? ○ Local storage? ● Pull MariaDB from Official Repositories ● Follow MariaDB Knowledge Base install and setup instructions Cloudformation and/or saved AMIs for repeatability
- 16. Secure your Instance ●Use Amazon Security Groups for 3306 AND 22 ● Configure and use SSL ● Password protect all account ● RBAC Cloudformation and/or saved AMIs for repeatability
- 17.
- 18. Other Public CloudProviders ● Microsoft Azure ● Google Cloud ● Alibaba ● Rackspace
- 19.
- 20. MariaDB Platform ManagedService “White glove” Service providing full MariaDB Platform ● Performance audits ● Performance tuning ● Query optimization ● Schema changes ● Database upgrades ● Database migration ● Reference architecture design ● Database installation ● Database configuration ● Backup configuration ● Database recovery ● Security audits
- 21. MariaDB SkySQL andCloudTrail ● MariaDB Server ● Self-Service ● Kubernetes-based ● Moving to Beta in summer
- 22.
- 23.