{"id":77023,"date":"2020-09-28T16:00:00","date_gmt":"2020-09-28T13:00:00","guid":{"rendered":"https:\/\/en.buradabiliyorum.com\/the-best-solutions-for-running-a-database-on-google-cloud-platform-cloudsavvy-it\/"},"modified":"2020-09-28T16:00:00","modified_gmt":"2020-09-28T13:00:00","slug":"the-best-solutions-for-running-a-database-on-google-cloud-platform-cloudsavvy-it","status":"publish","type":"post","link":"https:\/\/buradabiliyorum.com\/en\/the-best-solutions-for-running-a-database-on-google-cloud-platform-cloudsavvy-it\/","title":{"rendered":"#The Best Solutions for Running a Database on Google Cloud Platform \u2013 CloudSavvy IT"},"content":{"rendered":"<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_89 counter-hierarchy ez-toc-counter ez-toc-custom ez-toc-container-direction\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">Table of Contents<\/p>\n<label for=\"ez-toc-cssicon-toggle-item-6aed6be01589d\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #dd3333;color:#dd3333\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #dd3333;color:#dd3333\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/label><input type=\"checkbox\"  id=\"ez-toc-cssicon-toggle-item-6aed6be01589d\" checked aria-label=\"Toggle\" \/><nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/buradabiliyorum.com\/en\/the-best-solutions-for-running-a-database-on-google-cloud-platform-cloudsavvy-it\/#Cloud_SQL\" >Cloud SQL<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/buradabiliyorum.com\/en\/the-best-solutions-for-running-a-database-on-google-cloud-platform-cloudsavvy-it\/#Cloud_Spanner\" >Cloud Spanner<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/buradabiliyorum.com\/en\/the-best-solutions-for-running-a-database-on-google-cloud-platform-cloudsavvy-it\/#FirebaseFirestore\" >Firebase\/Firestore<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/buradabiliyorum.com\/en\/the-best-solutions-for-running-a-database-on-google-cloud-platform-cloudsavvy-it\/#Memorystore\" >Memorystore<\/a><\/li><\/ul><\/nav><\/div>\n<p><strong>&#8220;#The Best Solutions for Running a Database on Google Cloud Platform \u2013 CloudSavvy IT&#8221;<\/strong><\/p>\n<div id=\"article-content-area\">\n<img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-4494\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/b3b859004588fc0d25c0249680972e6d\/p\/uploads\/2020\/04\/469724f6.png\" alt=\"google cloud platform\" width=\"700\" height=\"300\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Google\u2019s Cloud Platform offers many solutions for modernizing your existing database infrastructure. By moving to the cloud, and taking advantage of Google\u2019s PaaS offerings, you can reduce the headache of database administration.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cloud_SQL\"><\/span>Cloud SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-4527 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/2c725b756b394ead5c1ff0402f0f7973\/p\/uploads\/2020\/04\/ffd5f905.png\" alt=\"Google Cloud SQL Logo\" width=\"700\" height=\"299\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Cloud SQL is Google\u2019s alternative to AWS\u2019s RDS\u2014a simple managed database solution for MySQL, SQL Server, and PostgreSQL.<\/p>\n<p>Rather than having to configure the database yourself, it\u2019s all handled for you and manageable from the <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/console.cloud.google.com\/sql\/instances\">Cloud SQL Console<\/a>. You\u2019ll still access the database from your client <a href=\"https:\/\/buradabiliyorum.com\/en\/category\/download-scripts-themes-apps\/\" data-internallinksmanager029f6b8e52c=\"9\" title=\"Download Scripts &amp; Themes &amp; Apps\" target=\"_blank\" rel=\"noopener\">app<\/a>lications as normal, but you won\u2019t have to worry much about updates, scalability, or availability.<\/p>\n<p>Pricing for Cloud SQL is simple, you pay a <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/cloud.google.com\/sql\/pricing\">flat fee per vCPU and GB of memory<\/a>. Of course, it\u2019s going to be more than Compute Engine\u2019s base pricing, so it\u2019s still cheaper to configure MySQL or Postgres on your own server. But, for many businesses, the benefits of having everything managed for you (including much less stress on your DBAs) will greatly outweigh the price increase.<\/p>\n<p>If you\u2019re using your resources consistently throughout a month, you will qualify for the <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/cloud.google.com\/compute\/docs\/sustained-use-discounts\">Sustained Use Discount<\/a>, which will lower the price significantly. Of course, this is also available on regular Compute Engine, but it\u2019s worth keeping in mind when running the numbers.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cloud_Spanner\"><\/span>Cloud Spanner<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-4528 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/8db2639983930d88ac3ee1812aa448ef\/p\/uploads\/2020\/04\/1ec22e32.png\" alt=\"Cloud Spanner \" width=\"700\" height=\"285\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Cloud Spanner is also a managed SQL database, but it\u2019s built for a different purpose.<\/p>\n<p>Traditional SQL databases, like MySQL, have a common problem: They\u2019re only vertically scalable. If your database needs more performance, the best option is to upgrade the underlying instance. This is an issue that most NoSQL databases solve by design.<\/p>\n<p>With Cloud Spanner, Google has found the best of both worlds, and made a relational SQL-compatible database that can scale horizontally, easily managing global replication and consistency. Databases running on Cloud Spanner will be shared across multiple regions, with all writes synced up automatically. If you\u2019re curious about how this works under the hood, you can read <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/thedataguy.in\/internals-of-google-cloud-spanner\/\">this write-up by The Data Guy<\/a>.<\/p>\n<p>If you\u2019re set on a SQL database and want the absolute best solution possible, Cloud Spanner is your go-to option. <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/cloud.google.com\/blog\/products\/gcp\/introducing-cloud-spanner-a-global-database-service-for-mission-critical-applications\">Google uses it internally<\/a>, and has battle-tested it with petabytes of data spread all around the world.<\/p>\n<p>Of course, with features this fancy and maximum performance, <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/cloud.google.com\/spanner\/pricing\">it\u2019s not cheap.<\/a>\u00a0You\u2019re charged hourly for each \u201cnode\u201d in the network, each of which provide up to 2 TB of storage and\u00a010,000\/2,000 read\/write queries per second. Nodes start at\u00a0$0.90\u00a0<em>hourly<\/em> for <code>us-east1<\/code>, so even with only one of them you\u2019re looking at a monthly bill over $700. If you don\u2019t care about running a global network of databases, stick to Cloud SQL.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"FirebaseFirestore\"><\/span>Firebase\/Firestore<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-4530 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/ec17a185d699fb2afa8b1b65fa66ba04\/p\/uploads\/2020\/04\/fb6296b9.png\" alt=\"Firebase\" width=\"700\" height=\"290\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Firebase is built to be an easy-to-use managed backend for your applications, with a particular focus on mobile applications. Firebase as a whole is an entire app development platform, with numerous useful features like authentication, analytics, performance and crash monitoring, and managed storage.<\/p>\n<p>At its heart, though, is the <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/firebase.google.com\/products\/realtime-database\/\">Firebase Realtime Database<\/a>, a NoSQL document database that\u2019s built to enable real-time updates to clients subscribed over WebSockets. Real-time syncing of updates to database data makes collaboration between users easy, allowing for applications like Google Docs.\u00a0<a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/firebase.google.com\/docs\/firestore\">Firestore<\/a> is a similar feature, used for storing large objects like uploaded photos and videos in conjunction with the Realtime Database.<\/p>\n<p>It\u2019s entirely serverless, so you won\u2019t have to worry at all about database administration or creating instances. As far as pricing goes, it has a <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/firebase.google.com\/pricing\">generous free tier<\/a> for small projects and development. After that, it\u2019s pay as you go. You can use <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/firebase.google.com\/pricing#blaze-calculator\">their calculator<\/a> to estimate how much it will cost you.<\/p>\n<p>If you want to learn more about Firebase, you can read our guide on getting started with it.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Memorystore\"><\/span>Memorystore<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"imgchk9 alignnone wp-image-4531 size-full\" src=\"https:\/\/www.cloudsavvyit.com\/thumbcache\/0\/0\/812e3c07c01e40fff9b321db0d593b0b\/p\/uploads\/2020\/04\/d13b1b30.png\" alt=\"Redis logo\" width=\"641\" height=\"223\" onload=\"pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\" onerror=\"this.onerror=null;pagespeed.lazyLoadImages.loadIfVisibleAndMaybeBeacon(this);\"\/><\/p>\n<p>Redis and Memcached are in-memory databases, commonly used for storing small bits of data with high throughput and very low latency. Most databases will use memory as cache, but with Redis,\u00a0<em>everything<\/em> is stored in RAM.<\/p>\n<p>Memorystore is simply Google\u2019s managed Redis and Memcached service, similar to Cloud SQL.<\/p>\n<p>Pricing <a rel=\"nofollow noopener noreferrer\" target=\"_blank\" href=\"https:\/\/cloud.google.com\/memorystore\/pricing\">varies, depending on how much data you\u2019re storing<\/a>. For small deployments under 4GB, you\u2019ll be paying\u00a0$0.049 per GB, per hour. The hourly cost decreases for higher memory deployments.\n<\/div>\n<blockquote>\n<p style=\"text-align: center;\">For forums sites go to <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/forum.buradabiliyorum.com\/\" target=\"_blank\" rel=\"noopener noreferrer\">Forum.BuradaBiliyorum.Com<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<blockquote>\n<p style=\"text-align: center;\"><strong>If you want to read more like this article, you can visit our <span style=\"color: #ff9900;\"><a style=\"color: #ff9900;\" href=\"https:\/\/en.buradabiliyorum.com\/technology\/\" target=\"_blank\" rel=\"noopener noreferrer\">Technology category.<\/a><\/span><\/strong><\/p>\n<\/blockquote>\n<p><span style=\"color: black;\"><a style=\"color: #ff9900;\" href=\"https:\/\/www.cloudsavvyit.com\/4526\/the-best-solutions-for-running-a-database-on-google-cloud-platform\/\" target=\"_blank\" rel=\"noopener noreferrer\">Source<\/a><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>&#8220;#The Best Solutions for Running a Database on Google Cloud Platform \u2013 CloudSavvy IT&#8221; Google\u2019s Cloud Platform offers many solutions for modernizing your existing database infrastructure. By moving to the cloud, and taking advantage of Google\u2019s PaaS offerings, you can reduce the headache of database administration. Cloud SQL Cloud SQL is Google\u2019s alternative to AWS\u2019s&#8230;<\/p>\n","protected":false},"author":1,"featured_media":77024,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"fifu_image_url":"https:\/\/www.cloudsavvyit.com\/p\/uploads\/2020\/04\/469724f6.png","fifu_image_alt":"","footnotes":""},"categories":[18],"tags":[],"class_list":["post-77023","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-technology"],"_links":{"self":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/77023","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/comments?post=77023"}],"version-history":[{"count":0,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/posts\/77023\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media\/77024"}],"wp:attachment":[{"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/media?parent=77023"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/categories?post=77023"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/buradabiliyorum.com\/en\/wp-json\/wp\/v2\/tags?post=77023"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}