Centizen, Inc.’s Post

#AWS closed the #serverless data gap this week with the preview release of Aurora DSQL. I'm of the mind that we went too far with NoSQL when running serverless compute. It often was the more preferable but not most desirable option. I took #DSQL for a spin with #Rust and #Lambda and checked out the developer experience in addition to some early performance. I'm overall impressed but believe there is still room for improvement which I'm confident AWS will deliver on. My Belief in Serverless stems from the real world solutions that I've delivered and seen delivered with it. This addition of Serverless SQL from AWS will unlock new architectures and use cases. It will also allow current systems that are saddled with over provisioning and more complex infrastructure to be migrated if the developers so choose. Would love to hear your feedback on the article.

💡 Modern apps demand performance, security, availability, and resilience—and MongoDB 8.0 delivers! And it is always nice to read stuff not coming from our own team :-). In Matt Aslett’s latest write-up, he breaks down how MongoDB’s Database and Developer Data Platform is evolving with over 45 new features and architectural enhancements. From optimising performance to supporting cutting-edge technologies like generative #AI, this release takes innovation to the next level. Dive into the details: https://lnkd.in/eBpfTZ54 With MongoDB 8.0, we're unlocking faster queries, more efficient replication, and scalable solutions for the most demanding workloads. This is how we’re empowering developers and businesses! Super cool to see @ISG spotlighting this milestone for the data-driven future! 🚀 #Data #MongoDB #Database #Innovation

Kick off with the #AzureCosmosDB for #NoSQL Node.js library! Query data, handle items, and deploy quickly with the Azure Developer CLI. Just follow these easy steps. 🚀 https://lnkd.in/edthwZSC

Insightful piece from Marc Brooker on Aurora DSQL, which was launched at re:invent yesterday. DSQL stands for “distributed sql”. The idea was to build a new database with SQL and ACID, global active-active, scalability both up and down (with independent scaling of compute, reads, writes, and storage), and PostgreSQL compatibility (psql works with Aurora DSQL). To get there, a few key design choices have been made, firstly by thinking carefully about cross-region behaviours: "Latency scales with the number of statements in a transaction. For cross-region active-active, latency is all about round-trip times. Even if you’re 20ms away from the quorum of regions, making a round trip (such as to a lock server) on every statement really hurts latency. In Aurora DSQL, you only incur additional cross-region latency on COMMIT, not for each individual SELECT, UPDATE, or INSERT in your transaction (from any of the endpoints in an active-active setup). That’s important, because even in the relatively simple world of OLTP, having 10s or even 100s of statements in a transaction is common. It’s only when you COMMIT (and then only when you COMMIT a read-write transaction) that you incur cross-region latency. Read-only transactions, and read-only autocommit SELECTs are always in-region and fast (and strongly consistent and isolated)." And then secondly by making a distinction about consistency within region versus cross region: "We’ve found that application programmers find dealing with eventual consistency difficult, and exposing eventual consistency by default leads to application bugs. Eventual consistency absolutely does have its place in distributed systems8, but strong consistency is a good default. We’ve designed DSQL for strongly consistent in-region (and in-AZ) reads, giving many applications strong consistency with few trade-offs." Snapshot isolation is also used by default. Snapshot isolation is a concurrency control mechanism that means each transaction can operate on a “consistent snapshot” of the database taken at the point the transaction starts. This means you’re isolated from changes made by other transactions so you have a consistent view of the data: "We believe that snapshot isolation is, in distributed databases, a sweet spot that offers both a high level of isolation and few performance surprises. Again, our goal here is to simplify the lives of operators and application programmers. Higher isolation levels push a lot of performance tuning complexity onto the application programmer, and lower levels tend to be hard to reason about." The piece is great end to end, so well worth a read. The footnotes are also brilliant - a tonne of useful links to papers with underlying theory.

Just discovered Aurora DSQL—AWS's new serverless, PostgreSQL-compatible database—and I’m intrigued! Think Aurora Serverless meets DynamoDB but with better querying (joins, CTEs, etc.) and active-active cross-regional writes. It’s fully serverless: scales to zero, no maintenance, and fault-tolerant. Some Postgres features aren’t yet supported (no JSON, extensions, or SERIAL), but this feels like what Aurora Serverless should have been. Looking forward to its GA release! #AWS #Aurora #AuroraDSQL #PostgreSQL

🎉 Thrilled for the GA launch of Aurora Limitless! https://lnkd.in/gSS-gzHS Aurora Limitless brings the flexibility of a horizontally scalable PostgreSQL-compatible database, meaning it can scale out computing and storage resources on top of the existing vertical scaling Limitless V2 already provides. Built for large-scale applications, this architecture empowers businesses to achieve high performance loads with the benefits of a relational database. Over the past two years, I’ve focused on developing comprehensive monitoring and diagnostics tools for our customers, including distributed database statistics views and integration with our Performance Insights and Enhanced Monitoring features. I also worked on availability monitoring and disaster recovery to ensure this solution meets the high availability standards customers expect from AWS. Leveraging the power of AWS Aurora, Aurora Limitless combines enterprise-level scalability with the efficiency of cloud-native architecture, making it a robust choice for any data-driven organization looking to grow. Big thanks to my team for their dedication and collaboration. Proud of what we’ve built, and excited to see Aurora Limitless finally on the hands of our customers! #AuroraLimitless #PostgreSQL #AWS #Scalability #CloudInnovation

I usually only talk about Postgres or Cassandra but over the years I have found myself surrounded at times by folks doing some things with Mongo that were impressive. If your a Mongo user this might be of interest to you https://lnkd.in/ehTMEVUb the concepts can apply to any database and in general I expect more AI like this being built, talked about and open sourced.

This blog will show you how to easily set up #CDC from your AWS #DynamoDB database to SingleStore using DynamoDB streams and a #Lambda function. https://lnkd.in/e6EyNTN5

https://zurl.co/Ruc7 Optimizing MongoDB Checkpointing for Performance #MongoDB #DBA #DBATips #MongoDBTricks #MongoDBPerformance

https://zurl.co/Ruc7 Optimizing MongoDB Checkpointing for Performance #MongoDB #DBA #DBATips #MongoDBTricks #MongoDBPerformance