System News
back1 2 3 4 5 6 7 8 9 10 11 next
Archived MySQL Articles
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 . .)

25 Mar 2017
open to premium members only
MySQL 8.0 roles [61831]
The Data Charmer, March 25th, 2017

Giuseppe blogs, "One of the most interesting features introduced in MySQL 8.0 is roles or the ability of defining a set of privileges as a named role and then granting that set to one or more users. The main benefits are more clarity of privileges and ease of administration. Using roles we can assign the same set of privileges to several users, and eventually modify or revoke all privileges at once..."
(Get More Information . .)

23 Mar 2017
open to premium members only
MySQL Group Replication: native support in ProxySQL [61837]
By Lefred

Lefred blogs, "ProxySQL is the leader in proxy and load balancing solution for MySQL. It has great features like query caching, multiplexing, mirroring, read/write splitting, routing, etc. The latest enhancement in ProxySQL is the native support of MySQL Group Replication. No more need to use an external script within the scheduler like I explained in this previous post.

This implementation supports Groups in Single-Primary and in Multi-Primary mode. It is even possible to setup a Multi-Primary Group but dedicate writes on only one member..."
(Get More Information . .)

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