EmergencyEMERGENCY? Get 24/7 Help Now!

Percona Server 5.7.10-2 second RC available

 | February 8, 2016 |  Posted In: Events and Announcements, MySQL, Percona Server for MySQL, Percona Software, TokuDB

Percona Server

Percona is glad to announce the second release candidate of Percona Server 5.7.10-2 on February 8, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.7.10, including all the bug fixes in it, Percona Server 5.7.10-2 is the current Release Candidate release in the Percona Server 5.7 series. […]

Read More

Percona XtraBackup 2.4.0-rc1 is now available

 | February 8, 2016 |  Posted In: MySQL

Percona XtraBackup

Percona is glad to announce the first release candidate of Percona XtraBackup 2.4.0-rc1 on February 8th 2016. Downloads are available from our download site and from apt and yum repositories. This is a Release Candidate quality release and it is not intended for production. If you want a high quality, Generally Available release, the current […]

Read More

MySQL 5.7: Introduction for Operational DBAs

 | February 8, 2016 |  Posted In: MySQL

Join us Tuesday, February 16, 2016 9:00am PST (UTC-8) for a webinar on the operational and monitoring features of MySQL 5.7 with Percona CEO Peter Zaitsev. MySQL 5.7 is a great release, providing valuable features for both daily operations and ongoing development. In this, part two of our ongoing 5.7 webinar series, we will look […]

Read More

Measuring Percona Server Docker CPU/network overhead

 | February 5, 2016 |  Posted In: Docker, MySQL, Percona Server for MySQL

Docker

Now that we have our Percona Server Docker images, I wanted to measure the performance overhead when we run the database in the container. Since Docker promises to use a lightweight container, in theory there should be very light overhead. We need to verify that claim, however. In this post I will show the numbers for CPU and network intensive workloads, […]

Read More

MySQL password expiration features to help you comply with PCI-DSS

 | February 4, 2016 |  Posted In: Security

PCI Compliance (section 8.2.4) requires users to change password every 90 days. Until MySQL 5.6.6 there wasn’t a built-in way to comply with this requirement. Since MySQL version 5.6.6 there’s a password_expired feature which allows to set a user’s password as expired. This has been added to the mysql.user table and its default value it’s […]

Read More

New GIS Features in MySQL 5.7

 | February 3, 2016 |  Posted In: MySQL

MySQL GROUP_CONCAT

MySQL 5.7 has been released, and there are some exciting new features now available that I’m going to discuss in this blog — specifically around geographic information system (GIS). I’ve used GIS features in MySQL for a long time. In my previous blog entries I’ve shown how to create geo-enabled applications with MySQL 5.6 and use MySQL 5.6 […]

Read More

Percona Live Crash Courses: for MySQL and MongoDB!

 | February 2, 2016 |  Posted In: Percona Live

Percona Live Crash Courses for MySQL and MongoDB The database community constantly tells us how hard it is to find someone with MySQL and MongoDB DBA skills who can help with the day-to-day management of their databases. This is especially difficult when companies don’t have a full-time requirement for a DBA. Developers, system administrators and IT staff […]

Read More

Experimental Percona Docker images for Percona Server

 | February 2, 2016 |  Posted In: Docker, MySQL, Percona Server for MySQL

Docker

Docker is incredibly popular tool for deploying software, so we decided to provide a Percona Docker image for both Percona Server MySQL and Percona Server for MongoDB. We want to create an easy way to try our products. There are actually some images available from https://hub.docker.com/_/percona/, but these images are provided by Docker itself, not from Percona. […]

Read More

InnoDB and TokuDB on AWS

 | February 1, 2016 |  Posted In: Benchmarks, InnoDB, TokuDB

In a recent post, Vadim compared the performance of Amazon Aurora and Percona Server on AWS. This time, I am comparing write throughput for InnoDB and TokuDB, using the same workload (sysbench oltp/update/update_non_index) and a similar set-up (r3.xlarge instance, with general purpose ssd, io2000 and io3000 volumes) to his experiments. All the runs used 16 threads for sysbench, and the following […]

Read More