Welcome!

@CloudExpo Authors: Elizabeth White, Pat Romanski, Yeshim Deniz, Liz McMillan, Aruna Ravichandran

Related Topics: @CloudExpo, Microsoft Cloud, Silverlight, Cloud Security

@CloudExpo: Blog Feed Post

Amazon RDS vs. SQL Azure

The birth of the DBMS Utility

Amazon Cloud Journal

Back in July I wrote my post about databases in the cloud.  The big surprise that I discovered at the time was that the only “Native” RDBMS offering in the cloud came from Microsoft. Microsoft SQL Azure (launching formally at the PDC in a few weeks) is a mostly-compatible SQL Server as a Service release complete with support for Transact SQL/TDS.  SQL Azure is a multitenanted DBMS with several customers running databases up to 10GB in size on a single server.  Their target is the 95% of business applications running in the enterprise that have databases with less than 5GB of data (based on their research).  Well, Microsoft is alone no more.

Today, Amazon’s Werner Vogels announced the Amazon Relational Database Service (RDS), which is a fully MySQL 5.1-compatible database as a service offering.  Sure, Joyent launched their MySQL Accelerator in August, but nobody seemed to notice.  Today’s RDS announcement from Amazon, combined with SQL Azure, heralds a new era in production scale RDBMS-as-a-Service (RDBaaS).  By answering SQL Azure and fully validating the RDBaaS opportunity, Amazon has jump-started a fundamental transition in the $18B market for database systems.

DBMSs are now part of the utility model of cloud computing.

Historically, DBMSs have been something that you licensed (CapEx), installed, and physically managed and administered.  Going forward, DBMSs will be something you use and perform logical administration and tuning on top of — but you won’t install, configure them, or worry about your log files jamming your disks and crashing your Web site.  The RDBMS will just be there, ready for your applications, automatically backed up and replicated, and operated flawlessly as part of the fabric of your cloud.

The DBMS Market Dynamic

By providing MySQL, Amazon is catering to the Web and SaaS crowd, and less so to the enterprise.  Conversely, Microsoft is well-positioned to compete in the far larger and more lucrative enterprise RDBMS market.  Yes, there is MySQL in the enterprise, but it’s a side-show to Oracle, SQL Server and IBM’s DB2 (with a sprinkling of Sybase and others).

Speaking of which, how will Oracle, IBM and Sybase respond?  IBM has their cloud offerings and will support DB2 fully – but will they be as innovative?  Oracle’s stalled acquisition of Sun may eventually lead to an Oracle cloud where they would be able to offer a similar service.  And frankly, out of all of the DBMSs out there, Oracle’s users have the most to gain from not having to hassle with that big and hard to manage system.  Sybase?  They seem to be dateless at this point.  They don’t offer a cloud (and likely won’t), can’t get a leading cloud to back them with their small market share, and tend to only be used in really intense applications like trading and risk analytics on Wall Street – which are less likely to migrate to the cloud soon.

I don’t see a scenario where MySQL-based DBaaS offerings aren’t dominating the Web/SaaS market (MySQL the software dominates it today).  Nor do I see a market for enterprise DBaaS that doesn’t have SQL Azure in the lead.   There will be crossover (more with MySQL in the enterprise than SQL Azure in the Web/SaaS environment).  Oracle may be able to craft a solution that enterprise-focused cloud providers (Terremark, Unisys, etc.) can use, but I wouldn’t bet on it soon.

Amazon RDS and Microsoft SQL Azure Compared

This is not intended to be a rigorous review, but there are some fairly significant differences in the approach taken by these vendors that are worth exploring.

Deployment Model

SQL Azure is a multi-tenant service with multiple DBs on the same machine in a shared infrastructure environment.  In some ways this is similar to how I believe Rackspace manages MySQL in their Cloud Sites business.  You don’t manage the types of instance you run other than to select from two pricing tiers.  The pros of this model is that they can offer SQL Server for as low as $10/month up to 1GB (or $99/month for 10G — nothing in the middle).  If there’s a downside, it’s that some users might want to feel more like they can kick the dbms more directly.  Also, by having a 10GB limit they force design decisions on applications with larger databases. They recommend partitioning (sharding) your data set across  multiple DBMS instances to manage more than 10GB.

RDS is a bit different in that they provision individual special-purpose EC2 instances into your AWS account with a larger range of databases — from 5GB to 1 terabyte!  They also let you control the type of instance, from Small (1.7GB RAM, 1 virtual core, etc) to Quadruple Extra Large – no foam – (68GB RAM, 8 souped up virtual cores, etc.).  This gives you more control, but also makes you have to think more about your database — but then that’s how AWS works overall.  You can get pretty large (1TB) without sharding due to size, though you may have to shard your DBMS for performance as this is not a “scale out” solution.  My friends at Akiba Technologies in Boston are building a killer engine that eliminates sharding and radically improves performance for most MySQL applications. They’re a couple months from alpha, but this stuff is seriously kickin’ and should be considered by any other cloud provider feeling the need to compete in the RDBaaS space (disclosure, I am an advisor to Akiba).

