New answers tagged amazon-rds
Have you considered doing weighted round robin? You can configure them with Route 53 and use CNAMEs. http://docs.aws.amazon.com/Route53/latest/DeveloperGuide/routing-policy.html#routing-policy-weighted
If you can create a script (on the Puppet master) that will print the name (likely through calls to the AWS CLI), you can use the generate function to use the name in your Puppet manifests and templates. You can add this call right in your site.pp file. $rds_internal_name = generate('/usr/local/sbin/get-rds-internal-name')
There is product that with the right customization does exactly what I was required: http://www.getchef.com/solutions/aws/ Also, developing an internal system DB would work and is not a big issue.
There are many ways to skin a cat, but basically you do need to replicate your site in multiple geographic locations one way or another. Here's several options which might be suitable assuming your application is read heavy (which most websites are). I'm not familiar with Expression Engine so I'm not sure how difficult these architectures would be to ...
It ends up that it was indeed a lack of storage space on the instance that hosts RDS. The error code 28 that MySQL threw was accurate. The SQL processes just kept backing up as there was no storage left. We also had a query that one site was executing that was quite inefficient - it took over one minute to execute. This query may have been propagating the ...
Top 50 recent answers are included