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 »
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 »
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 »
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 »
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 »
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 friendContinue Reading »
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 »
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 »
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 »
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 »
- Understanding redundant power supplies
- Is there a way for administrators to disable users from installing Firefox extensions?
- Is there research material on NTP accuracy available?
- How to create a limited “domain admin” that does not have access to domain controllers?
- Can Windows RDC admin users be immune from being kicked?