InfoQ Homepage SQL Content on InfoQ
-
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.
-
Azure SQL Intelligences Aims to Help DBAs and Developers
Microsoft seeks to make database management easier for users of its Azure SQL service and SQL Server through the addition of new features it calls Performance Management Intelligence. They are designed to provide easier database management for both DBAs and app developers.
-
Bringing a DevOps Approach to Databases
Today at Day 1 of PASS Summit 2017, Redgate Evangelist Steve Jones presented his tips for taking a DevOps approach to database management. His approach includes tips that can benefit installations of all sizes.
-
LinkedIn Develops MySQL Query Analyzer Tool
In order to optimise the performance of their MySQL instances, LinkedIn has created a Query Analyzer tool in order to analyze and tune expensive queries. It runs on the network layer, stores everything within a centralized server, and provides a UI for users to analyze metrics.
-
SQL Server 2017 RC1 Arrives with Expanded Linux Functionality
After seven preview releases, Microsoft has announced the release of the first Release Candidate for SQL Server 2017. Those running SQL Server on Linux will find several new capabilities. Foremost among these is TLS support and Active Directory Authentication.