Percona announces the release of Percona XtraDB Cluster 5.6.35-26.20-3 on April 13, 2017. Binaries are available from the downloads section or our software repositories.
Percona XtraDB Cluster 5.6.35-26.20-3 is now the current release, based on the following:
All Percona software is open-source and free.
…
[Read more]
Last week I published a blog post in the MySQL Server Blog where I showed how the
execution time of a query was reduced by 50% by using a Common
Table Expression (CTE) instead of a view.
In the coming weeks, there will be several opportunities to
attend a presentation on CTE and another SQL feature that will
arrive in MySQL 8.0, Window Functions. This
presentation is part of the Oracle MySQL Innovation Day that will
be held both in the Bay Area (April 28) and in the Boston Area (May 2).
I will also give the presentation at the …
In our latest release of Percona XtraDB Cluster, we’ve introduced major performance improvements to the MySQLwrite-set replication layer. In this post, we want to show what these improvements look like.
For the test, we used the sysbench OLTP_RW, UPDATE_KEY and UPDATE_NOKEY workloads with 100 tables, 4mln rows each, which gives about 100GB of datasize. In all the tests we use a three-node setup, connected via a 10GB network, with the sysbench load directed to the one primary node.
In the first chart, we show improvements comparing to the previous version (5.7.16):
The main improvements come from concurrent workloads, under multiple threads.
The …
[Read more]Percona announces the release of Percona XtraDB Cluster 5.7.17-29.20 on April 19, 2017. Binaries are available from the downloads section or our software repositories.
NOTE: You can also run Docker containers from the images in the Docker Hub repository.
Percona XtraDB Cluster 5.7.17-29.20 is now the current release, based on the following:
Dear MySQL users,
MySQL Connector/Python 2.1.6 GA is a fourth GA version of 2.1
release
series of the pure Python database driver for MySQL. It can be
used for
production environments.
MySQL Connector/Python version 2.1.6 GA is compatible with MySQL
Server
versions 5.5 and greater. Python 2.6 and greater as well as
Python 3.3
and greater are supported. Python 2.4, 2.5 and 3.1, 3.2 are
not
supported.
MySQL Connector/Python 2.1.6 is available for download from:
http://dev.mysql.com/downloads/connector/python/#downloads
The ChangeLog file included in the distribution contains a brief
summary
of changes in MySQL Connector/Python 2.1.6. For a more complete
list of
changes, see below or online at:
http://dev.mysql.com/doc/relnotes/connector-python/en/
Enjoy!
Changes in MySQL Connector/Python 2.1.6 (2017-04-18,
General
…
MySQL 8 is going to have new batch of JSON functions and last time JSON_PRETTY() was covered in some details. The recent release of 8.0.1 provides an opportunity to try these new functions and a few that might have been missed with 8.0.0. Unquoting
The -> shortcut for JSON_EXTRACT() was introduced with MySQL 5.7. And now there is the unquoting extraction operator or ->> to simplify things again! Think of it as JSON_UNQUOTE wrapped around JSON EXTRACT. The following there queries produce the same output. mysql> SELECT JSON_UNQUOTE(JSON_EXTRACT(doc,"$.GNP")) FROM countryinfo WHERE _id = "USA"; +-----------------------------------------+ | JSON_UNQUOTE(JSON_EXTRACT(doc,"$.GNP")) | +-----------------------------------------+ | 8510700 | +-----------------------------------------+ 1 row in set (0.00 sec) mysql> …
[Read more]Percona announces the GA release of Percona XtraBackup 2.4.7 on April 18, 2017. You can download it from our download site and apt and yum repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona …
[Read more]Percona announces the release of Percona XtraBackup 2.3.8 on April 18, 2017. Downloads are available from our download site or Percona Software Repositories.
Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies with large data sets and mission-critical applications that cannot tolerate long periods of downtime. Offered free as an open source solution, Percona XtraBackup drives down backup costs while providing unique features for MySQL backups.
This release is the …
[Read more]In this blog post, I’ll discuss some of my thoughts about the future of MariaDB after attending the M17 Conference.
Let me start with full disclosure: I’m the CEO of Percona, and we compete with the MariaDB Corporation in providing Support for MariaDB and other services. I probably have some biases!
Last week I attended the MariaDB Developers UnConference and the M17 Conference, which provided great insights into MariaDB’s positioning as a project and as a business. Below are some of my thoughts as I attended various sessions at the …
[Read more]The new release of MySQL is packed with exciting features that help detecting and analyzing replication lag. In this post, you will be able to learn all about the new replication timestamps, the new useful information that is now reported by performance schema tables, and how delayed replication was improved.…
