Overview
Redundancy is key to providing resilience to failures, and in Fabric 1.6.2 (now available on MySQL Labs), we have introduced the possibility to start multiple MySQL Fabric instances that are kept consistent through a replicated state machine.
The state machine replication guarantees that all machines (i.e.…
The MySQL Fabric team is pleased to announce that a new version is now available on Labs. This labs release includes our latest developments to give you a taste of what we have been working on. In particular, it includes the following new features and improvements:
…
Today I received about five emails with the subject: 3 Big Announcements from MariaDB. Maybe you did as well (else, read it online). October has brought on some very interest announcements, and I think my priority for the big announcements vary a little:
MySQL 5.7 supports the Address Sanitizer, which checks for several memory
related software errors including memory leaks. It is
really nice to see support for the Address Sanitizer built into
MySQL. Unfortunately, when running the mysql tests included
in MySQL 5.7.9, the Address Sanitizer reports
several memory leaks, which causes some of the tests to
fail. Here are some of the memory leaks in the MySQL 5.7.9
software found by the Address Sanitizer.
Memory leaks in 'mysqlbinlog'Several of the 'mysqlbinlog' tests
fail due to memory leaks in the 'mysqlbinlog' client program.
Here are the details from the ' …
This week Oracle will release MySQL 5.7 GA, so
it’s a perfect time to do a quick review of the current state of
Percona Server 5.6.26, MySQL 5.6.26 and MySQL-5.7.8 RC. We used
two boxes from our benchmark lab for this:
– Box 1: 16 Cores+HT (32 virt cores)/fast PCIe ssd card/RAM:
192GB
– Box 2: 24 Cores+HT(48 virt cores)/fast PCIe ssd card/RAM: 128GB
Dataset: sysbench/uniform, 32 tables with 12M rows each,
~95GB
Tests: sysbench – point select, oltp read only, oltp
read/write
Test sequence: start server, warmup, series of the tests (each
lasts 5 minutes) from 1 to 4096 threads
Tests were run for two setups:
– CPU bound (in memory) – innodb_buffer_pool_size=100GB
– IO bound – innodb_buffer_pool_size=25GB
…
[Read more]Requires ClusterControl 1.2.11 or later. Applies to MySQL based clusters.
In this example we will look at how you can use ClusterControl to create a user and assign privileges to the user. We will create a user that has enough privileges to perform an xtrabackup.
In the ClusterControl UI press Manage > Schemas and Users, and then press Create Account. You will see the following screen, and here we have filled out the details to create a user with enough privileges to run xtrabackup:
Server refers to the server from which the user is allowed to connect. In Create On DB Node you can select a particular server to …
[Read more]Hi all, keeping our steady release cycle, it is time again to do another preview release of MySQL Group Replication, the plugin that brings multi-master update everywhere to MySQL, like we described in Hello World post.
We are very proud to do the fifth preview release of MySQL Group Replication, version 0.6.0 based on MySQL Server 5.7.9, which introduces new exciting features, please enjoy the highlights!…
Mon, 2015-10-26 09:49Roger Levy
The year has flown by so quickly and I am simply stunned that Fall is now upon us. With the changing of seasons it is time for another software release of MariaDB Enterprise (MDBE) as well as MaxScale.
We’ve heard many things from our customers and we continue to focus on the most important and mission critical. With our Fall releases, we enhance and provide fixes on our security, scalability and performance features.
Over the last year we have delivered several new capabilities in our enterprise offer such as optimized binaries and support for the Power8 platform. We have also introduced the MariaDB MaxScale intelligent gateway to help you secure, scale and maintain your database infrastructure. What does all of this mean, exactly?
We have been working all year to address the needs of our customers and community. We are always focused on working with our customers and community …
[Read more]
Docker is one of the fastest growing trends in IT. It allows fast
deployment of services and applications on a Linux machine (and,
with some limits, on other operating systems). Compared to other
methods of deploying databases, such as virtual machines or application
isolation, it offers faster operations and better
performance.
Many people, surprised by the sudden advance of this technology,
keep asking What is Docker? And why you should use
it?
I will write soon an article with a deep comparison of the three
methods (VM, container, sandbox), but for now, we should be
satisfied with a few basic facts:
I was wondering if it is possible to write a MySQL User Defined
Function (UDF) in Go.
So I tried and I got a very basic UDF working.
mysql> SELECT udf_fileexists_go("/etc/hosts");
+---------------------------------+
| udf_fileexists_go("/etc/hosts") |
+---------------------------------+
| 1 |
+---------------------------------+
1 row in set (0.00 sec)
mysql> SELECT udf_fileexists_go("/nonexistend");
+-----------------------------------+
| udf_fileexists_go("/nonexistend") |
+-----------------------------------+
| 0 |
+-----------------------------------+
1 row in set (0.00 sec)
This is nowhere near production quality, so be careful.
The code is here:https://github.com/dveeden/udf_fileexists_go/blob/master/udf_fileexists_go.go. …