System News
 1 2 3 4 5 6 7 8 9 10 11 next
Archived MySQL Articles
14 Apr 2017
open to premium members only
Setting up MySQL Cluster in the Oracle Bare Metal Cloud [62448]
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
open to premium members only
MySQL 8.0.1: Using SKIP LOCKED and NOWAIT to handle hot rows [62453]
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
open to premium members only
MySQL 8.0: Improved performance with CTE [62456]
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
open to premium members only
MySQL for Visual Studio 1.2.7 [62457]
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
open to premium members only
Replication Features in MySQL 8.0.1 [62458]
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 . .)

05 Apr 2017
open to premium members only
MySQL High Availability tools - Comparing MHA, MRM and ClusterControl [62252]
Severalnines, April 5th 2017

Krzysztof Ksiazek blogs, "We previously compared two high availability solutions for MySQL - MHA and MariaDB Replication Manager and looked into how they performed fail-over. In this blog post, we'll see how ClusterControl stacks up against these solutions. Since MariaDB Replication Manager is under active development, we decided to take a look at the not yet released version 1.1.

All solutions provide flapping detection. MHA, by default, executes a failover once. Even after you restart masterha_manager, it will still check if the last failover didn't happen too recently. If yes (by default, if it happened in the last 8 hours), no new failover will happen. You need to explicitly change the timeout or set --ignore_last_failover flag..."
(Get More Information . .)

 
 1 2 3 4 5 6 7 8 9 10 11 next