InfoQ Homepage MySQL Content on InfoQ
-
GitHub Was down Multiple Times Last February: Here's Why
GitHub completed its internal investigation about what caused multiple service interruptions that affected its service last February for over eight hours. The root cause for this was a combination of unexpected database load variation and database configuration issues.
-
Amazon Announces General Availability of Aurora Multi-Master
In a recent announcement, Amazon has publicized the general availability of Aurora Multi-Master, which allows for reading and writing on multiple database instances across several Availability Zones. Consequently, this brings high availability capabilities, as the platform no longer needs to trigger a fail-over upon failure of database instances.
-
DigitalOcean Adds Managed MySQL and Redis Services
Cloud provider DigitalOcean recently released a pair of new managed data services. Their Managed MySQL and Redis offerings are on-demand and elastic, and offer a variety of sizes and high-availablity options.
-
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.
-
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.
-
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.
-
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.
-
Amazon Adds Cross Region and Encrypted Replication Support for Aurora
In a recent blog post, Amazon announced updates to its MySQL-compatible Database Engine, Aurora. In this update, Amazon is including support for cross region snapshot copy, cross region replication for encrypted databases, cross account encrypted snapshot sharing, adding a region where Aurora can be provisioned and a new instance size called T2.Small.
-
Yelp Open-Sources Latest in Data Pipeline Project, Data Pipeline Client Library
Yelp open sources latest component in its data pipeline initiative, a python-based data pipeline client library.