System News
back1 2 3 4 5 6 7 8 9 10 11 next
Articles for the keywords: MySQL
03 Feb 2017 Libreoffice Vs. Microsoft Office: It'S A Format War [60222]
CIO, February 3rd, 2017

"Italo Vignoli, a co-founder of The Document Foundation, shares his thoughts on the past, present and future of LibreOffice.

Sun Microsystems was home to many critical open source projects including OpenOffice, MySQL, Java, and VirtualBox. When Oracle acquired Sun, members of these projects grew concerned about their projects. MySQL was forked, and the OpenOffice community created a body called The Document Foundation (TDF) to ensure the survival of the project.

However, Oracle was displeased about the formation of TDF and the ensuing conflict led to LibreOffice becoming a fork of OpenOffice. The first release of LibreOffice came in 2011. By 2012, TDF was registered as an organization in Germany..."
(Get More Information . .) open to premium members only

02 Feb 2017 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 . .) open to premium members only

30 Jan 2017 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 . .) open to premium members only

26 Jan 2017 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 . .) open to premium members only

20 Jan 2017 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 . .) open to premium members only

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

!-- end archive_section.tpl -->