One note is that, unlike SQL Azure, your bill can get pretty large for RDS.  The smallest instance, is $0.11/hour, which is $80.30 per month (they are planning “reserved instance” pricing in the future – which will reduce that price).  For their largest server, the bill is $2,270/month – plus you pay for the DBMS storage separately at $0.10/GB).

Database Support

SQL Azure is mostly compatible with SQL Server, but not 100%.  SQL Azure supports a reasonably large subset of T-SQL.  Here is their FAQ on compatibility:

SQL Azure is built on SQL Server database technologies that are used for running mission-critical applications in the enterprise as well as on the Web. Since SQL Server is a broad data platform that can handle all data types from birth to archival, there are many associated capabilities that the data platform provides. SQL Azure is exposing a large subset of these relational capabilities and extending them as services in the cloud.

These services feature built-in high scale, availability, and self-management, and are provided in a way that makes it easy for customers and partners to consume over the Internet. SQL Azure, in its first iteration, exposes only the core RDBMS capabilities of what is in the full SQL Server data platform.

RDS, conversely, is 100% compatible with MySQL 5.1.  This is pretty sweet!

There are many more things to cover, and perhaps I’ll continue this post at another time.  The bottom line is that the market now has two credible, robust and innovative RDBaaS solutions, and it won’t be long before there are more.  Welcome to the era of the DBMS Utility.

Read the original blog entry...

More Stories By John Treadway

John Treadway is a Vice President at Cloud Technology Partners and has over 20 years of experience delivering technology and business solutions to domestic and global enterprises across multiple industries and sectors. As a senior enterprise technology and services executive, he has a successful track record of leading strategic cloud computing and data center initiatives. John is responsible for technology IP at Cloud Technology Partners, and is actively involved with client projects and strategic alliances. John is also an active blogger in the cloud computing space and authors the CloudBzz blog. Sites/Blogs CloudBzz

