InfoQ Homepage MySQL Content on InfoQ
-
Uber Engineering Moving from Postgres to MySQL
In a recent blog post, Uber detailed why they have chosen to replace PostgreSQL with MySQL. In this article we present a high level overview of the problems they faced, how MySQL fares against them and some of the best rebuttals against the case presented by Uber.
-
Slick 3: Reactive Streams for Asynchronous Database Access in Scala
Slick, Typesafe's database query and access library for Scala, now supports the Reactive Streams API in the just released version 3.0. This enables developers to query their databases asynchronously and non-blocking. InfoQ talked to Slich Tech-Lead Stefan Zeiger to learn more about the new features and what they've planned for the future.
-
More Enhancements for MySQL 5.7 including Computed Columns
Continuing our MySQL 5.7 coverage from last week, we take a look at changes to security, data integrity, performance, and some new features such as Generated Columns.
-
InnoDB Enhancements for MySQL 5.7
MySQL 5.7 comes with over 20 enhancements to InnoDB. In this, the first of our reports on MySQL 5.7, we will cover some of the highlights such as temp table performance, spatial indexes, and full text search parsers.
-
MySQL Offers a REST API
A prototype of MySQL 5.7 is shipping with an optional component called the MySQL HTTP Plugin. This plugin allows direct access to MySQL via a REST over HTTP interface, eliminating the need for a middle-tier server or database specific drivers.
-
MySQL to Adopt ACID for System Tables
In what is probably a surprise to many developers, MySQL currently stores its critical system tables in MyISAM instead of InnoDB. Since MyISAM isn’t ACID compliant, there is a chance for data loss or corruption when modifying system objects such as privilege. Morgan Tocker has announced that the MySQL team intends to address this in the near future.
-
Facebook, Google, LinkedIn, and Twitter Want to Make Sure that MySQL Is “Web-Scale”
Facebook, Google, LinkedIn, and Twitter have decided to make sure that a relational databases is “web-scale”, so they have put their efforts behind WebScaleSQL, a branch of MySQL 5.6 Community Edition.
-
Google Cloud SQL now Generally Available
Google have announced general availability of their Cloud SQL service. At launch the service comes with automatic encryption of customer data, a 99.95% uptime SLA and support for databases up to 500GB in size.
-
OpenAccess ORM Q3 2013 SP1 Adds VS 2013 Support, Discontinued Classic Wizards, Oracle 9i and MySQL 5
The recently released OpenAccess ORM Q3 2013 SP1 by Telerik has introduced support for Visual Studio 2013 in addition to extended support for Visual Studio 2008. Moreover, support for classic wizards, Oracle 9i and MySQL 5.0 will be discontinued beginning with the next release of OpenAccess ORM.
-
Scaling Dropbox
Being clever about system architecture in advance is hard. Scaling successfully is more about being clever with metrics and introspection, creating efficient build and provisioning processes and being comfortable with radical change. These are some of the keys to scaling at Dropbox according to Rajiv Eranki in his recent presentation at the 2013 RAMP Conference.
-
Google Extends Their Services with Cloud SQL
Google is making MySQL available in the cloud as a fully managed service, including a JSON API for programmatic management.
-
MySQL Reference Architectures for Small to Extra Large Websites
Oracle has published MySQL Reference Architectures for Massively Scalable Web Infrastructure, a whitepaper outlining recommended topologies for different types and sizes of websites using MySQL for data storage.
-
Learning to Scale Websites at Mozilla
Mozilla is scaling websites from thousands to hundreds of millions of users through simple scaling patterns they have learned internally according to Brandon Burton, web operations engineer at Mozilla. The lessons learned include caching, scaling out web servers, asynchronous jobs, and databases.
-
MySQL 5.6 Enterprise Edition with Full Text Indexes and Online DDL
The 5.6 series for MySQL has reached the point where Oracle feels comfortable in releasing an updated MySQL Enterprise Edition for its paying customers. This version includes a significantly updated version of InnoDB with full text search and online DDL.
-
Cassandra Storage Engine for MariaDB
MariaDB has announced a preview of the Cassandra Storage Engine. This is a plugin that allows MariaDB to access Cassandra clusters using normal SQL syntax.