Browsing articles tagged with "amazonrds - Admins Goodies"
Dec 22, 2012
tom

EC2 Ubuntu with WordPress can’t connect to RDS

I have set up a WordPress website on a Ubuntu 12.04 Amazon ec2 machine by following this tutorial except the fact that I haven’t created a MySQL database and I am using an amazon RDS MySQL service. Everything works fine and I am able to create a configuration file during installation but when the installer asks for MySQL credentials. When I fill in the RDS credentials they don’t work. I even tried entering the credentials […]

Continue Reading »
Oct 29, 2012
tom

Amazon RDS and users, security

By default you got a username and password for your RDS database. Would it be dangerous to use the credentials on your production website, say in php files? Or is it necessary to create a user with less control of the db (e.g. only read)? However I can’t find the place to add user on amazon’s console. Asked by StCee Every production site needs to have credentials for the corresponding database they use. These files […]

Continue Reading »
Oct 3, 2012
tom

Cheapest High Available Web Server [closed]

I would like to create a high-available setup (e.g. a small cluster) for a webserver, i.e. it will run Apache, PHP and MySQL. There will be between 2-8 small websites running with only very little traffic and workload. High availability is however very important. I don’t want to be dependent on 1 datacenter, so there must be a minimum of 2 servers placed in different datacenters, and if one server goes down, the user must […]

Continue Reading »
Jul 10, 2012
tom

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 cannot replicate across regions. One possible solution (though we have not tried or proven […]

Continue Reading »
May 8, 2012
tom

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 that number be so unearthly high? […]

Continue Reading »
Apr 16, 2012
tom

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? Asked by mkirk The master user name can be recovered with the rds-describe-db-instances command. Answered by Jan Fabry Check more discussion of this question. Bookmark on Delicious Digg this post Recommend on Facebook share via Reddit Share with Stumblers Tweet about it Print for later Bookmark in Browser Tell a friend

Continue Reading »
Mar 28, 2012
tom

I/O intensive MySql server on Amazon AWS

We recently moved from a traditional Data Center to cloud computing on AWS. We are developing a product in partnership with another company, and we need to create a database server for the product we’ll release. I have been using Amazon Web Services for the past 3 years, but this is the first time I received a spec with this very specific hardware configuration. I know there are trade-offs and that real hardware will always […]

Continue Reading »
Mar 13, 2012
tom

mysql 5.5 character encoding in Amazon RDS

I recently setup mysql 5.5.20 database in Amazon RDS with movable type but actual character encoding doesn’t take effect. I change the parameter group setting to utf8 like below. character-set-client-handshake = yes character_set_client = utf8 character_set_connection = utf8 character_set_database = utf8 character_set_filesystem = binary character_set_results = utf8 character_set_server = utf8 collation_connection = utf8_general_ci collation_server = utf8_general_ci init_connect = SET NAMES utf8 When I build Movable Type 5.13 database table encodeing is cp1252_West_Europe and collation is […]

Continue Reading »
Dec 8, 2011
tom

How do I quickly create new instances of complex MySQL database?

I’m managing an enterprise web application that uses Amazon’s RDS as our database server. Our architecture is such that when a user signs up for a new account we create a brand new database for them in RDS. The database has around 63 tables, most of which have indexes, and almost all have foreign key constraints. Currently we’re creating each new database by executing a large set of sql statements. This takes on average 57 […]

Continue Reading »
Aug 20, 2011
tom

Amazon RDS instance stopped responding

We’ve been running a large RDS instance in production for over year without a single moment of downtime. Recently, with a bigger budget and higher stakes, we decided to convert it to a multi-AZ instance, to improve reliability and redundancy of our data. Since then (about two weeks ago), we’ve had two serious failures of our instance which required rebooting. There is nothing in the ‘recent DB events’. There were two DB connection spikes recorded […]

Continue Reading »
Pages:12»