#amazon-rds

[sevennet-blog]

Answer: Amazon RDS: What are IO Requests? #answer #dev #it

Answer: Amazon RDS: What are IO Requests? #answer #dev #it

Amazon RDS: What are IO Requests?

I have an RDS instance that is costing me a lot of money. From my account activity on amazon I see that the instance has had about 800,000,000 IO requests over the past 7 days.

To give you a little perspective, my app only gets about 6,000 unique visits a day and it doesn’t make that many database connections.

So, what exactly is an IO Request, and why would…

View On WordPress

[sevennet-blog]

Fixed: Does Amazon RDS support multiple databases per instance? #computers #programming #it

Fixed: Does Amazon RDS support multiple databases per instance? #computers #programming #it

Does Amazon RDS support multiple databases per instance?

Title says it all… does it support multiple databases, or do I have to create a new instance for each database?

Answer [by cpgascho]: Does Amazon RDS support multiple databases per instance?

Yes, you can create multiple databases per instance, see their respective FAQ: What is a database instance (DB Instance)?

You can think of a DB…

View On WordPress

[sevennet-blog]

How to: RDS Replication across regions #development #computers #dev

How to: RDS Replication across regions #development #computers #dev

RDS Replication across regions

We are using Amazon AWS for our web services but given the recent instabilities in their infrastructure, we are trying to figure out how to run our application across multiple regions for additional redundancy.

Ideally, we would run our entire app in a active-active configuration in multiple regions but our main concern is that we are using RDS, which I understand…

View On WordPress

[sevennet-blog]

How to: How do you recover you RDS master user username? #answer #fix #development

How to: How do you recover you RDS master user username? #answer #fix #development

How do you recover you RDS master user username?

Resetting the RDS master user’s password is simple enough, but how do you find your master users username?

Answer [by Jan Fabry]: How do you recover you RDS master user username?

The master user name can be recovered with the rds-describe-db-instances command.

Original post

View On WordPress

[sevennet-blog]

Fix: Ways to auto scale MySQL servers? #solution #computers #dev

Fix: Ways to auto scale MySQL servers? #solution #computers #dev

Ways to auto scale MySQL servers?

I run a site which has high traffic surges and because of that auto scaling solutions is very profitable for this case. Currently the web server is able to horizontally auto scale but the bottleneck is on the MySQL server.

I have tried with Amazon RDS Multi-AZ but it takes like 15 minutes for the 12 GB database to upgrade with some minutes of downtime. It has…

View On WordPress

[sevennet-blog]

Fixed: Amazon RDS Instances: db.m1.large vs db.m3.large #programming #fix #computers

Fixed: Amazon RDS Instances: db.m1.large vs db.m3.large #programming #fix #computers

Amazon RDS Instances: db.m1.large vs db.m3.large

Recently, Amazon announced new instance types for RDS.

Currently, we are running db.m1.large, and it looks like the new db.m3.large is comparable but cheaper.

We’re new to AWS, so before moving these over I wanted to double check with you guys that there are no hidden “gotchas” I’m not seeing. Are there any reasons notto move our instances to the…

View On WordPress

[goodanswerbiz]

Resolved: AWS RDS connection count #solution #fix #dev

Resolved: AWS RDS connection count #solution #fix #dev

AWS RDS connection count

I am using AWS RDS with MySQL for a project and have a “large” instance. The documentation is clear on what this means as far as compute resources and RAM goes, but I can’t find anything that documents how many open database connections that I can have. The app that I am using is PHP and it utilizes PDO with persistent connections. This means that the number of open…

View On WordPress

[sevennet-blog]

How-to: What is "freeable memory"? #solution #development #answer

How-to: What is "freeable memory"? #solution #development #answer

What is "freeable memory"?

Amazon RDS has a metric for ‘freeable memory’. It appears to go down in a sawtooth pattern:

https://skitch.com/adamnelson/rnhpu/aws-management-console

This leads me to believe that it’s memory that is being used by MySQL for caching and that when the cache expires, more freeable memory appears. Any definitive documentation would be great.

Answer [by gtirloni]: What is…

View On WordPress