{"id":14238,"date":"2015-05-08T10:42:21","date_gmt":"2015-05-08T10:42:21","guid":{"rendered":"http:\/\/www.businesscloudnews.com\/?p=224561"},"modified":"2015-05-08T10:42:21","modified_gmt":"2015-05-08T10:42:21","slug":"google-adds-crate-to-sql-services-on-gce","status":"publish","type":"post","link":"https:\/\/icloud.pe\/blog\/google-adds-crate-to-sql-services-on-gce\/","title":{"rendered":"Google adds Crate to SQL services on GCE"},"content":{"rendered":"<div id=\"attachment_148022\" class=\"wp-caption alignright\" style=\"width: 310px\"><a href=\"http:\/\/www.businesscloudnews.com\/wp-content\/blogs.dir\/122\/files\/2013\/07\/Google-office.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-148022\" alt=\"Google has been on a big data push\" src=\"http:\/\/www.businesscloudnews.com\/wp-content\/blogs.dir\/122\/files\/2013\/07\/Google-office.jpg\" width=\"300\" height=\"225\" \/><\/a><\/p>\n<p class=\"wp-caption-text\">Google has been on a big data push<\/p>\n<\/div>\n<p>Google has added open source distributed SQL data store Crate to the Google Compute Engine arsenal, the latest in a series of moves aimed at bolstering the company\u2019s data services.<\/p>\n<p>Crate is a distributed open source data store built on a high availability \u201cshared-nothing\u201d architecture that automatically shards and distributes data across all of nodes (and maintains several replicas for fault tolerance).<\/p>\n<p>It uses SQL syntax but packs some NoSQL goodies as well (Elasticsearch, Presto, Lucene are among the components it implements).<\/p>\n<p>\u201cThis means when a new node is added, the cluster automatically rebalances and can self-heal when a node is removed. All data is indexed, optimized, and compressed on ingest and is accessible using familiar SQL syntax through a RESTful API,\u201d <a href=\"http:\/\/googlecloudplatform.blogspot.co.uk\/2015\/05\/Distributed-SQL-database-Crate-now-available-as-Click-to-Deploy-for-Google-Compute-Engine.html\">explained<\/a> Tyler Randles, evangelist at Crate.<\/p>\n<p>\u201cCrate was built so developers won\u2019t need to \u201cglue\u201d several technologies together to store documents or BLOBs, or support real-time search. It also helps dev-ops by eliminating the need for manual tuning, sharding, replication, and other operations required to keep a large data store in good health.\u201d<\/p>\n<p>The move is yet another attempt by Google to bolster its data services. Earlier this week <a href=\"http:\/\/www.businesscloudnews.com\/2015\/05\/06\/google-reveals-bigtable-a-nosql-service-based-on-what-it-uses-internally\/\">the company revealed Bigtable<\/a>, a fully managed NoSQL database service the company said combines its own internal database technology with open source Apache HBase APIs.<\/p>\n<p>Last month <a href=\"http:\/\/www.businesscloudnews.com\/2015\/04\/17\/google-boosts-cloud-based-big-data-services\/\">the company announced<\/a> the beta launch of Google Cloud Dataflow, a Java-based service that lets users build, deploy and run data processing pipelines for other applications like ETL, analytics, real-time computation, and process orchestration, while abstracting away all the other infrastructure bits like cluster management.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Google has added open source distributed SQL data store Crate to the Google Compute Engine arsenal, the latest in a series of moves aimed at bolstering the company&rsquo;s data services.<\/p>\n","protected":false},"author":105,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[156,2513,344,1976,2514],"tags":[],"class_list":["post-14238","post","type-post","status-publish","format-standard","hentry","category-big-data","category-crate","category-google","category-news-analysis","category-tyler-randles"],"_links":{"self":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/14238","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/users\/105"}],"replies":[{"embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/comments?post=14238"}],"version-history":[{"count":1,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/14238\/revisions"}],"predecessor-version":[{"id":14239,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/posts\/14238\/revisions\/14239"}],"wp:attachment":[{"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/media?parent=14238"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/categories?post=14238"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/icloud.pe\/blog\/wp-json\/wp\/v2\/tags?post=14238"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}