Feeds

Amazon fires up worldwide Read Replicas for hosted MySQL

Write on one continent, read from replicas nearby

High performance access to file storage

Developers that use the hulking Amazon Web Services infrastructure cloud can now shift Read Replicas of data into other global data center hubs.

The new feature was announced at the web giant's re:Invent show earlier in November and has now been made available. Previously, Read Replicas could only be shifted about within available zones. Now they can be flung across continents.

Read Replicas are an Amazon creation that uses MySQL's internal replication features to brew up a special instance type that reflects changes made to a master database.

Up to five Read Replicas can be created for a single database instance, the company says. AWS admins will be charged for the data transferred out of the source region.

By allowing Read Replicas to be shifted between geophysical regions, Amazon has made it possible for developers to write into a single hosted MySQL Relational Database Service (RDS) system and then replicate elsewhere.

This saves them money, increases redundancy, and lowers latency, though the tech is not a good fit for applications that expect to efficiently handle write commands from multiple servers spread around the world.

"Cross Region Read Replicas are available for MySQL 5.6 and enable you to maintain a nearly up-to-date copy of your master database in a different AWS Region," Amazon CTO Werner Vogels wrote in a blog post that described the service.

"In case of a regional disaster, you can simply promote your read replica in a different region to a master and point your application to it to resume operations. Cross Region Read Replicas also enable you to serve read traffic for your global customer base from regions that are nearest to them."

The technology is available in all AWS regions except GovCloud, the company said.

By comparison, Google's own Compute Engine "CloudSQL" tech provides both synchronous and asynchronous replication but it does not appear to offer trans-continental copying in a relatively simple manner, as Amazon does.

Windows Azure's SQL Database is able to perform similar replication features, though it is unclear from Microsoft documentation that Redmond admins can get the granularity offered by Amazon with Read Replicas.

With the rollout of Read Replicas, Amazon has further increased the capabilities of RDS, sending a clear message to devs that if they want to get at new features they need to move off of the already deprecated AWS SimpleDB tech. ®

High performance access to file storage

More from The Register

next story
Seagate brings out 6TB HDD, did not need NO STEENKIN' SHINGLES
Or helium filling either, according to reports
European Court of Justice rips up Data Retention Directive
Rules 'interfering' measure to be 'invalid'
Dropbox defends fantastically badly timed Condoleezza Rice appointment
'Nothing is going to change with Dr. Rice's appointment,' file sharer promises
Cisco reps flog Whiptail's Invicta arrays against EMC and Pure
Storage reseller report reveals who's selling what
Just what could be inside Dropbox's new 'Home For Life'?
Biz apps, messaging, photos, email, more storage – sorry, did you think there would be cake?
IT bods: How long does it take YOU to train up on new tech?
I'll leave my arrays to do the hard work, if you don't mind
Amazon reveals its Google-killing 'R3' server instances
A mega-memory instance that never forgets
USA opposes 'Schengen cloud' Eurocentric routing plan
All routes should transit America, apparently
prev story

Whitepapers

Mainstay ROI - Does application security pay?
In this whitepaper learn how you and your enterprise might benefit from better software security.
Five 3D headsets to be won!
We were so impressed by the Durovis Dive headset we’ve asked the company to give some away to Reg readers.
3 Big data security analytics techniques
Applying these Big Data security analytics techniques can help you make your business safer by detecting attacks early, before significant damage is done.
The benefits of software based PBX
Why you should break free from your proprietary PBX and how to leverage your existing server hardware.
Mobile application security study
Download this report to see the alarming realities regarding the sheer number of applications vulnerable to attack, as well as the most common and easily addressable vulnerability errors.