InfoQ Homepage SQL Content on InfoQ
-
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.
-
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.
-
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.
-
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.
-
Amazon Aurora Serverless MySQL Generally Available
Amazon Aurora, a custom built MySQL and PostgreSQL compatible database in AWS, has a new capability generally available – Aurora Serverless MySQL. Amazon first showed a preview of this serverless ability at AWS re:Invent last year.
-
GitHub Engineering Adopts New Architecture for MySQL High Availability
Github.com uses MySQL as a backbone for many of its critical services like the API, authentication and the Github.com website itself. Github’s engineering team replaced its previous DNS and VIP based setup with one based on Orchestrator, Consul and the Github Load Balancer to get around split brain and DNS caching issues.
-
Studio 3T: SQL Exploration for MongoDB
Studio 3T offers an SQL-based user interface for MongoDB. This includes in-place data editing, query performance information, and a SQL to code converter for JavaScript (node.JS), Java, Python, and C#.
-
Amazon Aurora Adds "Backtrack" Feature to Enable Rewinding a DB Cluster to a Specific Point in Time
Amazon Aurora, a managed MySQL and PostgreSQL compatible relational database in AWS, receives a new backtrack feature. By using this backtrack feature, developers can undo their mistakes like dropping the wrong table.
-
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 Announces General Availability of Azure Database Services for MySQL and PostgreSQL
Microsoft has announced the general availability of Azure Database for MySQL and Azure Database for PostgreSQL. Both these open-source database engines are now brought in their community version as a managed service, with 99.99% SLA, elastic scaling for performance, and industry-leading security and compliance to Azure.
-
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.
-
Microsoft Previews Cross Platform Tool for Working with SQL Server
Microsoft has released a public preview of SQL Operations Studio, a cross platform tool for working with SQL Server. This product is based on the existing Visual Studio Code editor and uses the SQL Tools API service under the hood.