System News
back1 2 3 4 5 6 7 8 9 10 11 next
Archived MySQL Articles
09 Feb 2017
open to premium members only
How to deploy and manage MySQL multi-master replication setups with ClusterControl 1.4 [60520]
By Severalnines, February 9th, 2017

severalnines blogs, "MySQL replication setups can take different shapes. The main topology is probably a simple master-slave setup. But it is also possible to construct more elaborate setups with multiple masters and chained setups. ClusterControl 1.4 takes advantage of this flexibility and gives you possibility to deploy multimaster setups. In this blog post, we will look at a couple of different setups and how they would be used in real-life situations..."
(Get More Information . .)

08 Feb 2017
open to premium members only
MySQL Server log Maintenance [60521]
By lalit, February 8th, 2017

Lalits blogs, "As a part database administration, DBA has to take care of sub-components of database like server logs and has to plan for maintenance activity for these components regularly.

MySQL has various types of log i.e binary log, error log, slow query log, general log for different purposes. And after certain time these logs will grow and you will start seeing issues like low disk space, a large number of logs etc.

MySQL allows you to flush logs using flush logs command, next 'How to rotate and clean up old MySQL logs?' ..."
(Get More Information . .)

07 Feb 2017
open to premium members only
MySQL Workbench 6.3.9 [60522]
MySQL Workbench Team, February 7th, 2017

The MySQL Workbench Team blogs, "The MySQL developer tools team announces 6.3.9 as our GA release for MySQL Workbench 6.3.

For the full list of changes in this revision, visit here

For discussion, join the MySQL Workbench Forums: [url "here"] ..."
(Get More Information . .)

07 Feb 2017
open to premium members only
Overview of Different MySQL Replication Solutions [60523]
By Dimitri Vanoverbeke, February 7th, 2017

Dimitri blogs, "In this blog post, I will review some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). I will also try to clarify some of the misconceptions people have about replication.

Since I've been working on the Solution Engineering team, I've noticed that - although information is plentiful - replication is often misunderstood or incompletely understood..."
(Get More Information . .)

02 Feb 2017
open to premium members only
Testing performance of MySQL Group Replication [60305]
ProxySQL, February 2nd, 2017

ProxySQL blogs, "MySQL Group Replication is a hot topic in MySQL ecosystem.

We have been evaluating it in , and it is now time to evaluate its performance, especially now that is GA. In our setup, we wanted to evaluate how it performs compared to standard asynchronous MySQL replication. Therefore MySQL 5.7.17 was first tested with regular async replication, MTS, semi-sync, and finally Group Replication..."
(Get More Information . .)

30 Jan 2017
open to premium members only
Automatic failover of MySQL Replication - New in ClusterControl 1.4 [60309]
By Severalnines, January 30th, 2017

Krzysztof Ksiazek blogs, "MySQL replication setups are inevitably related to failovers. Unlike multi-master clusters like Galera, there is one single writer in a whole setup - the master. If the master fails, one of the slaves will have to take its role through the process of failover. Such process is tricky and potentially, it may cause data loss. It may happen, for example, if a slave is not up to date while it is promoted. The master may also die before it is able to transfer all binlog events to at least one of its slaves.

Different people have different takes on how to perform failover. It depends on personal preferences but also on requirements of the business. There are two main options - automated failover or manual failover..."
(Get More Information . .)

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