System News
14 Apr 2017
Setting up MySQL Cluster in the Oracle Bare Metal Cloud
By Mikael Ronstrom

Mikael blogs, "The Oracle Bare Metal Cloud service is an innovative cloud service. When looking at how it can be used for MySQL Cluster it is a great fit.

MySQL Cluster is a high availability solution. Oracle Bare Metal Cloud provides the possibility to have servers that only you use and thus two Oracle Bare Metal servers are definitely independent of each others hardware. If you want to also run synchronous replication with no dependence on network, housing and electricity you can place these servers in different availability domains in the same region. Thus it is possible to build individual clusters with very high availability.

It is still possible to use smaller virtual machines that share the machine with other simultaneous users..."
(Get More Information . .)

12 Apr 2017
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows
By Martin Hansson

Martin blogs, "MySQL 8.0.1 introduces two new features which allow you to better manage situations where you have tables with hot row contention. This issue frequently presents itself in scenarios such as worker threads all accessing the same tables trying to find new work, and ecommerce websites trying to keep accurate inventory counts.

My example for today will be trying to book tickets to a Hockey game..."
(Get More Information . .)

12 Apr 2017
MySQL 8.0: Improved performance with CTE
By MySQL Server Team

Oystein Grovlen blogs, "MySQL 8.0 introduces Common Table Expressions (CTE). My colleague Guilhem has written several blog posts on how to use CTEs , and you can also read about it in the MySQL 8.0 Reference Manual. In this blog post, I will focus on how using a CTE instead of a view or a derived table can improve performance.

As usual, my example query will be a query from the DBT-3 benchmark. This time, we will look at Query 15, the Top Supplier Query:..."
(Get More Information . .)

11 Apr 2017
MySQL for Visual Studio 1.2.7
By Jose Ramirez

Jose blogs, "The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 1.2.7. This is a maintenance release for 1.2.x. It can be used for production environments.

MySQL for Visual Studio is a product that includes all of the Visual Studio integration functionality to create and manage MySQL databases when developing .NET applications.

MySQL for Visual Studio is installed using the MySQL Installer for Windows which comes in 2 versions..."
(Get More Information . .)

11 Apr 2017
Replication Features in MySQL 8.0.1
By Luis Soares

Luis blogs, "MySQL 8.0.1 has just been released with a wonderful set of features across the board. Specifically in replication, there is plenty of new and exciting functionality as well as performance improvements. In this post I am going to summarize the replication features of this development milestone release..."
(Get More Information . .)

See all archived MySQL articles See all articles from this issue