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

26 Jan 2017
open to premium members only
Working with JSON in MySQL [60097]
By Noman Ur Rehman, January 26th, 2017

Noman blogs, "SQL databases tend to be rigid.

If you have worked with them, you would agree that database design though it seems easier, is a lot trickier in practice. SQL databases believe in structure, that is why it's called structured query language.

On the other side of the horizon, we have the NoSQL databases, also called schema-less databases that encourage flexibility. In schema-less databases, there is no imposed structural restriction, only data to be saved.

Though every tool has it's use case, sometimes things call for a hybrid approach.

What if you could structure some parts of your database and leave others to be flexible?

MySQL version 5.7.8 introduces a JSON data type that allows you to accomplish that..."
(Get More Information . .)

20 Jan 2017
open to premium members only
Automating MySQL Replication with ClusterControl 1.4.0 [59845]
By Severalnines, January 20th, 2017

With the recent release of ClusterControl 1.4.0, we added a bunch of new features to better support MySQL replication users. In this blog post, we'll give you a quick overview of the new features.

Enhanced multi-master deployment

A simple master-slave replication setup is usually good enough in a lot of cases, but sometimes, you might need a more complex topology with multiple masters. With 1.4.0, ClusterControl can help provision such setups. You are now able to deploy a multi-master replication setup in active - standby mode. One of the masters will actively take writes, while the other one is ready to take over writes should the active master fail. You can also easily add slaves under each master, right from the UI.
(Get More Information . .)

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