@CloudExpo Stories
Coca-Cola’s Google powered digital signage system lays the groundwork for a more valuable connection between Coke and its customers. Digital signs pair software with high-resolution displays so that a message can be changed instantly based on what the operator wants to communicate or sell. In their Day 3 Keynote at 21st Cloud Expo, Greg Chambers, Global Group Director, Digital Innovation, Coca-Cola, and Vidya Nagarajan, a Senior Product Manager at Google, will discuss how from store operations...
Nordstrom is transforming the way that they do business and the cloud is the key to enabling speed and hyper personalized customer experiences. In his session at 21st Cloud Expo, Ken Schow, VP of Engineering at Nordstrom, will discuss some of the key learnings and common pitfalls of large enterprises moving to the cloud. This includes strategies around choosing a cloud provider(s), architecture, and lessons learned. In addition, he’ll go over some of the best practices for structured team migrat...
SYS-CON Events announced today that Datera will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Datera offers a radically new approach to data management, where innovative software makes data infrastructure invisible, elastic and able to perform at the highest level. It eliminates hardware lock-in and gives IT organizations the choice to source x86 server nodes, with business model option...
With major technology companies and startups seriously embracing Cloud strategies, now is the perfect time to attend 21st Cloud Expo October 31 - November 2, 2017, at the Santa Clara Convention Center, CA, and June 12-14, 2018, at the Javits Center in New York City, NY, and learn what is going on, contribute to the discussions, and ensure that your enterprise is on the right path to Digital Transformation.
Recently, REAN Cloud built a digital concierge for a North Carolina hospital that had observed that most patient call button questions were repetitive. In addition, the paper-based process used to measure patient health metrics was laborious, not in real-time and sometimes error-prone. In their session at 21st Cloud Expo, Sean Finnerty, Executive Director, Practice Lead, Health Care & Life Science at REAN Cloud, and Dr. S.P.T. Krishnan, Principal Architect at REAN Cloud, will discuss how they bu...
Infoblox delivers Actionable Network Intelligence to enterprise, government, and service provider customers around the world. They are the industry leader in DNS, DHCP, and IP address management, the category known as DDI. We empower thousands of organizations to control and secure their networks from the core-enabling them to increase efficiency and visibility, improve customer service, and meet compliance requirements.
Digital transformation is changing the face of business. The IDC predicts that enterprises will commit to a massive new scale of digital transformation, to stake out leadership positions in the "digital transformation economy." Accordingly, attendees at the upcoming Cloud Expo | @ThingsExpo at the Santa Clara Convention Center in Santa Clara, CA, Oct 31-Nov 2, will find fresh new content in a new track called Enterprise Cloud & Digital Transformation.
SYS-CON Events announced today that NetApp has been named “Bronze Sponsor” of SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. NetApp is the data authority for hybrid cloud. NetApp provides a full range of hybrid cloud data services that simplify management of applications and data across cloud and on-premises environments to accelerate digital transformation. Together with their partners, NetApp emp...
SYS-CON Events announced today that N3N will exhibit at SYS-CON's @ThingsExpo, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. N3N’s solutions increase the effectiveness of operations and control centers, increase the value of IoT investments, and facilitate real-time operational decision making. N3N enables operations teams with a four dimensional digital “big board” that consolidates real-time live video feeds alongside IoT sensor data a...
The dynamic nature of the cloud means that change is a constant when it comes to modern cloud-based infrastructure. Delivering modern applications to end users, therefore, is a constantly shifting challenge. Delivery automation helps IT Ops teams ensure that apps are providing an optimal end user experience over hybrid-cloud and multi-cloud environments, no matter what the current state of the infrastructure is. To employ a delivery automation strategy that reflects your business rules, making r...
Smart cities have the potential to change our lives at so many levels for citizens: less pollution, reduced parking obstacles, better health, education and more energy savings. Real-time data streaming and the Internet of Things (IoT) possess the power to turn this vision into a reality. However, most organizations today are building their data infrastructure to focus solely on addressing immediate business needs vs. a platform capable of quickly adapting emerging technologies to address future ...
As people view cloud as a preferred option to build IT systems, the size of the cloud-based system is getting bigger and more complex. As the system gets bigger, more people need to collaborate from design to management. As more people collaborate to create a bigger system, the need for a systematic approach to automate the process is required. Just as in software, cloud now needs DevOps. In this session, the audience can see how people can solve this issue with a visual model. Visual models ha...
Enterprises are adopting Kubernetes to accelerate the development and the delivery of cloud-native applications. However, sharing a Kubernetes cluster between members of the same team can be challenging. And, sharing clusters across multiple teams is even harder. Kubernetes offers several constructs to help implement segmentation and isolation. However, these primitives can be complex to understand and apply. As a result, it’s becoming common for enterprises to end up with several clusters. Thi...
SYS-CON Events announced today that Avere Systems, a leading provider of hybrid cloud enablement solutions, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 – Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Avere Systems was created by file systems experts determined to reinvent storage by changing the way enterprises thought about and bought storage resources. With decades of experience behind the company’s founders, Avere got its ...
In the fast-paced advances and popularity in cloud technology, one of the most critical factors revolves around concerns for security of your critical data. How to assure both your company and your customers they can confidently trust and utilize your cloud environment is most often top on the list. There is a method to evaluating and providing security that exceeds conventional modes of protecting data both within the cloud as well externally on mobile and other devices. With the public failure...
Containers are rapidly finding their way into enterprise data centers, but change is difficult. How do enterprises transform their architecture with technologies like containers without losing the reliable components of their current solutions? In his session at @DevOpsSummit at 21st Cloud Expo, Tony Campbell, Director, Educational Services at CoreOS, will explore the challenges organizations are facing today as they move to containers and go over how Kubernetes applications can deploy with lega...
SYS-CON Events announced today that Avere Systems, a leading provider of enterprise storage for the hybrid cloud, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Avere delivers a more modern architectural approach to storage that doesn't require the overprovisioning of storage capacity to achieve performance, overspending on expensive storage media for inactive data or the overbui...
Gemini is Yahoo’s native and search advertising platform. To ensure the quality of a complex distributed system that spans multiple products and components and across various desktop websites and mobile app and web experiences – both Yahoo owned and operated and third-party syndication (supply), with complex interaction with more than a billion users and numerous advertisers globally (demand) – it becomes imperative to automate a set of end-to-end tests 24x7 to detect bugs and regression. In th...
Today most companies are adopting or evaluating container technology - Docker in particular - to speed up application deployment, drive down cost, ease management and make application delivery more flexible overall. As with most new architectures, this dream takes significant work to become a reality. Even when you do get your application componentized enough and packaged properly, there are still challenges for DevOps teams to making the shift to continuous delivery and achieving that reducti...
Microsoft Azure Container Services can be used for container deployment in a variety of ways including support for Orchestrators like Kubernetes, Docker Swarm and Mesos. However, the abstraction for app development that support application self-healing, scaling and so on may not be at the right level. Helm and Draft makes this a lot easier. In this primarily demo-driven session at @DevOpsSummit at 21st Cloud Expo, Raghavan "Rags" Srinivas, a Cloud Solutions Architect/Evangelist at Microsoft, wi...