The latest from the MySQL community

Here at VividCortex, it’s clear to us that proper database monitoring is “an art.” Beyond simple, raw power, navigating and understanding a database takes finesse, insight, and, often, a kind of eloquence.

On special occasions, though, the artistry of database monitoring becomes a little bit more literal, and we get to see how the functions of big data can be applied to the actual world of Fine Art. Such is the case now: this summer, New York’s world-class Museum of Modern Art (MoMA) decided to publicly post an enormous CSV file on GitHub, which contains various data sets for more than 125,000 pieces in the museum’s collection.

Essentially, with this document, a scholar, museum guest, or artist now has access to huge swaths of information about the art at MoMA – short of an image of the piece itself. While the ultimate experience for most …

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 10.0.21 and 5.5.45. These are both Stable (GA) releases.

Download MariaDB Galera Cluster 10.0.21

Release Notes Changelog What is MariaDB Galera Cluster?

Download MariaDB Galera Cluster 5.5.45

Release Notes …

Astute readers will note that InnoDB already had compression since the MySQL 5.1 plugin. We are using the terminology of ‘Page Compression’ to describe the new offering that will ship with MySQL 5.7, and ‘InnoDB Compression’ for the earlier offering.…

We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

About Amazon Aurora:
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

SQLyog + Amazon Aurora:
It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

Not only these, you get all the …

We are elated to announce the availability of SQLyog for Amazon Aurora Databases. You can now manage Amazon Aurora databases with SQLyog, the most powerful database manager, admin and GUI tool.

About Amazon Aurora:
Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases.

SQLyog + Amazon Aurora:
It is very easy to connect Aurora database using SQLyog: just enter the DNS address of the Aurora instance as the host parameter, port number from the endpoint as the port parameter and key in your credentials. You can manage your Aurora databases with powerful tools like Synchronisation, Import External Data, Backup Wizard, Job Scheduler etc.

Not only these, you get all the …

Tue, 2015-08-18 15:06dion_cornett_gThe Convergence of Enterprise-Class and Choice – an Open Source Ecosystem Running on a True Enterprise-Class Platform: MariaDB Enterprise on IBM z Systems

While selling free software sounds like a hard job, the growing mainstream adoption of open source makes it one of the most exciting segments in IT. In my daily meetings with customers, there is no ambiguity that open source is the foundation for the hottest trends in technology, including Cloud, Analytics, Mobile and Social. Gartner reports that 70% of all new applications are built using an open source database. (1)

Yet until now, many customers had to make compromises related to leveraging the innovation, high-quality code, lower costs, and choice inherent in open source, versus leveraging highly secure, scalable and power efficient enterprise-class z Systems offered by IBM.

Today at LinuxCon North America that changes. We at …

Giuseppe and Shlomi both blogged on one of the recent changes introduced to MySQL 5.7.8-rc, where the setting show_compatibility_56 is now set OFF by default.

Both raise very good points. Here is how we plan to address them:

1. The permissions issue reported by Giuseppe will be fixed.
2. When selecting from information_schema tables in show_compatibility_56=OFF mode, an error …

Today’s topic is related primarily to compiling MySQL from source using CMAKE and what kind of issues we encounter during this task. We want to install MySQL 5.6.19 with Debug+Valgrind etc. On CentOS 7 here are my dependency packages start point:

[root@centos-base ~]# yum install zlib zlib-devel openssl openssl-devel valgrind valgrind-devel cmake gcc cpp ncurses ncurses-devel

Here is my CMAKE command:

[root@centos-base mysql-5.6.19]# cmake -DCMAKE_INSTALL_PREFIX=/opt/mysql-5.6.19 -DMYSQL_DATADIR=/var/lib/mysql -DSYSCONFDIR=/opt/mysql-5.6.19 -DWITH_SSL=system -DMYSQL_TCP_PORT=3306 -DMYSQL_UNIX_ADDR=/opt/mysql-5.6.19/mysqld.sock -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=1 -DCOMPILATION_COMMENT="Shahriyar Rzayev's CentOS MySQL-5.6.19" -DOPTIMIZER_TRACE=1 -DWITH_ZLIB=system -DWITH_VALGRIND=1 -DCMAKE_C_FLAGS=-DHAVE_purify -DCMAKE_CXX_FLAGS=-DHAVE_purify

If you try to run …

“Shard. Or do not shard. There is no try.”
                                          - Yoda

This is a technical dive into how we split our data across many MySQL servers. We finished launching this sharding approach in early 2012, and it’s still the system we use today to store our core data.

Before we discuss how to split the data, let’s be intimate with our data. Mood lighting, chocolate covered strawberries, Star Trek quotes…

Pinterest is a discovery engine for everything that interests you. From a data perspective, Pinterest is the largest human curated interest graph in the world. There are more than 50 billion Pins that have been saved by Pinners onto one billion boards. People repin and like other Pins (roughly a shallow copy), follow other Pinners, boards and interests, and …

In order to make it easier to work with data stored as binary strings (BINARY/VARBINARY) we are considering extending the &,|,^,~,> operators, to accept any-size binary strings and return binary string data as response. This can be useful for several complex data types not covered by the basic SQL data types (e.g. working with IPV6 addresses, manipulating UUID, etc).

Motivation

Let’s say we’re interested in getting all the networks that contain the given IP address. With ipv4 the common practice is to store the IP addresses as INT and execute:

SELECT inet_ntoa(network) AS network, inet_ntoa(netmask) AS netmask FROM network_table WHERE (inet_aton('192.168.0.30') & netmask) = network;

At the moment you are not able to do the same with ipv6 because inet6_aton('2001:0db8:85a3:0000:0000:8a2e:0370:7334') & netmask converts both operands from VARBINARY to BIGINT resulting in data truncation and …