Welcome!

@CloudExpo Authors: Pat Romanski, Elizabeth White, Liz McMillan, Amitabh Sinha, Rajeev Kozhikkattuthodi

Related Topics: @CloudExpo, Microservices Expo

@CloudExpo: Article

The New DBA for the Cloud

Five skills that enterprise DBAs need to acquire to manage cloud

Cloud Database Administration:
Database administration skills are the core of traditional enterprises in the data center. DBAs with skills in replication, backup, recovery and  clustering have been in high demand over the years due to the way the enterprises have taken care all aspects of the database administration.

However, the advent of the Cloud has shifted much of the DBA duties from the Cloud Consumer  (Enterprises) to the Cloud Providers (EC2, Azure and more).

Is the role of DBA irrelevant in a Cloud world? This article discuss five new skills that regular enterprise DBAs should acquire to make their presence as unique as always.

1. Improve On NOSQL Database Usage And Skills
In computing, NoSQL is a term used to designate database management systems that differ from classic relational database management systems in some way. In a cloud managed environment, NOSQL databases are here to stay, and they have their own advantages especially  in processing large amounts of distributed data.

  • Google's BigTable
  • Amazon SimpleDB
  • Windows Azure Storage BLOB Storage

All the above mean that the Non-Relational database usage is here to stay and the current DBAs should identify appropriate usage and maintenance of them.

2. Capacity Planning in Terms of On-Demand Usage Cost
Over the years, DBAs have been very successful in reactive monitoring of storage usages in terms of  GB, TB of disk space and also in predicting future capacity planning. However, as the entire trust of Cloud Computing is about a chargeback model based on storage, it becomes even more important for the DBA to understand the costing models behind the storage and help the enterprise with the best model possible for a given cloud provider.

  • For example, SQL Azure Business Edition databases are charged at $99.99 up to 10 GB per month and goes on based on further storage , Data transfers = $0.10 in / $0.15 out / GB - ($0.10 in / $0.20 out / GB in Asia)
  • Similar Amazon RDS On Demand DB Instances cost $2.60 price per hour for a extra large DB instance and similarly data transfers are priced separately. Apart from this the concept of Reserved Instances and Backup storage additionally alter the pricing.

With the additional concepts behind Cloud storage and pricing, it is the DBAs who need to have these details behind them and can provide the organizations about accurate information of how the storage and usage costs of the database will look like in a cloud environment.

3. Multi Tenancy & Data Partitioning
Earlier DBAs have big  servers and databases with unlimited storage at their disposal and most times the databases have been exclusively owned by enterprise vertical domains and  very little DBAs worried about the size of a single database and the  tenants who share the database.

  • SQL Azure has a 50 GB Limit per database
  • For each DB Instance class, AmazonRDS provides you with the ability to select from 5 GB to 1 TB of associated storage capacity for your primary data set. While the storage is unlimited , provisioning storage on demand rather pre allocating , makes it more efficient.

The new limitations in the database storage and the need to store multiple tenants require DBAs to think of different ways of partitioning data across multiple databases, which will go a long way toward an efficient data organization for Cloud.

4. Monitoring
On-demand instances are provisioned based on the  usage of the application and hourly demands. Also  much of the  instances  are virtual server based and the IP Addresses that connect are virtual and may get changed over time. All these require that much more  monitoring capabilities need to be brought in by the DBAs to make sure how the databases behave to the demands and how they can be managed.

  • Amazon RDS makes DB Instance metrics available via theAmazon AWS CloudWatch service. You can access your metrics using theAmazon CloudWatch API Toolsor via the API itself.
  • MicrosoftSQL Azure Database enables a subset of dynamic management views to diagnose the performance problems, which might be caused by blocked or long-running queries, resource bottlenecks, poor query plans, and so on.

The above concepts clearly proves that the traditional DBA needs to know new tools and  new concepts behind monitoring a Cloud Database.

5. Data In & Data Out  Between Cloud & Data Centers
For very small organizations, it would almost be impossible for an enterprise to run its entire business on the Cloud. So with the Cloud adoption it will still be a hybrid environment of:

  • Continued usage of ‘On Premise' data center for mission critical applications
  • SaaS usage for certain scenarios
  • PaaS or IaaS usage for other scenarios

