Tag: Amazon

I’ve been playing around with running databases in the cloud recently. It’s quite simplistic stuff, just to get a feel for it and investigate the possibilities of using it for some projects at work. Here’s what I’ve got so far.

Overview:

• Oracle Databases in the Cloud

Oracle:

• Amazon Web Services (AWS) : Relational Database Services (RDS) for Oracle
• Amazon Web Services (AWS) : Installation of Oracle on EC2
• Installation of an Oracle Database on Azure
• Oracle Cloud : Schema as a Service

MySQL:

• Amazon Web Services (AWS) : Relational Database Services (RDS) for MySQL

SQL Server:

• Amazon Web Services (AWS) : Relational Database Services (RDS) for SQL Server
• SQL Server Databases on Azure

It’s hard to differentiate between the cloud providers if you are just using them to provide a VM and self managing a system on it. It’s just another box provider.

In contrast the DBaaS offerings are much more interesting. I really like what Amazon are doing with RDS for Oracle/MySQL/SQL Server. I think these would work very well for *our* MySQL and SQL Server installations, which tend to be quite simple. I’m not sure I can live with some of the restrictions for RDS for Oracle, but that’s probably because I’m a snobby DBA type, who thinks he knows best. 🙂 The DBaaS for SQL Server on Azure is also really nice. You get less control than the RDS version, but maybe that’s a good thing.

You might have noticed I’ve not written much about Oracle Cloud yet. I should be getting a trial of the platform this month, so I will be able to fill in those gaps then.

Cheers

Tim…