Stay organized with collections
Save and categorize content based on your preferences.
Migrate to the cloud with zero downtime with dbShards and Google Cloud SQL
Migrate to the cloud with zero downtime with dbShards and Google Cloud SQL A new method
Migrating precious data from one environment to another is a necessary but nerve-wracking task, with big benefits and high risks. Google Cloud SQL lets CTOs and CIOs breathe easier, by working with tools such as dbShards from CodeFutures.
Cloud SQL now supports MySQL Wire Protocol (MWP) connections, which means that Cloud SQL is available from nearly any application, anywhere, including low-latency connections from those running on Google Compute Engine and App Engine. Users can access a replicated, managed, cloud database as easily as if it were running on their laptop. But getting the most out of the cloud often involves migrating applications and data.
Downtime hurts revenue and reputation
“You might want to migrate your database from a data center to a cloud, or from some other environment to a Google cloud,” says Cory Isaacson, CodeFutures’ CEO. “You might want to do it because you’re changing environments, or for disaster recovery. There are all kinds of reasons to migrate. Typically, it is a very slow process, and you’re down the entire time.”
Worse, a bungled or unexpectedly prolonged migration can have a disastrous effect, particularly for online companies, or those offering “always-on” 24/7 services. “If a company is down for a day, the revenue they lose is really significant,” Isaacson adds. “And it’s not just the lost revenue. Their reputation is hurt. They lose users who don’t come back.”
“You can spend millions of dollars a year on a disaster recovery site alone. With these new approaches, you can migrate in much less time and much more cost-effectively with Google Cloud SQL.”
Cory Isaacson CEO, CodeFutures
Replication offers flexibility and peace of mind
Today, CodeFutures uses their dbShards/Migrate software with Cloud SQL and the MySQL Wire Protocol connection to make data migration fast and seamless. “Our methods allows you to do a seamless migration, without any extended downtime,” Isaacson explains. “There are two brief planned maintenance windows of 30 seconds to 2 minutes, one at the beginning of the process and one at the end. Outside of that, you have a continuously running application with reliable writes for all transactions.”
The ability to replicate your data in many places, including many different clouds, gives you flexibility and peace of mind. You’re no longer locked in with one cloud provider or database service. By having copies of your valuable data in many places, you are completely free to move between them. Even if one data center should somehow fail completely, all of your data is still safe and available elsewhere.
Migrate with no disruption to customers
Genoo, providers of online marketing tools and automation for small and midsize businesses, have already put wire protocol support to use. They were outgrowing their existing cloud services provider, but were worried about migrating a live application to another environment. So Kim Albee, Genoo’s founder and president, turned to dbShards, who could use MWP to migrate Genoo’s database without their customers even noticing. “I’ve been amazed by what Cloud SQL’s MWP support can do. Before this feature, migrating between cloud providers would have been too costly,” Albee said.
“This tool makes me a hero for my customers when something bad goes bump in the night,” she adds. “Literally, they will not even know we were impacted by it. And that is amazing, don’t you think?”
“ This tool makes me a hero for my customers when something bad goes bump in the night. Literally, they will not even know we were impacted by it.”
Kim Albeepresident, Genoo
Fast and cost-effective approaches
“You can spend millions of dollars a year on a disaster recovery site alone,” Isaacson says. “With these new approaches, you can migrate in much less time and much more cost-effectively with Google Cloud SQL.”
[[["Easy to understand","easyToUnderstand","thumb-up"],["Solved my problem","solvedMyProblem","thumb-up"],["Other","otherUp","thumb-up"]],[["Hard to understand","hardToUnderstand","thumb-down"],["Incorrect information or sample code","incorrectInformationOrSampleCode","thumb-down"],["Missing the information/samples I need","missingTheInformationSamplesINeed","thumb-down"],["Other","otherDown","thumb-down"]],[],[[["\u003cp\u003eGoogle Cloud SQL, in conjunction with dbShards, enables seamless database migration of any size without extended downtime.\u003c/p\u003e\n"],["\u003cp\u003eMigrations can occur between various environments, including cloud-to-cloud, data center-to-cloud, or cloud-to-data center, offering increased flexibility.\u003c/p\u003e\n"],["\u003cp\u003eThe replication capabilities of Google Cloud SQL ensure continuous operation and reliable transactions during the migration process.\u003c/p\u003e\n"],["\u003cp\u003eCompanies can benefit from a more cost-effective and rapid migration to Google Cloud SQL, in contrast to traditional methods.\u003c/p\u003e\n"],["\u003cp\u003eThe MySQL Wire Protocol (MWP) support allows access to Cloud SQL from numerous applications, facilitating smooth migration without disruption to customers.\u003c/p\u003e\n"]]],[],null,["# CodeFutures: No Downtime - Cloud SQL\n\n### At a Glance\n\n**Google Cloud SQL Results**\n\n- Seamless migration of any size database\n- Multiple migrations if desired, all without downtime\n- Continuous operation during migration, with reliable replication for all database transactions\n- Migration from cloud to cloud, data center to cloud, or cloud to data center\n- Disaster Recovery environments in multiple data centers and clouds or regions \n\n### About CodeFutures\n\nA privately funded supplier of the dbShards database suite, which offers scalability, reliability and manageability for distributed database clusters, CodeFutures has headquarters in Broomfield, CO. To learn more, visit www.dbshards.com About Genoo Based in Minneapolis, Genoo is a SaaS provider of online marketing tools, including marketing automation for small and midsize businesses. These tools help companies generate more leads, nurture them, and convert them into customers. Genoo's customers range from startups to companies with $100 million in revenue. \n\n### About Cloud SQL\n\n\nGoogle Cloud SQL is a web service that lets you create, configure, and manage relational databases that live on Google's infrastructure. This service manages and maintains your databases, letting you focus on your applications and services. Offering a familiar MySQL database, Google Cloud SQL lets you easily move data and applications in and out of the cloud. This provides high data portability and helps quickly leverage your existing database. \n\n\u003cbr /\u003e\n\n\nTo learn more about Google Cloud SQL, visit \u003chttps://cloud.google.com/sql/\u003e \n\nMigrate to the cloud with zero downtime with dbShards and Google Cloud SQL\n==========================================================================\n\nMigrate to the cloud with zero downtime with dbShards and Google Cloud SQL A new method\n---------------------------------------------------------------------------------------\n\n\nMigrating precious data from one environment to another is a necessary but nerve-wracking task, with big benefits and high risks. [Google Cloud SQL](https://cloud.google.com/sql/) lets CTOs and CIOs breathe easier, by working with tools such as dbShards from CodeFutures.\n\n\nCloud SQL now supports MySQL Wire Protocol (MWP) connections, which means that Cloud SQL is available from nearly any application, anywhere, including low-latency connections from those running on Google Compute Engine and App Engine. Users can access a replicated, managed, cloud database as easily as if it were running on their laptop. But getting the most out of the cloud often involves migrating applications and data.\n\nDowntime hurts revenue and reputation\n-------------------------------------\n\n\n\"You might want to migrate your database from a data center to a cloud, or from some other environment to a Google cloud,\" says Cory Isaacson, CodeFutures' CEO. \"You might want to do it because you're changing environments, or for disaster recovery. There are all kinds of reasons to migrate. Typically, it is a very slow process, and you're down the entire time.\"\n\n\nWorse, a bungled or unexpectedly prolonged migration can have a disastrous effect, particularly for online companies, or those offering \"always-on\" 24/7 services. \"If a company is down for a day, the revenue they lose is really significant,\" Isaacson adds. \"And it's not just the lost revenue. Their reputation is hurt. They lose users who don't come back.\" \n\n\"You can spend millions of dollars a year on a disaster recovery site alone. With these new approaches, you can migrate in much less time and much more cost-effectively with Google Cloud SQL.\"\n\n\nCory Isaacson CEO, CodeFutures\n\nReplication offers flexibility and peace of mind\n------------------------------------------------\n\n\nToday, CodeFutures uses their dbShards/Migrate software with Cloud SQL and the MySQL Wire Protocol connection to make data migration fast and seamless. \"Our methods allows you to do a seamless migration, without any extended downtime,\" Isaacson explains. \"There are two brief planned maintenance windows of 30 seconds to 2 minutes, one at the beginning of the process and one at the end. Outside of that, you have a continuously running application with reliable writes for all transactions.\"\n\n\nThe [ability to replicate your data](https://cloud.google.com/sql/docs/replication) in many places, including many different clouds, gives you flexibility and peace of mind. You're no longer locked in with one cloud provider or database service. By having copies of your valuable data in many places, you are completely free to move between them. Even if one data center should somehow fail completely, all of your data is still safe and available elsewhere.\n\nMigrate with no disruption to customers\n---------------------------------------\n\n\nGenoo, providers of online marketing tools and automation for small and midsize businesses, have already put wire protocol support to use. They were outgrowing their existing cloud services provider, but were worried about migrating a live application to another environment. So Kim Albee, Genoo's founder and president, turned to dbShards, who could use MWP to migrate Genoo's database without their customers even noticing. \"I've been amazed by what Cloud SQL's MWP support can do. Before this feature, migrating between cloud providers would have been too costly,\" Albee said.\n\n\n\"This tool makes me a hero for my customers when something bad goes bump in the night,\" she adds. \"Literally, they will not even know we were impacted by it. And that is amazing, don't you think?\" \n\n\" This tool makes me a hero for my customers when something bad goes bump in the night. Literally, they will not even know we were impacted by it.\"\n\n\nKim Albeepresident, Genoo\n\nFast and cost-effective approaches\n----------------------------------\n\n\n\"You can spend millions of dollars a year on a disaster recovery site alone,\" Isaacson says. \"With these new approaches, you can migrate in much less time and much more cost-effectively with Google Cloud SQL.\""]]