In this Hybrid situation, it's important for the DBA to have all the options to move data in and out of the cloud seamlessly in an efficient manner.

With SQL Azure Data Sync CTP2  Microsoft  delivering an update to SQL Azure Data Sync to enable synchronization between on-premises SQL Server and SQL Azure, giving customers greater flexibility in building solutions that span on-premises and the cloud. With SQL Azure Data Sync CTP2, customers can:

  • Extend enterprise data to the cloud rather than replace it
  • Move workloads to the cloud in stages preserving investment in existing infrastructure
  • Extend data to remote offices and retails stores
  • Enable new scenarios spanning enterprise and cloud

Similarly  Amazon RDS has multiple tools based on MYSQL Engine that supports loading data from  data center applications into Cloud.

Summary
Cloud has abstracted certain traditional DBA needs in an enterprise:

  • Installation
  • Backup
  • Recovery
  • Replication
  • Stand By Servers
  • Fail Over Servers

Cloud has indeed brought in new DBA skill requirements and hence the role of DBA is as important as before in a cloud managed environment. However, now the DBAs can concentrate more on the business needs and can support the ‘Do More With Less' slogan that marks the  Cloud Platform usage in enterprises.

More Stories By Srinivasan Sundara Rajan

Highly passionate about utilizing Digital Technologies to enable next generation enterprise. Believes in enterprise transformation through the Natives (Cloud Native & Mobile Native).

