![]() ![]() It also means Cosmos DB is gradually becoming Azure’s unified hyperscale database platform. ![]() It means that Cosmos DB for PostgreSQL will now be the Citus distributed Postgres option. ![]() In fact, Microsoft told me that “all customers and workloads will automatically move to Azure Cosmos DB for PostgreSQL.” That’s a big deal. Cosmos DB for PostgreSQL will replace Azure Database for PostgreSQL - Hyperscale. There’s one more piece to this story that’s very interesting. But Kumar said, “we are working on further enhancing and adding more and more capabilities.” He also told me Cosmos for Postgres users will get the same service level agreements (SLAs) that are extended to all Cosmos DB customers. While Kumar said “today we basically support globally distributed read semantics,” there are some other customary Cosmos features that Cosmos DB for Postgres won’t get, at least initially. full query consistency, and not the “eventual consistency” model supported in many NoSQL platforms, nor even the sliding scale consistency offered within the other Cosmos DB interfaces. The use of the Citus engine also means full support for Postgres’ SQL dialect and, given the relational nature of the database, full ACID compliance - i.e. Kumar said PostGIS will indeed be supported, as will several others, prioritized based “on their usage.” I asked about one in particular - PostGIS, a very popular geospatial database extension for Postgres. Of course, since Cosmos DB is a managed platform, the extensions actually made available will be the ones Microsoft chooses. That also means compatibility with the broad array of Postgres extensions will be present as well. That was important because, you know, if you take the Postgres engine and you change it up completely then, well, it’s not Postgres anymore.” Kumar added: “We really liked their approach of using the extensibility model of Postgres to maintain compat while enabling… a database that underneath the covers was sharded.” (Sharding is a foundational technique in scaling out and partitioning databases across multiple servers.) Kumar went on to explain that what attracted Microsoft to Citus was that “they were not really giving up on compatibility with Postgres. First off, according to Kumar, this is “actually the Postgres engine” and not merely a compatibility layer. There are some ramifications here that are important to take stock of. Maybe that’s why it’s called Cosmos DB for PostgreSQL, and not the other way around. All of those options essentially present different language/wire protocol/API combinations around the same core technology, while the Postgres option offers a completely different query engine. That makes the Cosmos/Postgres offering unlike any of the Cosmos API options, be it Core SQL, Azure Table storage for key-value access, MongoDB for document store applications, Gremlin for graph database workloads, or Cassandra for wide column store implementations. “We… have taken the distributed query processing engine of Citus… and effectively have that overlaid on top of Cosmos DB,” Kumar said. To cut to the chase: Kumar explained Azure Cosmos DB for PostgreSQL (a Microsoft product name if ever there were one) is a mashup of sorts, with Cosmos DB laying the infrastructural foundation and Microsoft’s distributed PostgreSQL engine, obtained when it acquired Citus Data in 2019, on top. TNS spoke with Rohan Kumar, Microsoft’s Corporate Vice President, Azure Data, about the announcement and got some interesting architectural details. 18, with content on strategy, concepts and how-to, for the new Postgres offering. For folks who want to drill down even further, the Cosmos DB team told me it’s hosting a two-hour online event on Oct. I’ll cover the news in some technical depth here. Microsoft says it also makes Azure the first cloud platform to support both relational and NoSQL options on the same service. While Cosmos already supported a number of interfaces and APIs for NoSQL database technologies, this announcement marks the first time a true relational database solution is being offered on the platform. At its Ignite conference in Seattle today, Microsoft CEO Satya Nadella announced new PostgreSQL support for Azure Cosmos DB. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |