Feeds

Send in the (MySQL) clones

Amazon takes relational to a higher plane, and cuts prices

Beginner's guide to SSL certificates

Amazon is making it easier, and cheaper, to roll out copies of MySQL for very large websites across its cloud.

On Tuesday, the company announced an update to its Amazon Relational Database Service that will let users create and delete multiple Read Replicas of MySQL instances in minutes, via a point-and-click interface.

MySQL has been the top relational pick on the web for those building websites and hyperscale services - Twitter and Facebook are MySQL users, for example.

Read Replicas are spun up to help hyperscale customers maintain query times as demand for a particular service increases.

Once a Read Replica is created from a specified source Database Instance, subsequent updates to the source code will be automatically replicated to the Read Replica, Amazon said.

The ability to spin up Read Replicas is important on Amazon because MySQL can be deployed across the tapestry of zones that comprise Amazon's service. Amazon splits its compute and storage service across four geographic zones, or AZs.

Automatic replication of changes across what Amazon calls Multi-AZ should help ensure there's consistency across the different portions of the Amazon cloud.

Vice President of database services at Amazon, WS Raju Gulabani said: "Amazon RDS now offers advantages in scalability, multi-data centre availability, elasticity and ease of administration at a fraction of the cost of operating MySQL servers on-premise."

Amazon also said that it is cutting the price of big databases. The organisation said this was in order to help organisations operating on tight margins squeak by - and to stop them from hopping to rival clouds.

Quadruple Extra Large Database Instances - 68GB of memory - and Double Extra Large Database Instances - 34Gb of memory - have been cut by 15 per cent.

Amazon also offers IBM's DB2, Informix Dynamic Server, Microsoft's SQL Server Standard Edition, and Oracle 11g.

Managing MySQL in large, distributed server settings is difficult, and there's no easy off-the-shelf approach to achieving scale or performance.

Sharding is one answer, where a very large database is partitioned as a shared-nothing system across a number of servers to achieve the high-levels of performance. Many of the social networks using MySQL have had to build their own sophisticated approaches.

A start-up called Xeround offers what it claims is an approach that delivers MySQL performance and scale without the sharding. Xeround uses in-memory, instead.

The company last month announced beta availability of its MySQL in the Cloud service, built on the MySQL Storage Architecture. The architecture acts as a pluggable storage engine that lets you upload your data and replace your existing, on-site MySQL database.

Xeround's beta is available on EC2 and through Xeround.com, or as a virtual appliance. ®

Intelligent flash storage arrays

More from The Register

next story
PEAK APPLE: iOS 8 is least popular Cupertino mobile OS in all of HUMAN HISTORY
'Nerd release' finally staggers past 50 per cent adoption
Microsoft to bake Skype into IE, without plugins
Redmond thinks the Object Real-Time Communications API for WebRTC is ready to roll
Microsoft promises Windows 10 will mean two-factor auth for all
Sneak peek at security features Redmond's baking into new OS
Mozilla: Spidermonkey ATE Apple's JavaScriptCore, THRASHED Google V8
Moz man claims the win on rivals' own benchmarks
Yes, Virginia, there IS a W3C HTML5 standard – as of now, that is
You asked for it! You begged for it! Then you gave up! And now it's HERE!
FTDI yanks chip-bricking driver from Windows Update, vows to fight on
Next driver to battle fake chips with 'non-invasive' methods
DEATH by PowerPoint: Microsoft warns of 0-day attack hidden in slides
Might put out patch in update, might chuck it out sooner
Ubuntu 14.10 tries pulling a Steve Ballmer on cloudy offerings
Oi, Windows, centOS and openSUSE – behave, we're all friends here
prev story

Whitepapers

Choosing cloud Backup services
Demystify how you can address your data protection needs in your small- to medium-sized business and select the best online backup service to meet your needs.
A strategic approach to identity relationship management
ForgeRock commissioned Forrester to evaluate companies’ IAM practices and requirements when it comes to customer-facing scenarios versus employee-facing ones.
High Performance for All
While HPC is not new, it has traditionally been seen as a specialist area – is it now geared up to meet more mainstream requirements?
Saudi Petroleum chooses Tegile storage solution
A storage solution that addresses company growth and performance for business-critical applications of caseware archive and search along with other key operational systems.
How to simplify SSL certificate management
Simple steps to take control of SSL certificates across the enterprise, and recommendations centralizing certificate management throughout their lifecycle.