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.
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.
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.
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 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 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.
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 is making MySQL available in the cloud as a fully managed service, including a JSON API for programmatic management.
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.
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.
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.
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.
Oracle recently announced a new migration tool, which provides an ability to quickly migrate data and applications from Microsoft SQL Server to MySQL with less time and effort. The migration tool which has been integrated into MySQL Workbench, allows visual design, development and administration of MySQL databases with an advanced logging and security mechanism.
Oracle fires a new round for the heart of the NoSQL market. This 7.2 release of MySQL Cluster has new features putting it head to head with other NoSQL solutions including REST, memcached wire protocol, NoSQL C++, and standard MySQL interfaces. Oracle boasts 70x speed gains for complex queries using MapReduce like distributed joins. Is the world ready for a MySQL/NoSQL hybrid from Oracle?