Hi,
I have 10 years of experience in IT industry. I have hands on experience in AWS technologies, currently working as Cloud Architect for one of the telecom giant.
Currently I am working on automation, designing and implementation of AWS infrastructure using Cloudformation, AutoScaling, VPC, S3, ELB, Cloudfront, RDS, SES, SNS and other AWS services.
Plus I have good hands on Configuration Management tools like Puppet / Chef which helps in automation of application stack.
I can help you with the Mysql DB set up. It is pretty easy and straightforward on AWS.
1. We can use auto scaling service for auto healing and scaling in/out web or application layer.
2. We can use RDS service for mysql database, it takes care of replication, backup, auto scaling and auto healing.
3. For security we can used VPC, Security Groups ACL's, and ELB's.
We can auto scale our Mysql DB on EC2 instances, but AWS RDS is the best solution to manage Databases.
You can connect me over skype, skype id: abhishek_vasisht
Thanks,
Abhishek