Google Cloud Data Platform | Technology solutions

Fully managed SQL Server, PostgreSQL, and MySQL on Google Cloud

Cloud SQL is a fully managed database service which makes it easy to set up, maintain, manage, and administer your relational PostgreSQL and MySQL databases in the cloud. Hosted on Google Cloud Platform, Cloud SQL offers a high performance, scalable, and convenient infrastructure for applications running anywhere.

This is what we like about running MySQL and PostgreSQL workloads on Google Cloud.

Discounts without lock-in.
Cloud SQL offers per-second billing, automatic sustained use discounts, and instance sizes to fit any budget. Database instances are easy to stop and start. There is no up-front commitment, and with sustained use discounts, you’ll automatically get discounted prices for databases that run continuously.
Focus on your application.
Google manages your database, so you can focus on your applications. Cloud SQL is perfect for WordPress sites, e-commerce applications, CRM tools, geospatial applications, and any other application that is compatible with MySQL or PostgreSQL.
Simple & fully managed.
Cloud SQL is easy to use. It doesn’t require any software installation. It automates all your backups, replication, patches, and updates – while ensuring greater than 99.95% availability, anywhere in the world.

Performance & scalability.
Cloud SQL delivers high performance and scalability with up to 10TB of storage capacity, 40,000 IOPS, and 416GB of RAM per instance.
Reliability & security.
Easily configure replication and backups to protect your data. Go further by enabling automatic failover to make your database highly available (HA). Your data is automatically encrypted and Cloud SQL is SSAE 16, ISO 27001, PCI DSS v3.0, and HIPAA compliant.

Needless to say, there are still challenges when moving your on-premises or hosted MySQL and PostgreSQL databases to Google Cloud SQL and we can help you by applying our best practices for running on the Google Cloud.

Deployment challenges for OLTP solutions on Google Cloud Platform

The Google Cloud Platform SQL database service provides a cost-effective and high-performance alternative to other cloud providers for running OLTP workloads.

Here are some of the challenges that our customers expressed with GCP and how ABCloudz can help overcome the challenges.

Title	Challenge	Benefit
Choosing the right cloud offering	How do I decide which database offering on GCP is right for our workloads?	The following decision matrix is simplified below, based on your current on-premises database platform: If you are already running MySQL or PostgreSQL, use the Cloud SQL managed service. If you are already running Microsoft SQL Server, use the SQL Server images powered by the Google Compute Engine. If you are already running Microsoft SQL Server and are looking to reduce your overall operating expenses, consider migrating to Cloud SQL for MySQL or PostgreSQL.
Choosing the right size of the cloud instance	How do you know what size of Compute Engine, or Google Cloud instance to use without overprovisioning?	We use our in-house tools to monitor your on-premises database performance over a period of time along with information about the server to generate recommendations for sizing across the various services. Based on the monitoring results, we can also make recommendations for combining multiple databases on a single instance to reduce licensing costs for the service if it makes sense.

Title

Challenge

Benefit

Choosing the right cloud offering

How do I decide which database offering on GCP is right for our workloads?

The following decision matrix is simplified below, based on your current on-premises database platform:

If you are already running MySQL or PostgreSQL, use the Cloud SQL managed service.
If you are already running Microsoft SQL Server, use the SQL Server images powered by the Google Compute Engine.
If you are already running Microsoft SQL Server and are looking to reduce your overall operating expenses, consider migrating to Cloud SQL for MySQL or PostgreSQL.

Choosing the right size of the cloud instance

How do you know what size of Compute Engine, or Google Cloud instance to use without overprovisioning?

We use our in-house tools to monitor your on-premises database performance over a period of time along with information about the server to generate recommendations for sizing across the various services. Based on the monitoring results, we can also make recommendations for combining multiple databases on a single instance to reduce licensing costs for the service if it makes sense.

Featured services for Google Cloud data platform

We provide a comprehensive set of features to help you get the most out of the Google Cloud data platform for transaction processing workloads.

Moving on-premises databases to the same platform
Migrating databases from one platform to another
Developing cost estimation models for Google Cloud deployments including SQL Server on GCP Compute Engine instances.
Creating high availability failover solutions across regions.

Here are some examples of the services that we provide for running online transaction processing workloads on Google Cloud.

Database Migration to Google Cloud

Take advantage of Google Cloud Platform benefits, moving your workloads either to Compute Engine or Cloud Database.

Database Consulting

Check out the database consulting services we have used to help customers like you get the most out of their database platform.

Operational Data Management

Turn data management from a resource-consuming task into a value-generating process. Partner with ABCloudz to receive services from industry-leading experts wielding the latest tools and products to enhance your operational data management.

Getting Started Offers

We have a variety of getting started offers to help your team deploy database solutions on Google Cloud Platform. We recommend starting with the Future-State Architectural Design Engagement to help build a roadmap for your deployment.

Future-State Architectural Design

Everyone is talking about the need for a digital transformation, but how do you get there? See how our future-state architecture design can use cutting edge technology to meet your organization’s needs.

Database Migration to Google Cloud

Take advantage of Google Cloud Platform benefits, moving your workloads either to Compute Engine or Cloud Database.

DevOps solutions

Our DevOps services assist large and medium enterprises in achieving higher efficiency in development and operations, reducing time-to-market, and delivering better quality software builds. We do this by identifying issues early, ensuring the code is always in a releasable state, and developing a DevOps strategy that enhances coordination and user experience.

DevSecOps

As businesses continue to rely on software to drive innovation and growth, the importance of secure code cannot be overstated. That's where DevSecOps comes in. DevSecOps is a holistic approach to software development that integrates security considerations at every stage of the development process. By adopting DevSecOps, you can ensure that your software is secure, compliant, and reliable, all while reducing your time to market and minimizing downtime.

Getting the most out of Google Cloud data platform

At ABCloudz, we help our customers make the most out of the Google Cloud Platform. We migrate your data to and from the most widely used commercial and open-source databases on the Google Cloud data platform, with SQL database services deploying quickly and securely, ensuring minimal downtime, high availability, and scalability. We can help you set up, operate, and support your OLTP workloads on the Google cloud, ensuring that your I/O-intensive workloads will always have sufficient level of IOPS performance. ABCloudz experienced cloud solutions architects can provide an assessment of what it takes to migrate your existing on-premises databases to migrate to GCP.

Our team can migrate database schemas and data through automation tools, reducing risks and ensuring a smooth migration with minimal downtime. We have an extensive internal knowledgebase to help convert code that the automated tools don’t understand to the target GCP database technology platform of your choice. In addition, our application developers are experts in .NET, Java, JavaScript and other programming frameworks and languages to help you modify the applications which connect to your database so that they will work well with the Google Cloud data platform SQL database services. Check the video to see how we’ve helped our customers with GCP.