InfoQ Homepage Database Design Content on InfoQ
-
Amazon Aurora DSQL: Distributed SQL Database with Active-Active High Availability
At the recent AWS re:Invent conference in Las Vegas, Amazon announced the public preview of Aurora DSQL, a serverless, distributed SQL database featuring active-active high availability. This new PostgreSQL-compatible database option has generated significant excitement within the AWS community and was widely regarded by attendees as the standout announcement of the conference.
-
Automated Horizontal Scaling with Amazon Aurora Limitless Database
AWS recently announced the preview of Amazon Aurora Limitless Database, a new capability supporting automated horizontal scaling to process millions of write transactions per second and manage petabytes of data in a single Aurora database.
-
Discord Migrates Trillions of Messages from Cassandra to ScyllaDB
Discord has migrated trillions of message records from Apache Cassandra to ScyllaDB, reducing the size of the largest cluster from 177 Cassandra nodes to 72 ScyllaDB nodes and reducing tail latencies for reads and writes. The move has unlocked new product use cases because of the improved database stability and performance.
-
AWS Announces GA of DocumentDB Elastic Clusters
At the recent re:Invent conference, AWS announced the general availability of DocumentDB Elastic Clusters, a service that manages the elasticity and sharding for MongoDB workloads.
-
ZippyDB: the Architecture of Facebook’s Strongly Consistent Key-Value Store
Facebook Engineering recently published how it built its general-purpose key-value store, known as ZippyDB. ZippyDB is Facebook's biggest key-value store, which has been in production for more than six years. It offers flexibility to applications in terms of tunable durability, consistency, availability, and latency guarantees.
-
Pinterest Describes an Architecture for Efficient Retrieval of Hierarchical Documents
In a recent blog post, Pinterest engineers describe how they implemented an efficient two-stage retrieval architecture to retrieve hierarchical documents in a home-grown search engine. They accomplished it by combining index flattening, index normalization, and index denormalization.
-
KubeCon 2018: The Return of SQL
Like many conferences, KubeCon 2018 has a variety of distributed database vendors. But what is unusual this year is every single one of them InfoQ talked to emphasized their support for SQL
-
Amazon Announces Managed Databases for Amazon Lightsail
Amazon has announced managed databases for Lightsail, their lightweight and simplified virtual private server offering. The addition of managed databases intends to allow the creation of these databases on the Lightsail platform with a minimal amount of work, and removes several everyday maintenance tasks from the user.
-
MySQL Version 8 Adds Document Store, Performance and Security Improvements
Oracle has released version 8 of their open-source relational database management system MySQL, introducing many improvements document based storage, performance and security enhancements, and a change in default character-set to promote "mobile-first" development.
-
Microsoft Directly Challenges MongoDB and Cassandra with Cosmos DB
The term “Embrace, Extend, and Extinguish” is often thrown about whenever someone is upset with Microsoft. Superficially it describes any attempt by a technology company to attract users of a competitor’s product, but the actual strategy is more complicated than that. In this report will use Azure Cosmos DB to illustrate the concept.
-
Preview of New Features in MySQL 8
MySQL is gearing up for its 8th version, expected to be released in 2018. A full 28 months since the first general release for MySQL 5.7.9, there have already been five release candidates for MySQL 8, ranging from 8.0.0 to 8.0.4. In this article we explore the best features that MySQL 8 will bring to developers when it gets a GA release.
-
MongoDB 4.0 to Include Multi-Document Transactions
Since MongoDB acquired WiredTiger and their relational database storage engine, technologists have been speculating on when MongoDB would support multi-document transactions. With this week’s announcement, the expectation is that they’ll be ready this summer as part of MongoDB 4.0.
-
Google Cloud Platform Recommends Strong Consistency in Data Stores
A recent post on the Google Cloud Platform blog recommends strong consistency in the data layer, which helps in creating an application platform that reduces complexity and the potential for bugs.
-
Uber Engineering Moving from Postgres to MySQL
In a recent blog post, Uber detailed why they have chosen to replace PostgreSQL with MySQL. In this article we present a high level overview of the problems they faced, how MySQL fares against them and some of the best rebuttals against the case presented by Uber.
-
Riak NoSQL Database: Use Cases and Best Practices
Riak is a key-value based NoSQL database that can be used to store user session related data. Andy Gross from Basho Technologies recently spoke at QCon SF 2011 Conference about Riak use cases. InfoQ spoke with Andy and Mark Phillips from Basho team about Riak database features and best practices when using Riak.