Feeds

Amazon fires up worldwide Read Replicas for hosted MySQL

Write on one continent, read from replicas nearby

Internet Security Threat Report 2014

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. ®

Internet Security Threat Report 2014

More from The Register

next story
Docker's app containers are coming to Windows Server, says Microsoft
MS chases app deployment speeds already enjoyed by Linux devs
IBM storage revenues sink: 'We are disappointed,' says CEO
Time to put the storage biz up for sale?
'Hmm, why CAN'T I run a water pipe through that rack of media servers?'
Leaving Las Vegas for Armenia kludging and Dubai dune bashing
'Urika': Cray unveils new 1,500-core big data crunching monster
6TB of DRAM, 38TB of SSD flash and 120TB of disk storage
Facebook slurps 'paste sites' for STOLEN passwords, sprinkles on hash and salt
Zuck's ad empire DOESN'T see details in plain text. Phew!
SDI wars: WTF is software defined infrastructure?
This time we play for ALL the marbles
Windows 10: Forget Cloudobile, put Security and Privacy First
But - dammit - It would be insane to say 'don't collect, because NSA'
prev story

Whitepapers

Forging a new future with identity relationship management
Learn about ForgeRock's next generation IRM platform and how it is designed to empower CEOS's and enterprises to engage with consumers.
Cloud and hybrid-cloud data protection for VMware
Learn how quick and easy it is to configure backups and perform restores for VMware environments.
Three 1TB solid state scorchers up for grabs
Big SSDs can be expensive but think big and think free because you could be the lucky winner of one of three 1TB Samsung SSD 840 EVO drives that we’re giving away worth over £300 apiece.
Reg Reader Research: SaaS based Email and Office Productivity Tools
Read this Reg reader report which provides advice and guidance for SMBs towards the use of SaaS based email and Office productivity tools.
Security for virtualized datacentres
Legacy security solutions are inefficient due to the architectural differences between physical and virtual environments.