The MySQL Development team is very happy to announce that MySQL 8.0.16 is now available for download at dev.mysql.com. In addition to bug fixes there are a few new features added in this release. Please download 8.0.16 from dev.mysql.com or from the MySQL Yum, APT, or SUSE repositories.…
Facebook Twitter Google+ LinkedIn
Dear MySQL users,
The MySQL developer tools team announces 8.0.16 as our general
available (GA) for MySQL Workbench 8.0.
For the full list of changes in this revision, visit
http://dev.mysql.com/doc/relnotes/workbench/en/news-8-0.html
For discussion, join the MySQL Workbench Forums:
http://forums.mysql.com/index.php?152
The release is now available in source and binary form for a
number of platforms from our download pages at:
http://dev.mysql.com/downloads/tools/workbench/
Enjoy!
Dear MySQL users,
MySQL Connector/Python 8.0.16 is the latest GA release version of
the
MySQL Connector Python 8.0 series. The X DevAPI enables
application
developers to write code that combines the strengths of the
relational
and document models using a modern, NoSQL-like syntax that does
not
assume previous experience writing traditional SQL.
To learn more about how to write applications using the X DevAPI,
see
http://dev.mysql.com/doc/x-devapi-userguide/en/.
For more information
about how the X DevAPI is implemented in MySQL Connector/Python,
and its
usage, see http://dev.mysql.com/doc/dev/connector-python.
Please note that the X DevAPI requires at least MySQL Server
version 8.0
or higher with the X Plugin …
Sysbench has long been established as the de facto standard when it comes to benchmarking MySQL performance. Percona relies on it daily, and even Oracle uses it when blogging about new features in MySQL 8. Sysbench comes with several pre-defined benchmarking tests. These tests are written in an easy-to-understand scripting language called Lua. Some of these tests are called: oltp_read_write, oltp_point_select, tpcc, oltp_insert. There are over ten such scripts to emulate various behaviors found in standard OLTP applications.
But what if your application does not fit the pattern of traditional OLTP? How can you continue to utilize the power of load-testing, benchmarking, …
[Read more]MySQL master-slave replication is pretty easy and straightforward to set up. This is the main reason why people choose this technology as the first step to achieve better database availability. However, it comes at the price of complexity in management and maintenance; it is up to the admin to maintain the data integrity, especially during failover, failback, maintenance, upgrade and so on.
There are many articles out there describing on how to perform failover operation for replication setup. We have also covered this topic in this blog post, Introduction to Failover for MySQL Replication - the 101 Blog. In this blog post, we are going to cover the post-disaster tasks when restoring to the original topology - …
[Read more]As a reminder for the shows where you can find MYSQL at this week, please see below:
We are looking forward seeing & talking to you @ above shows this week!
We would like to announce that MySQL Community Team 2019 MySQL Contributor Reward Program winners. This award started in 2015 to identify & reward the most active community members from the MySQL Community world. MySQL Community Team let printed a limited edition of “MySQL Community Contributor” t-shirts which were already distributed to almost all winners.
Same as in 2015 also now specific criteria for the nominations were wet as follows:
We are happy to announce that the people below …
[Read more]We are pleased to announce the launch of PMM 2.0.0-alpha1, Percona’s first Alpha release of our long-awaited PMM 2 project! We focused exclusively on MySQL support in our first Alpha (because we wanted to show progress sooner rather than later), and you’ll find updated MySQL dashboards along with enhancements to Query Analytics. We’ve also added better visibility regarding which services are registered with PMM Server, the client-side addition of a new agent called pmm-agent, and finally PMM Server is now exposing an API!
Kubernetes Operators are amazing and they are already playing an important role for those who are managing large scale applications. I personally think that we will manage all applications using Operators.
In this tutorial I will show you how to setup a MySQL cluster using the MySQL Operator on Kubernetes.
Prerequisites:
Let’s start with cloning the MySQL repository which contains the …
[Read more]During my presentation at Percona Live 2019 I will show how using Optimizer Trace can give insight into the inner workings of the MySQL Query Optimizer. Through the presentation, the audience will both be introduced to optimizer trace, learn more about the decisions the query optimizer makes, and learn about the query execution strategies the query optimizer has at its disposal. I’ll be covering the main phases of the MySQL optimizer and its optimization strategies, including query transformations, data access strategies, the range optimizer, the join optimizer, and subquery optimization.
Who’d benefit most from the presentation?
DBAs, developers, support engineers and other people who are concerned about MySQL query performance will benefit from this presentation. Knowing the optimizer trace …
[Read more]