geo-distributed-database

The Guiding Principles for Scaling Geo-distributed Databases In The Cloud

The Guiding Principles for Scaling Geo-distributed Databases In The Cloud

Todays world the digital economy runs in the cloud. Most consumers, including many business executives, dont know much about the inner workings of the cloud or its architecture even though they expect a lot from it. We expect clouds -- private, public and hybrid -- to perform and deliver information quickly, even if the data centers are scattered around the world.

These expectations dictate better cloud architectures and applications. These demands also drive the need for databases that scale in the cloud, can be geographically distributed, scale “horizontally” to quickly add compute power without being expensive and have transactional integrity that is common to relational databases. These drivers have given rise to geo-distributed databases.

Briefly, a geo-distributed database is a database spread across two or more geographically distinct locations and runs without degraded transaction performance.

But beyond this base definition of a geo-distributed database, what should business leaders, information technology (IT) managers and others involved with migrating systems to the cloud know about geo-distributed databases?

Read Also:
Google Sheets Gets Analytics, Visualization Features

Here are three key considerations to keep in mind about geographically distributed databases that support cloud-scale systems.

Horizontally Scalable

To easily accommodate compute-load spikes (or declines), a cloud database must be able to quickly scale horizontally. That way you can add commodity servers to handle more capacity without having to shut down and migrate workloads. Past computing architectures were designed to scale vertically -- to increase capacity, add a bigger, more powerful server, even if that meant some downtime. Relational databases can sometimes scale horizontally, but the amount is often limited and it typically means more software, more administration, and costly hardware.

Transactional Consistency

Cloud databases also should be transactionally consistent. If a database has been sliced up or “partitioned” as part of its geo-distribution, it is more challenging for cloud applications to maintain transactional integrity.

A better way is to always maintain transactional consistency with a database architecture that separates transaction management from data storage and presents what in effect is a single logical database for applications, even when geographically distributed. Most relational databases are transactionally consistent, which is often referred to as “ACID” compliance, for “atomicity, consistency, isolation & durability”. These properties guarantee that transactions are processed reliably. So two questions to keep in mind with a cloud database are -- can it be geographically distributed and is it ACID compliant?

Read Also:
Microsoft Cortana Analytics Suite Targets Businesses

Data Residency

Another benefit of a database that looks like one logical database even when it is geographically distributed is that data residency can be established at a specific location. This property supports compliance with data sovereignty laws cropping up in some countries that mandate that data about a citizen should remain in-country, even if the person or other authorized users can access the data via the cloud outside that country. When you start slicing and dicing a database architecture to support geo-distribution, data residency can be harder to achieve.



Data Science Congress 2017

5
Jun
2017
Data Science Congress 2017

20% off with code 7wdata_DSC2017

Read Also:
CIOs are Turning Agile to Meet Demands for Innovation

AI Paris

6
Jun
2017
AI Paris

20% off with code AIP17-7WDATA-20

Read Also:
Microsoft Cortana Analytics Suite Targets Businesses

Chief Data Officer Summit San Francisco

7
Jun
2017
Chief Data Officer Summit San Francisco

$200 off with code DATA200

Read Also:
BI and data management moving rapidly to the cloud
Read Also:
BI and data management moving rapidly to the cloud

Customer Analytics Innovation Summit Chicago

7
Jun
2017
Customer Analytics Innovation Summit Chicago

$200 off with code DATA200

Read Also:
Re-Engineering IT for Digital Transformation

HR & Workforce Analytics Innovation Summit 2017 London

12
Jun
2017
HR & Workforce Analytics Innovation Summit 2017 London

$200 off with code DATA200

Read Also:
Charting the data lake: Model normalization patterns for data lakes

Leave a Reply

Your email address will not be published. Required fields are marked *