InfoQ Homepage MySQL Content on InfoQ
-
How GitHub Partitioned Its Relational Database to Improve Reliability at Scale
GitHub has been working for the last couple of years on partitioning their relational database and moving the data to multiple independent clusters. This effort led to a 50% load reduction and a significant reduction of database-related incidents, explains GitHub engineer Thomas Maurer.
-
Email Classification at Slack: Designing an Eventually Consistent Custom Classifier
Slack recently published the details of how it built an email address classification engine that can determine if an email address is internal or external. Slack engineers utilized an eventually consistent near real-time representation of the data in its system and implemented a drift detection mechanism to fix erroneous data, keeping the engine's operation in order.
-
Oracle Introduces MySQL Autopilot with Machine-Learning Capabilities for MySQL Heatwave
Oracle released updates to its MySQL HeatWave service earlier this month. The new MySQL Autopilot feature uses machine learning to automate database provisioning and optimisation tasks, making recommendations and query optimisations based on each database’s usage patterns.
-
AWS Introduces Preview of Aurora Serverless v2
During the first keynote of re:Invent 2020, AWS announced the next version of Amazon Aurora Serverless in preview. The new serverless version for the MySQL 5.7-compatible edition of Amazon Aurora scales in fraction of a second and introduces multi-AZ support, global databases, and read replicas.
-
Google Launches a New Serverless Database Migration Service
Recently, Google announced a new serverless Database Migrates Service (DMS) in preview. The service supports migrations of self-hosted MySQL databases, either on-premises or in the cloud, and managed databases from other clouds, to Cloud SQL for MySQL.
-
Oracle Introduces the MySQL Database Service on Its Cloud Infrastructure
In a recent blog post, Oracle introduced the MySQL Database Service in the Oracle Cloud Infrastructure (OCI). The service is now available as a fully-managed service running on Oracle Generation 2 Cloud Infrastructure.
-
Google Cloud SQL Supports MySQL 8.0
Google Cloud has recently made MySQL 8.0 available on Cloud SQL, the managed relational database service for MySQL, PostgreSQL, and SQL Server.
-
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.