@CloudExpo Stories
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.
No hype cycles or predictions of zillions of things here. IoT is big. You get it. You know your business and have great ideas for a business transformation strategy. What comes next? Time to make it happen. In his session at @ThingsExpo, Jay Mason, Associate Partner at M&S Consulting, presented a step-by-step plan to develop your technology implementation strategy. He discussed the evaluation of communication standards and IoT messaging protocols, data analytics considerations, edge-to-cloud tec...
"When we talk about cloud without compromise what we're talking about is that when people think about 'I need the flexibility of the cloud' - it's the ability to create applications and run them in a cloud environment that's far more flexible,” explained Matthew Finnie, CTO of Interoute, in this SYS-CON.tv interview at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
@DevOpsSummit at Cloud Expo taking place Oct 31 - Nov 2, 2017, at the Santa Clara Convention Center, Santa Clara, CA, is co-located with the 21st International Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The widespread success of cloud computing is driving the DevOps revolution in enterprise IT. Now as never before, development teams must communicate and collaborate in a dynamic, 24/7/365 environment. There is ...
The financial services market is one of the most data-driven industries in the world, yet it’s bogged down by legacy CPU technologies that simply can’t keep up with the task of querying and visualizing billions of records. In his session at 20th Cloud Expo, Karthik Lalithraj, a Principal Solutions Architect at Kinetica, discussed how the advent of advanced in-database analytics on the GPU makes it possible to run sophisticated data science workloads on the same database that is housing the rich...
When growing capacity and power in the data center, the architectural trade-offs between server scale-up vs. scale-out continue to be debated. Both approaches are valid: scale-out adds multiple, smaller servers running in a distributed computing model, while scale-up adds fewer, more powerful servers that are capable of running larger workloads. It’s worth noting that there are additional, unique advantages that scale-up architectures offer. One big advantage is large memory and compute capacity...
New competitors, disruptive technologies, and growing expectations are pushing every business to both adopt and deliver new digital services. This ‘Digital Transformation’ demands rapid delivery and continuous iteration of new competitive services via multiple channels, which in turn demands new service delivery techniques – including DevOps. In this power panel at @DevOpsSummit 20th Cloud Expo, moderated by DevOps Conference Co-Chair Andi Mann, panelists examined how DevOps helps to meet the de...
What's the role of an IT self-service portal when you get to continuous delivery and Infrastructure as Code? This general session showed how to create the continuous delivery culture and eight accelerators for leading the change. Don Demcsak is a DevOps and Cloud Native Modernization Principal for Dell EMC based out of New Jersey. He is a former, long time, Microsoft Most Valuable Professional, specializing in building and architecting Application Delivery Pipelines for hybrid legacy, and cloud ...
Amazon started as an online bookseller 20 years ago. Since then, it has evolved into a technology juggernaut that has disrupted multiple markets and industries and touches many aspects of our lives. It is a relentless technology and business model innovator driving disruption throughout numerous ecosystems. Amazon’s AWS revenues alone are approaching $16B a year making it one of the largest IT companies in the world. With dominant offerings in Cloud, IoT, eCommerce, Big Data, AI, Digital Assista...
Artificial intelligence, machine learning, neural networks. We’re in the midst of a wave of excitement around AI such as hasn’t been seen for a few decades. But those previous periods of inflated expectations led to troughs of disappointment. Will this time be different? Most likely. Applications of AI such as predictive analytics are already decreasing costs and improving reliability of industrial machinery. Furthermore, the funding and research going into AI now comes from a wide range of com...
For organizations that have amassed large sums of software complexity, taking a microservices approach is the first step toward DevOps and continuous improvement / development. Integrating system-level analysis with microservices makes it easier to change and add functionality to applications at any time without the increase of risk. Before you start big transformation projects or a cloud migration, make sure these changes won’t take down your entire organization.
Internet of @ThingsExpo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, is co-located with 21st Cloud Expo and will feature technical sessions from a rock star conference faculty and the leading industry players in the world. The Internet of Things (IoT) is the most profound change in personal and enterprise IT since the creation of the Worldwide Web more than 20 years ago. All major researchers estimate there will be tens of billions devic...
We build IoT infrastructure products - when you have to integrate different devices, different systems and cloud you have to build an application to do that but we eliminate the need to build an application. Our products can integrate any device, any system, any cloud regardless of protocol," explained Peter Jung, Chief Product Officer at Pulzze Systems, in this SYS-CON.tv interview at @ThingsExpo, held November 1-3, 2016, at the Santa Clara Convention Center in Santa Clara, CA
21st International Cloud Expo, taking place October 31 - November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA, will feature technical sessions from a rock star conference faculty and the leading industry players in the world. Cloud computing is now being embraced by a majority of enterprises of all sizes. Yesterday's debate about public vs. private has transformed into the reality of hybrid cloud: a recent survey shows that 74% of enterprises have a hybrid cloud strategy. Me...
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.
SYS-CON Events announced today that Ayehu will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place on October 31 - November 2, 2017 at the Santa Clara Convention Center in Santa Clara California. Ayehu provides IT Process Automation & Orchestration solutions for IT and Security professionals to identify and resolve critical incidents and enable rapid containment, eradication, and recovery from cyber security breaches. Ayehu provides customers greater control over IT infras...
SYS-CON Events announced today that MobiDev, a client-oriented software development company, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. MobiDev is a software company that develops and delivers turn-key mobile apps, websites, web services, and complex software systems for startups and enterprises. Since 2009 it has grown from a small group of passionate engineers and business...
SYS-CON Events announced today that GrapeUp, the leading provider of rapid product development at the speed of business, will exhibit at SYS-CON's 21st International Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Grape Up is a software company, specialized in cloud native application development and professional services related to Cloud Foundry PaaS. With five expert teams that operate in various sectors of the market acr...
"We are a monitoring company. We work with Salesforce, BBC, and quite a few other big logos. We basically provide monitoring for them, structure for their cloud services and we fit into the DevOps world" explained David Gildeh, Co-founder and CEO of Outlyer, in this SYS-CON.tv interview at DevOps Summit at 20th Cloud Expo, held June 6-8, 2017, at the Javits Center in New York City, NY.
SYS-CON Events announced today that Enzu will exhibit at SYS-CON's 21st Int\ernational Cloud Expo®, which will take place October 31-November 2, 2017, at the Santa Clara Convention Center in Santa Clara, CA. Enzu’s mission is to be the leading provider of enterprise cloud solutions worldwide. Enzu enables online businesses to use its IT infrastructure to their competitive advantage. By offering a suite of proven hosting and management services, Enzu wants companies to focus on the core of their ...