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

13 Jan 2017
open to premium members only
The Impact of Swapping on MySQL Performance [59684]
By Peter Zaitsev , January 13th, 2017

Peter blogs, "In this blog, I'll look at the impact of swapping on MySQL performance.

It's common sense that when you're running MySQL (or really any other DBMS) you don't want to see any I/O in your swap space. Scaling the cache size (using innodb_buffer_pool_size in MySQL's case) is standard practice to make sure there is enough free memory so swapping isn't needed.

But what if you make some mistake or miscalculation, and swapping happens? How much does it really impact performance? This is exactly what I set out to investigate..."
(Get More Information . .)

10 Jan 2017
open to premium members only
MySQL Connector/C 6.1.9 GA has been released [59685]
By Piotr Obrzut, January 10th, 2017

Piotr blogs, "A new GA (general availability) version of MySQL Connector/C has been made available: MySQL Connector/C 6.1.9 GA. The MySQL Connector/C provides a C API for connecting client applications to the MySQL Server 5.5 or newer...

MySQL Connector C (Commercial) will be available for download on the My Oracle Support (MOS) website. This release will be available on eDelivery (OSDC) in next month's upload cycle..."
(Get More Information . .)

10 Jan 2017
open to premium members only
What MySQL 8.0.1 means to you as a Developer [59686]
By Gabriela D'Avila, January 10th, 2017

Gabriela blogs, "Oracle released the development version of MySQL 8.0.0-dmr on September 12th of 2016. Since then, the team have been working on the 8.0.1 development milestone. You can find the partial change list here.

The objective here is try to explain how this will have any real world impact for you from 8.0.1. Please remember though, that any changes made to this version will not be final until the General Availability (date not currently set).

These topics are aimed at the Software Engineering side and not DBA and this is why Replication, for instance, is not covered here..."
(Get More Information . .)

10 Jan 2017
open to premium members only
MySQL Connector/C 6.1.9 GA has been released [59688]
By Piotr Obrzut, January 10th, 2017

Piotr blogs, "A new GA (general availability) version of MySQL Connector/C has been made available: MySQL Connector/C 6.1.9 GA. The MySQL Connector/C provides a C API for connecting client applications to the MySQL Server 5.5 or newer...

MySQL Connector C (Commercial) will be available for download on the My Oracle Support (MOS) website. This release will be available on eDelivery (OSDC) in next month's upload cycle.

We have improved the driver since the last GA release. Please see the documentation and the CHANGES file in the source distribution for a detailed description of bugs that have been fixed. Bug descriptions are also listed below..."
(Get More Information . .)

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