Google Cloud Platform Blog
Using dbShards and Cloud SQL to provide MySQL Scalability and Reliability
Thursday, February 13, 2014
Today’s guest blog comes from Cory Isaacson, CEO/CTO at CodeFutures. CodeFutures is the maker of dbShards Technology, a proven suite of components and tools for working with relational database management systems. dbShards database clusters have been in production for over 3 years in demanding applications supporting multi-terabyte databases with high read and write loads.
Based on our extensive expertise in the database scalability, we were intrigued to work with Google Cloud SQL because if its reliability features. For example, every byte written to Cloud SQL is stored multiple times in multiple locations, so the data is safe and available even in the case of multiple outages, an unmatched capability with Database as a Service vendors.
We initially tested with our dbShards/Migrate tools, allowing customers to seamlessly move their databases from any location — a traditional data center or another cloud vendor — to Google Cloud SQL. The product is based on dbShards patented replication technology, called Continuous Replication, that allows customers to replicate their data from outside the DBMS engine. This results in a no-risk experience without downtime. dbShards/Migrate can also be used to maintain a disaster recovery site for their database, in a remote cloud region, or even hosted by a totally different cloud vendor.
The key to dbShards/Migrate is its ability to continuously and reliably replicate transactions from one database or cluster to another in a remote location over the internet as a wide area network. Because the product replicates transactions outside the DBMS, it is is even possible to replicate from a Database as a Service where access to standard vendor replication facilities may not be available. While dbShards/Migrate continuously replicates transactions from the source to the target environment, customers can perform a reliable point-in-time snapshot of the source database, restoring it in the target environment with no lost data. It is even possible to perform the process several times to ensure full testing of the new cloud environment before switching live application servers to the target provider.
During our tests, Cloud SQL performed extremely well. Our objective was to provide our initial test customer (
http://www.genoo.com
) with a near-zero downtime transition of their database from their existing cloud vendor to Google Cloud SQL. Using the Cloud SQL capabilities, we were able to perform the process repeatedly — and flawlessly. In fact, our customer told us they did not even notice that the transition had occurred. You can read more
in this case study
.
An important factor with Cloud SQL is its built-in redundancy. As mentioned earlier, data written to Cloud SQL is stored multiple times in multiple locations, offering an incredible level of reliability. dbShards replication technology can be used to supplement Cloud SQL’s reliability, to perform seamless database modifications when needed — all without downtime.
dbShards is of course well-known for its industry leading database sharding capabilities. This will be of particular benefit to large database users in Cloud SQL, as currently Cloud SQL has a limit of 500GB per instance. Using dbShards, a customer can support multiple terabytes of data, completely eliminating this limitation as a concern.
Next steps for CodeFutures will be to benchmark our scalability in Cloud SQL, validating dbShards sharding capabilities and comparing the results to other cloud vendors and MySQL alternatives.
Learn more about dbShards/Migrate here
.
-Contributed by Cory Isaacson, CEO/CTO, CodeFutures
No comments :
Post a Comment
Don't Miss Next '17
Use promo code NEXT1720 to save $300 off general admission
REGISTER NOW
Free Trial
GCP Blogs
Big Data & Machine Learning
Kubernetes
GCP Japan Blog
Labels
Announcements
56
Big Data & Machine Learning
91
Compute
156
Containers & Kubernetes
36
CRE
7
Customers
90
Developer Tools & Insights
80
Events
34
Infrastructure
24
Management Tools
39
Networking
18
Open Source
105
Partners
63
Pricing
24
Security & Identity
23
Solutions
16
Stackdriver
19
Storage & Databases
111
Weekly Roundups
16
Archive
2017
Feb
Jan
2016
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2015
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2014
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2013
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2012
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2011
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2010
Dec
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2009
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Mar
Feb
Jan
2008
Dec
Nov
Oct
Sep
Aug
Jul
Jun
May
Apr
Feed
Subscribe by email
Technical questions? Check us out on
Stack Overflow
.
Subscribe to
our monthly newsletter
.
Google
on
Follow @googlecloud
Follow
Follow
Follow
No comments :
Post a Comment