InfoQ Homepage MySQL Content on InfoQ
-
Uber Achieves Significant Storage Savings with MyRocks Differential Backups
Uber has written about successfully implementing a new differential backup system for its distributed databases, which led to storage cost reductions of up to 70%. Uber engineers developed this solution in response to growing storage costs and lengthy backup completion times that emerged after Uber migrated storage services to MyRocks, a MySQL storage engine based on RocksDB.
-
Amazon Aurora Introduces Global Database Writer Endpoint for Distributed Applications
Amazon Aurora has recently introduced a Global Database writer endpoint to streamline routing for applications in disaster-recovery scenarios. This highly available global endpoint removes the need for application code changes to reestablish connectivity following a cross-region switchover or failover operation.
-
Uber Completes Major MySQL Fleet Upgrade, Boosting Performance and Security
Uber has detailed improvements to its MySQL database fleet by upgrading from version 5.7 to 8.0. The team wanted to take advantage of performance and concurrency improvements in newer versions of MySQL, and because MySQL 5.7 was reaching end-of-life in October 2023. The work took over a year and involved upgrading more than 2,100 clusters and 16,000 nodes across 19 production zones in 3 regions.
-
Amazon RDS for MySQL Zero-ETL Integration with Amazon Redshift
Amazon RDS for MySQL's zero-ETL integration with Amazon Redshift is now generally available, enabling near real-time analytics and machine learning on transactional data. This powerful feature allows customized data replication from a single RDS database and facilitates seamless scalability, ensuring businesses gain insights while controlling costs and maintaining data freshness.
-
Security Experts Exploit Airport Security Loophole with SQL Injection
In the article "Bypassing airport security via SQL injection," two security researchers recently demonstrated how they executed a simple SQL injection attack on a service that enables pilots and flight attendants to bypass airport security screening.
-
How Amazon Aurora Serverless Manages Resources and Scaling for Fleets of 10K+ Instances
AWS engineers published a paper describing the evolution and latest design of resource management and scaling for the Amazon Aurora Serverless platform. Aurora Serverless uses a combination of components at different levels to create a holistic approach for dynamically scaling and adjusting resources to satisfy the needs of customer workloads.
-
MariaDB Introduces Open-Source Vector Preview, Aiming to Become Default MySQL Option
With the release of MariaDB 11.6, the MariaDB Foundation has announced the public preview of Vector search for the open-source fork of the MySQL engine. Database experts and open-source advocates see vector support as an opportunity for MariaDB to lead the MySQL ecosystem, especially since Oracle reserves most new features for its enterprise editions only.
-
MySQL 9.0 Innovation Release Now Available
On July 1st, Oracle announced the release of MySQL 8.0.38, the initial update for the 8.4 Long Term Support (LTS) series, and the inaugural MySQL 9.0 release. The Innovation release introduces new features, such as vector and JavaScript support. In contrast, the two LTS releases focus on stability, providing security updates, bug fixes, and performance improvements.
-
Google Provides Extended Support for Cloud SQL MySQL and PostgreSQL End-of-Life Versions
Google Cloud has announced extended support for end-of-life Cloud SQL MySQL and PostgreSQL versions to help users maintain database operations and plan upgrades more efficiently. Starting February 1, 2025, versions such as MySQL 5.6, 5.7 and PostgreSQL 9.6 to 12 will enter an extended support phase, allowing customers to continue using these versions beyond their standard support dates.
-
QCon London: Lessons Learned from Building LinkedIn’s AI/ML Data Platform
At the QCon London 2024 conference, Félix GV from LinkedIn discussed the AI/ML platform powering the company’s products. He specifically delved into Venice DB, the NoSQL data store used for feature persistence. The presenter shared the lessons learned from evolving and operating the platform, including cluster management and library versioning.
-
QCon London: Meta Used Monolithic Architecture to Ship Threads in Only Five Months
Zahan Malkani talked during QCon London 2024 about Meta’s journey from identifying the opportunity in the market to shipping the Threads application only five months later. The company leveraged Instagram's existing monolithic architecture and quickly iterated to create a new text-first microblogging service in record time.
-
Vitess Version 19 Released: Ends Support for MySQL 5.7, Improves MySQL Compatibility
Recently, Vitess launched its latest stable release v19. The highlights of this update include metrics for monitoring stream consolidations, improved query compatibility with MySQL for multi-table delete operations, support for incremental backups, and various performance enhancements, among other features.
-
Uber's CacheFront: Powering 40M Reads per Second with Significantly Reduced Latency
Uber developed an innovative caching solution, CacheFront, for its in-house distributed database, Docstore. CacheFront enables over 40M reads per second from online storage and achieves substantial performance improvements, including a 75% reduction in P75 latency and over 67% reduction in P99.9 latency, demonstrating its effectiveness in enhancing system efficiency and scalability.
-
.NET Aspire Preview 3: Expanded Component Support with Azure OpenAI, MySQL, CosmosDB, Kafka and More
Last week, Microsoft revealed the availability of the .NET Aspire - third preview. Preview 3 brings changes including UI improvements to the dashboard, and new component support for Azure OpenAI, Kafka, Oracle, MySQL, CosmosDB & Orleans, and many more.
-
GitHub Upgrades its MySQL Infrastructure from v5.7 to 8.0
GitHub recently upgraded its MySQL infrastructure from version 5.7 to 8.0. The motivation behind this upgrade was 5.7 reaching the end of life, and a need to leverage the latest security patches, bug fixes, and performance enhancements offered by MySQL 8.0.