InfoQ Homepage Relational Databases Content on InfoQ
-
Enabling Single Tenant Workloads in the Cloud, Microsoft Introduces Azure Dedicated Host
In a recent blog post, Microsoft announced Azure Dedicated Hosts, a service that allows organizations to run Linux and Windows virtual machines on single-tenant physical servers. This service was introduced to address customer compliance and regulatory requirements. Organizations can also take advantage of Azure Hybrid Benefits which allows them to leverage existing software investments.
-
Amazon Releases Aurora PostgreSQL Serverless to General Availability
Recently, Amazon announced the general availability of the PostgreSQL-compatible edition of Aurora Serverless.
-
Timescale Cloud: Managed Time Series Database on Azure, Google Cloud and AWS
Timescale announced the availability of Timescale Cloud, a fully managed version of their time series database on Azure, GCP, and AWS. It provides time series analysis functions, the ability to scale up and down, visualization integration with tools like Grafana and Tableau, and data encryption.
-
Microsoft Brings SQL to the Edge, Announces Azure SQL Database Edge
At the recent Build conference, Microsoft announced a new database offering, which brings SQL Server capabilities to edge computing. Officially called Azure SQL Database Edge, the service runs on ARM64 and x64 processors and provides capabilities such as data streaming, time series data, graph support and in-database machine learning. The supported platforms include Linux and Windows.
-
Google Announces Several Updates to Database Services
Google has announced several new products and features for the database services on Google Cloud Platform. These announcements include Cloud SQL for Microsoft SQL Server, version 11 support for Cloud SQL for PostgreSQL and multi-region replication for Cloud Bigtable.
-
FoundationDB's Record Layer Supports Relational Database Semantics, Schema Management and Indexing
FoundationDB NoSQL database's new Record Layer supports relational database semantics, schema management, primary and secondary indexes, and query capabilities. The FoundationDB team announced last month the open source release of the Record Layer.
-
Highly Available MySQL Clustering at WePay Using Orchestrator, Consul and HAProxy
WePay’s engineering team talks about their new highly available MySQL cluster built with HAProxy, Consul and Orchestrator. It improves upon their previous architecture by reducing any downtime from 30 minutes to 40-60 seconds.
-
SQL Server and .NET Core 3.0
In our last article we looked at System.Data in .NET Core 3.0. Now we turn our attention to System.Data.SqlClient, which is the SQL Server driver.
-
The Guardian’s Migration from MongoDB to PostgreSQL on Amazon RDS
The Guardian migrated their CMS’s datastore in 2018 from a self-managed MongoDB cluster to PostgreSQL on Amazon RDS for a fully managed solution. The team did an API-based migration without any downtime.
-
SQL Server 2019 Fixes Function Inlining Bug
Like most databases created in the last couple of decades, SQL Server allows developers to extend the database by creating functions. But prior to the upcoming 2019 release, SQL Server’s support for scalar functions was fraught with problems that caused them to run over a thousand times slower.
-
Google Updates Cloud Spanner: Query Introspection, New Regions, and New Multi-Region Configurations
In a recent blog post, Google announced a few enhancements for Cloud Spanner - a globally distributed NewSQL database. Based on customer requests, Google updated the service with query introspection improvements, new region availability, and new multi-region configurations.
-
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
-
Building Resilience in Netflix Production Data Migrations: Sangeeta Handa at QCon SF
At QCon SF, Sangeeta Handa discussed how Netflix had learned to build resilience into production migrations across a number of use cases. Key lessons learned included: aim for perceived or actual zero downtime, even for data migrations; invest in early feedback loops to build confidence; find ways to decouple customer interactions from your services; and build independent checks and balances.
-
GitHub Incident Analysis Shows How to Improve Service Reliability
On October 21, 2018, GitHub users experienced a degraded service during 24 hours due to an incident caused by routine maintenance work. This led to the display of outdated and inconsistent information and to the unavailability of webhooks and other internal services for 24 hours. GitHub post-incident report shows where things failed and suggests how to improve site reliability.
-
High Volume Space Exploration Time-Series Data Storage in PostgreSQL
The European Space Agency Science Data Center (ESDC) switched to PostgreSQL with the TimescaleDB extension for their data storage. ESDC’s diverse data includes structured, unstructured and time series metrics running to hundred of terabytes, and querying requirements across datasets with open source tools.