This blog post is a summary of the Percona Software and Roadmap Update – Q2 2017 webinar given by Peter Zaitsev on May 4, 2017. This webinar reflects changes and updates since the last update (Q1 2017).
A full recording of this webinar, along with the presentation slide deck, can be found here.
Percona Software
Below are the latest and upcoming features in Percona’s software. All of Percona’s software is 100% free and open source, with no …
[Read more]
In this post, we’ll see how to make Docker
images available to servers that don’t have access to the
Internet (i.e., machines where docker pull
<image_name> does not work).
As a specific example, we will do this with the latest Percona Monitoring and Management Docker images, since we had requests for this from users and customers. With the following steps, you’ll be able to deploy PMM within your secure network, without access to the Internet. Additionally, the same steps can be used when you need to upgrade the containers’ version in future releases.
There are two ways in which we can do this:
…[Read more]CTEs and Recursive CTEs appeared in MySQL 8.0; first in a Labs release and now in the official release 8.0.1. Several blogs have been published: here, here and here ; my colleague Øystein also wrote about how using a CTE made one DBT3 query run twice faster.…
This Log Buffer Edition covers Oracle, SQL Server, MySQL.
Oracle:
A Sneak Peek at Oracle’s Chatbot Cloud Service and 5 Key Factors Necessary for Bot ROI
Oracle JET Hybrid – NavDrawer Template Menu/Header Structure
Oracle Enterprise Linux 6.6 AMI Available on AWS
Datascape Podcast Episode 9 – What’s Up with Oracle These Days?
Sequential Asynchronous calls in …
[Read more]The MariaDB project is pleased to announce the immediate availability of MariaDB 10.2.6 Stable (GA). This is the first stable (GA) release in the MariaDB 10.2 series. See the What is MariaDB 10.2? page for more details on the new features in MariaDB 10.2. Download MariaDB 10.2.6 Release Notes Changelog What is MariaDB 10.2? MariaDB […]
The post MariaDB 10.2.6 Stable now available appeared first on MariaDB.org.
Recently MySQL launched the General Availability of their Group Replication enhancements via the MySQL Shell and MySQL Router. Although these URLs just noted go to their respective documentation pages, these collectively are part of the InnoDB Cluster offering. The MySQL shell provides sophisticated provisioning, monitored insight and management of a Group Replication setup. When provisioned as such, you… Read More »
In this blog, we’ll look at ICP counters in the information_schema.INNODB_METRICS. This is part two of the Index Condition Pushdown (ICP) counters blog post series.
As mentioned in the previous post, in this blog we will look at how to check on ICP counters on MySQL and Percona Server for MySQL. This also applies to MariaDB, since the INNODB_METRICS table is also available for MariaDB (as opposed to the Handler_icp_% counters being MariaDB-specific). We will use the same table and data set as in the previous post.
For simplicity we’ll show the examples on MySQL 5.7.18, but they …
[Read more]In this tutorial, I will show you step by step to configure MySQL securely for remote connections with SSL. MySQL is an open source relational database system that works on many Operating Systems including Windows, Linux, MacOS and FreeBSD. It is probably the most popular OpenSource RDBMS and a central component of the LAMP and LEMP Stacks.
Kristian Nielsen is working on a new feature for MariaDB 10.3 and he published very interesting results. This feature is MDEV-12179: Per-engine mysql.gtid_slave_pos tables. He writes about replicating twice as fast in the worst case when using two storage engines (InnoDB and MariaRocks in his tests, but could also be InnoDB and TokuDB or TokuDB and MyRocks). I will let you read all the details
In a perfect world, one would upgrade databases one version at a time and not let them get too old. But our databases are where the “crown jewels” are. They must stay up 24×7. When performance is acceptable, it’s acceptable, and sometimes old versions stay around too long. We don’t live in a perfect world. This idea applies to so many things. There’s almost never a perfect data model. There is always some type of resource constraint be it storage, memory, CPU, IOPS, or just plain dollars.
I will bring this concept of not living in a perfect world into a discussion about upgrades.
Ideally there would be…
