{"id":1491,"date":"2022-09-06T00:23:17","date_gmt":"2022-09-05T18:53:17","guid":{"rendered":"https:\/\/cloudwithease.com\/?p=1491"},"modified":"2024-01-24T15:15:09","modified_gmt":"2024-01-24T09:45:09","slug":"google-cloud-database-services","status":"publish","type":"post","link":"https:\/\/cloudwithease.com\/google-cloud-database-services\/","title":{"rendered":"Google Cloud Database Services"},"content":{"rendered":"\n<div class=\"wp-block-rank-math-toc-block has-background\" style=\"background-color:#d7f7f7\" id=\"rank-math-toc\"><h2>Table of Contents<\/h2><nav><ul><li><a href=\"#data-types-structured-unstructured-data\">Data Types: Structured &amp; Unstructured Data<\/a><ul><li><a href=\"#1-structured-data\">1.) Structured Data:<\/a><\/li><li><a href=\"#2-unstructured-data\">2.) Unstructured Data: <\/a><\/li><\/ul><\/li><li><a href=\"#what-are-google-cloud-database-services\">What are Google Cloud Database services?<\/a><\/li><li><a href=\"#relational-sql-databases\">Relational (SQL) databases<\/a><ul><li><a href=\"#cloud-sql\">Cloud SQL<\/a><ul><li><a href=\"#advantages\">Advantages:\u00a0<\/a><\/li><li><a href=\"#disadvantages\">Disadvantages:<\/a><\/li><\/ul><\/li><li><a href=\"#cloud-spanner\">Cloud Spanner\u00a0<\/a><\/li><li><a href=\"#bare-metal-solution\">Bare Metal Solution<\/a><\/li><\/ul><\/li><li><a href=\"#non-relational-no-sql-databases\">Non-Relational (NoSQL) databases<\/a><ul><li><a href=\"#cloud-firestore\">Cloud Firestore<\/a><\/li><li><a href=\"#cloud-bigtable\">Cloud Bigtable<\/a><ul><li><a href=\"#advantages-1\">Advantages:<\/a><\/li><\/ul><\/li><\/ul><\/li><li><a href=\"#data-warehouse-database\">Data Warehouse Database <\/a><ul><li><a href=\"#cloud-big-query\">Cloud BigQuery<\/a><\/li><\/ul><\/li><\/ul><\/nav><\/div>\n\n\n\n<p>While migrating to cloud infrastructure other than compute, networking, storage etc. database migrations are also one of key components. Database migration services allow to move on premises relational data onto the cloud. Cloud providers offer a variety of database options to suit your organization needs.&nbsp;<\/p><div id=\"cloud-1732167460\" class=\"cloud-content cloud-entity-placement\"><script async src=\"\/\/pagead2.googlesyndication.com\/pagead\/js\/adsbygoogle.js?client=ca-pub-1375203873676133\" crossorigin=\"anonymous\"><\/script><ins class=\"adsbygoogle\" style=\"display:block; text-align:center;\" data-ad-client=\"ca-pub-1375203873676133\" \ndata-ad-slot=\"8195412531\" \ndata-ad-layout=\"in-article\"\ndata-ad-format=\"fluid\"><\/ins>\n<script> \n(adsbygoogle = window.adsbygoogle || []).push({}); \n<\/script>\n<\/div>\n\n\n\n<p>In the last blog, we discussed <a href=\"https:\/\/cloudwithease.com\/google-cloud-storage-options\/\" target=\"_blank\" rel=\"noreferrer noopener\">Google cloud storage option<\/a><a href=\"https:\/\/cloudwithease.com\/google-cloud-storage-options\/\">s<\/a>. Today we look more in detail about Google cloud database services and its features, how it works, use cases and so on.&nbsp;<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"data-types-structured-unstructured-data\"><strong>Data Types: Structured &amp; Unstructured Data<\/strong><\/h2>\n\n\n\n<p>Before discussing the Google Cloud database services options, we should be familiar with the data types. The Google cloud database services can be categorized as:<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"1-structured-data\"><strong>1.) Structured Data:<\/strong><\/h4>\n\n\n\n<p>It is the one in which the data can be organized in a structural format like rows and columns. E.g.- <strong><em>Cloud SQL, Cloud Spanner, Cloud Bigtable, Cloud BigQuery <\/em><\/strong>database services store data in a structured form.<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"2-unstructured-data\"><strong>2.) Unstructured Data: <\/strong><\/h4>\n\n\n\n<p>It involves a sequence of bytes (video, image, or document). The unstructured data is stored as objects in buckets and no insight can be fetched. E.g.- <em><strong>Cloud Firestore<\/strong><\/em> database service stores data in an unstructured form.<\/p>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"what-are-google-cloud-database-services\"><strong>What are Google Cloud Database services?<\/strong><\/h2>\n\n\n\n<p>Google offers various database options to suit your business needs. We will look at the different database options available in Google cloud: <strong><em>Relational (SQL) databases, Non-relational (NoSQL) databases and Data warehouse.<\/em><\/strong><\/p>\n\n\n\n<figure class=\"wp-block-gallery has-nested-images columns-default is-cropped wp-block-gallery-1 is-layout-flex wp-block-gallery-is-layout-flex\">\n<figure class=\"wp-block-image size-large\"><img decoding=\"async\" width=\"800\" height=\"455\" data-id=\"1494\" data-src=\"https:\/\/cloudwithease.com\/wp-content\/uploads\/2022\/09\/google-cloud-database-services-1.jpg\" alt=\"\" class=\"wp-image-1494 lazyload\" data-srcset=\"https:\/\/cloudwithease.com\/wp-content\/uploads\/2022\/09\/google-cloud-database-services-1.jpg 800w, https:\/\/cloudwithease.com\/wp-content\/uploads\/2022\/09\/google-cloud-database-services-1-300x171.jpg 300w, https:\/\/cloudwithease.com\/wp-content\/uploads\/2022\/09\/google-cloud-database-services-1-768x437.jpg 768w, https:\/\/cloudwithease.com\/wp-content\/uploads\/2022\/09\/google-cloud-database-services-1-600x341.jpg 600w\" data-sizes=\"(max-width: 800px) 100vw, 800px\" src=\"data:image\/svg+xml;base64,PHN2ZyB3aWR0aD0iMSIgaGVpZ2h0PSIxIiB4bWxucz0iaHR0cDovL3d3dy53My5vcmcvMjAwMC9zdmciPjwvc3ZnPg==\" style=\"--smush-placeholder-width: 800px; --smush-placeholder-aspect-ratio: 800\/455;\" \/><\/figure>\n<\/figure>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"relational-sql-databases\"><strong>Relational (SQL) databases<\/strong><\/h2>\n\n\n\n<p>In relational database services, the data is stored in a structural format like rows and columns. Relational databases use Structured Query Language or SQL. The relational database options in Google Cloud are:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"cloud-sql\"><strong>Cloud SQL<\/strong><\/h3>\n\n\n\n<p>It is a managed MySQL database. The second generation of cloud SQL currently in beta supports MySQL 5.6 and 5.7. The available instance sizes are ranging from 10 GB to 10 TB with up to 16 vCPUs and 104 GB of RAM. Zone redundancy is built in (automated). Ideally suited for monolithic OLTP applications such as content management systems, Enterprise resource planning (ERP) and Customer relationship management (CRM).<\/p>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"advantages\"><strong>Advantages:&nbsp;<\/strong><\/h4>\n\n\n\n<p>Using Cloud SQL has some advantages such as&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>lower maintenance costs,&nbsp;<\/li>\n\n\n\n<li>provides backup and disaster recovery,&nbsp;<\/li>\n\n\n\n<li>encryption and firewall protection,&nbsp;<\/li>\n\n\n\n<li>ease of management,&nbsp;<\/li>\n\n\n\n<li>ease of integration and so on.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"disadvantages\"><strong>Disadvantages:<\/strong><\/h4>\n\n\n\n<p>However, it has certain limitations such as,<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>If you need to increase IOPS beyond 10K or store data more than 10 TB you cannot achieve that by simply adding a new node.&nbsp;<\/li>\n\n\n\n<li>There is no horizontal write scalability in cloud SQL so you have to rewrite the application.<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"cloud-spanner\"><strong>Cloud Spanner<\/strong>&nbsp;<\/h3>\n\n\n\n<p>Cloud Spanner is a globally distributed highly available relational service with single and multi-region deployment configurations. Inserts and updates are using a custom<a href=\"https:\/\/ipwithease.com\/application-program-interface-api\/\" target=\"_blank\" rel=\"noreferrer noopener\"> API <\/a>which reads DDL operations using a spanner specific flavour of SQL.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It offers automatic, synchronous replication within and across regions for high availability.<\/li>\n\n\n\n<li>It is ideal for distribution of OLTP Apps like retail product catalogue, SaaS user identity and online games.&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"bare-metal-solution\"><strong>Bare Metal Solution<\/strong><\/h3>\n\n\n\n<p>This solution is used particularly if you want to shift Oracle databases into Google cloud. Bare metal solution thus helps to run the specialized workloads with low latency on Google Cloud.&nbsp;<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It enables data center retirements.<\/li>\n\n\n\n<li>Facilitate the modernization of legacy applications.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"non-relational-no-sql-databases\"><strong>Non-Relational (NoSQL) databases<\/strong><\/h2>\n\n\n\n<p>In non-relational database services, the data is stored in an unstructured non-tabular format. Non-Relational databases do not use SQL. The non-relational database options in Google Cloud are:<\/p>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"cloud-firestore\"><strong>Cloud Firestore<\/strong><\/h3>\n\n\n\n<p><a href=\"https:\/\/firebase.google.com\/docs\/firestore\" target=\"_blank\" rel=\"noreferrer noopener\">Cloud Firestore<\/a> is a NoSQL service where there are no tables, or rows instead data is stored in documents which are organized into collections.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It supports native SDKs for web, Android and iOS apps.<\/li>\n\n\n\n<li>It has powerful querying capabilities and has a document-oriented data model.<\/li>\n\n\n\n<li>Cloud Filestore is ideal for building client side mobile and web applications, gaming leaderboards, and global scale user presence.&nbsp;<\/li>\n<\/ul>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"cloud-bigtable\"><strong>Cloud Bigtable<\/strong><\/h3>\n\n\n\n<p>Large scale workload processing is the best bet for Bigtable NoSQL stores. Bigtable is a hardened database which is used by many Google owned products.<\/p>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It has an APACHE HBase API, and it can integrate with Hadoop and other <a href=\"https:\/\/cloudwithease.com\/cloud-computing-vs-big-data\/\" target=\"_blank\" rel=\"noreferrer noopener\">big data <\/a>products. It has two options: SSD and HDD backend storage.&nbsp;<\/li>\n\n\n\n<li>With SSD it supports 10,000 queries per second on a single node cluster with a linear improvement in performance as more nodes are added.<\/li>\n\n\n\n<li>Bigtable only supports one index per table, updates only atomic at row level and it has no built-in replication within zones or across regions.&nbsp;<\/li>\n\n\n\n<li>It is good for time series like Hybrid transactional \/Analytical processing (HTAP) apps which do not require multi-region deployments.<\/li>\n<\/ul>\n\n\n\n<h4 class=\"wp-block-heading\" id=\"advantages-1\"><strong>Advantages:<\/strong><\/h4>\n\n\n\n<ul class=\"wp-block-list\">\n<li>It has some advantages however such as<\/li>\n\n\n\n<li>It gives high throughput over low latency,&nbsp;<\/li>\n\n\n\n<li>you can add or remove cluster nodes without restart and no downtime,&nbsp;<\/li>\n\n\n\n<li>write data once and replicate where needed,&nbsp;<\/li>\n\n\n\n<li>gives consistency and control for high availability and isolation of read and write workloads. No manual intervention needed to repair data, synchronize writes and deletes.&nbsp;&nbsp;<\/li>\n<\/ul>\n\n\n\n<h2 class=\"wp-block-heading\" id=\"data-warehouse-database\"><strong>Data Warehouse Database <\/strong><\/h2>\n\n\n\n<h3 class=\"wp-block-heading\" id=\"cloud-big-query\"><strong>Cloud BigQuery<\/strong><\/h3>\n\n\n\n<p><strong>Cloud BigQuery <\/strong>is Google&#8217;s fully managed, petabyte scalable data warehousing service. Data is loaded via job or REST API. Near real-time analytics is supported via streaming. Customers pay for usage of storage based on number of queries and number of streaming inserts. Data residing in BigQuery is automatically replicated across data centres in a single region. Caching is provided by Memcache, which is part of the APP engine product.&nbsp;<\/p>\n","protected":false},"excerpt":{"rendered":"<p>While migrating to cloud infrastructure other than compute, networking, storage etc. database migrations are also one of key components. Database &#8230; <a title=\"Google Cloud Database Services\" class=\"read-more\" href=\"https:\/\/cloudwithease.com\/google-cloud-database-services\/\" aria-label=\"Read more about Google Cloud Database Services\">Read more<\/a><\/p>\n","protected":false},"author":3,"featured_media":1496,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"pmpro_default_level":"","footnotes":""},"categories":[20,38,45],"tags":[57,61],"class_list":["post-1491","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-cloud-gcp","category-cloud-technologies","category-tools-services","tag-gcp","tag-toolsservices","pmpro-has-access"],"_links":{"self":[{"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/posts\/1491","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/comments?post=1491"}],"version-history":[{"count":9,"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/posts\/1491\/revisions"}],"predecessor-version":[{"id":3617,"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/posts\/1491\/revisions\/3617"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/media\/1496"}],"wp:attachment":[{"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/media?parent=1491"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/categories?post=1491"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/cloudwithease.com\/wp-json\/wp\/v2\/tags?post=1491"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}