Menu
My site's architecture includes ASP.Net & MySQL. I am planning to deploy it on Amazon Cloud. This would mean EC2 instance(s) and RDS. My query is regarding logging.
I'm ensuring that my application is stateless, so logging on application tier is ruled out. All state/persistence goes into RDS. When it comes to logging, I am not sure if RDS is a good choice (just speculating). Since it is new and I'd be logging database exceptions also, logging into RDS my not be correct. I guess the best option at my disposal is SimpleDB.
I'm looking for recommendations to choose between RDS and SimpleDB for the purpose of logging.
326
Amazon SimpleDB provides simple index and query capabilities. Amazon RDS enables you to run a fully featured relational database while offloading database administration. And, using one of our many relational database AMIs on Amazon EC2 and Amazon EBS allows you to operate your own relational database in the cloud.
Amazon RDS allows you to deploy scalable MySQL servers within minutes in a cost-efficient manner with easily resizable hardware capacity. This frees you up to focus on application development and leaves many of the traditional database administration tasks such as backups, patching, and monitoring in the hands of AWS.
Amazon RDS is easier to set up, manage, and maintain than running Oracle Database on Amazon EC2, and lets you focus on other important tasks, rather than the day-to-day administration of Oracle Database. Alternatively, running Oracle Database on Amazon EC2 gives you more control, flexibility, and choice.
Amazon SimpleDB is a highly available NoSQL data store that offloads the work of database administration. Developers simply store and query data items via web services requests and Amazon SimpleDB does the rest.
I was also figuring out where to log in Amazon cloud and decided to do it into SimpleDB, because relational database is much too complicated for logging purposes. I use Java in this case and there's a ready-made log appender for SimpleDB. I tried to google for something similar for .net but didn't find any :(
So, I recommend SimpleDB over RDS.
UPDATE 2010-03-02:
SimpleDB has an attribute value length restriction of 1024 bytes. So, if you get longer log messages, this has to be somehow taken care of. One solution is to split the log message to multiple attributes (i.e. columns). There can be 256 attribute name-value pairs, which gives us plenty of room.
150
If you love us? You can donate to us via Paypal or buy me a coffee so we can maintain and grow! Thank you!
Donate Us With
