Tag: database

Software

ProxySQL Releasing ProxySQL 1.4.6

Proudly announcing the release of the latest stable release of ProxySQL 1.4.4 as of the 1st of February 2018. ProxySQL is a high performance, high availability, protocol aware proxy for MySQL. It can be downloaded here, and freely usable and accessible according to GPL license. ProxySQL 1.4.6 includes a number of important improvements and bug …

Miscellaneous

Amazon Aurora MySQL Monitoring with Percona Monitoring and Management (PMM)

In this blog post, we’ll review additional Amazon Aurora MySQL monitoring capabilities we’ve added in Percona Monitoring and Management (PMM) 1.7.0. You can see them in action in the MySQL Amazon Aurora Metrics dashboard. Amazon Aurora MySQL Transaction Commits This graph looks at the number of commits the Amazon Aurora engine performed, as well as the …

Software

Percona Server for MySQL 5.6.39-83.1 Is Now Available

Percona announces the release of Percona Server for MySQL 5.6.39-83.1 on February 13, 2018. Based on MySQL 5.6.39, including all the bug fixes in it, Percona Server for MySQL 5.6.39-83.1 is now the current stable release in the 5.6 series. Percona Server for MySQL is open-source and free. Downloads are available here and from the Percona Software …

Miscellaneous

ProxySQL | Compiling ProxySQL on FreeBSD

Compiling ProxySQL 1.4.6 on FreeBSD 11.1 FreeBSD is the operating system of choice for many MySQL installations and a topic that often comes up in the ProxySQL Google Forums as well as the ProxySQL Github Issue Tracker is related to ProxySQL on FreeBSD. An official package for FreeBSD (and BSD in general) is not available …

Clustering

Announcing Galera Cluster Security Release for MySQL 5.5.59, 5.6.39, 5.7.21 with Galera 3.23

Codership is pleased to announce the release of Galera Replication library 3.23, implementing wsrep API version 25. This release incorporates all changes up to MySQL 5.7.21, MySQL 5.6.39 and MySQL 5.5.59, including several fixes to vulnerabilities reported by Oracle in here. New features and notable fixes in Galera replication since last binary release by Codership …

Miscellaneous

Introducing log management in AWS Database Migration Service

AWS Database Migration Service (AWS DMS) helps you migrate databases to AWS quickly and securely. You can migrate your data to and from most widely used commercial and open-source databases, such as Oracle, Microsoft SQL Server, and PostgreSQL. The service supports homogeneous migrations such as Oracle to Oracle, and also heterogeneous migrations between different database …

Miscellaneous

ProxySQL Query Cache: What It Is, How It Works

In this blog post, I’ll present the ProxySQL query cache functionality. This is a query caching mechanism on top of ProxySQL. As there are already many how-tos regarding the ProxySQL prerequisites and installation process, we are going to skip these steps. For those who are already familiar with ProxySQL query cache configuration, let’s go directly …

Miscellaneous

Announcing Experimental Percona Monitoring and Management (PMM) Functionality via Percona Labs

In this blog post, we’ll introduce how you can look at some experimental Percona Monitoring and Management (PMM) features using Percona Labs builds on GitHub. Note: PerconaLabs and Percona-QA are open source GitHub repositories for unofficial scripts and tools created by Percona staff. While not covered by Percona support or services agreements, these handy utilities …

Performance

Four Ways MySQL Executes GROUP BY

In this blog post, I’ll look into four ways MySQL executes GROUP BY.  In my previous blog post, we learned that indexes or other means of finding data might not be the most expensive part of query execution. For example, MySQL GROUP BY could potentially be responsible for 90% or more of the query execution time.  …

Performance

Using MySQL 5.7 Generated Columns to Increase Query Performance

  In this blog post, we’ll look at ways you can use MySQL 5.7 generated columns (or virtual columns) to improve query performance. Introduction About two years ago I published a blog post about Generated (Virtual) Columns in MySQL 5.7. Since then, it’s been one of my favorite features in the MySQL 5.7 release. The reason …