by Vadim Tkachenko | Sep 17, 2015 | MariaDB, MySQL, Percona Software
Recently Aphyr (Kyle Kingsbury) published https://aphyr.com/posts/327-call-me-maybe-mariadb-galera-cluster The article is technically valid, I am not going to dispute a conclusion Aphyr made, but it is also quite technically involved, so users who just jump to...
by Daniel Guzmán Burgos | Sep 16, 2015 | Insight for DBAs, MySQL, Webinars
Thanks to all who attended my webinar Introduction to MySQL SYS Schema. This blog is for me to address the extra questions I didn’t have time to answer on the stream. Can i have the performance_schema enabled in 5.6 and then install the sys schema? Or they are one and...
by Hrvoje Matijakovic | Sep 15, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.26-74.0 on September 15, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.26, including all the bug fixes in it, Percona Server...
by Stephane Combaudon | Sep 14, 2015 | MongoDB, MySQL, Security
Several reports we’re published in the news about how easy it is to access data stored in some NoSQL systems, including MongoDB. This is not surprising because security was rather relaxed in earlier versions of MongoDB . This post lists some of the common...
by Jay Janssen | Sep 14, 2015 | Insight for DBAs, MySQL
Thanks to all who attended my webinar last week on Writing Application Code for MySQL High Availability. This blog is for me to address the extra questions I didn’t have time to answer on the stream. What do you think about using Galera Cluster but writing to a...
by Hrvoje Matijakovic | Sep 10, 2015 | MongoDB, Percona Events, Percona Software
Percona is glad to announce the release of Percona TokuMX 2.0.2 on September 10th 2015. Downloads are available here and from the Percona Software Repositories. Based on MongoDB 2.4.10 including all the bug fixes in it, Percona TokuMX 2.0.2 is current GA release in...
by Kortney Runyan | Sep 10, 2015 | Percona Events
The countdown for the annual Percona Live Data Performance Conference and Expo in Europe continues with today’s announcement of our keynote speakers! This three-day conference focuses on the latest trends, news and best practices in the MySQL, NoSQL and data in the...
by Andrew Moore | Sep 10, 2015 | Insight for DBAs, MySQL, Percona Software
Auditing your database means tracking access and changes to your data and db objects. The Audit Log Plugin has been shipped with Percona Server since 5.5.37/5.6.17, for a little over 12 months. Prior to the Audit Log Plugin, you had to work in darker ways to achieve...
by David Ducos | Sep 9, 2015 | Benchmarks, MySQL, Percona Software
There are cases where we need to implement MySQL partitioning, or at least test if it is an option to solve an issue. However, how are we able to test it when the table on our production environment has hundreds of millions of rows, several composite indexes and/or...
by Stephane Combaudon | Sep 8, 2015 | MySQL, Percona Software
Percona Server 5.6.21+ and MySQL 5.7.8+ offer the super_read_only option that was first implemented in WebscaleSQL. Unlike read_only, this option prevents all users from running writes (even those with the SUPER privilege). Sure enough, this is a great feature, but...
by Tom Diederich | Sep 4, 2015 | MySQL, Percona Live
Facebook, with 1.49 billion monthly active users, is one of the world’s top MySQL users. Simon Martin, a production engineer on Facebook’s MySQL Infrastructure team, has been working with MySQL for most of his career, starting from 2 servers built out of spare...
by Andrew Moore | Sep 3, 2015 | MySQL
After some recent work with systemd I’ve realized it’s power and I can come clean that I am a fan. I realize that there are multitudes of posts out there with arguments both for and against systemd but let’s look at some nice ways to have systemd...
by Hrvoje Matijakovic | Sep 2, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.45-37.4 on September 2, 2015. Based on MySQL 5.5.45, including all the bug fixes in it, Percona Server 5.5.45-37.4 is now the current stable release in the 5.5 series. Percona Server is open-source and...
by Tom Diederich | Sep 1, 2015 | MySQL, Percona Live
Booking.com, one of the world’s leading e-commerce companies, helps travels book nearly 1 million rooms per night. Established in 1996, Booking.com B.V. guarantees the best prices for any type of property, from small, family-run bed and breakfasts to executive...
by Jay Janssen | Aug 31, 2015 | MySQL, Percona Software
There can be a lot of confusion and lack of planning in Percona XtraDB Clusters in regards to nodes becoming desynchronized for various reasons. This can happen a few ways: An IST or SST joining node catching up after a state transfer (Joined/Joining state) Using...
by Alexey Zhebel | Aug 28, 2015 | MySQL, Percona Events, Percona Software
Percona is pleased to announce the availability of Percona Toolkit 2.2.15. Released August 28, 2015. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to...
by Tom Diederich | Aug 26, 2015 | MongoDB, Percona Live
Say hello to David Murphy, lead DBA and MongoDB Master at ObjectRocket (a Rackspace company). David works on sharding, tool building, very large-scale issues and high-performance MongoDB architecture. Prior to ObjectRocket he was a MySQL/NoSQL architect at Electronic...
by Alexander Rubin | Aug 24, 2015 | MySQL, Webinars
Thank you for attending my July 22 webinar titled “Advanced Query Tuning in MySQL 5.6 and 5.7” (my slides and a replay available here). As promised here is the list of questions and my answers (thank you for your great questions). Q: Here is the explain...
by Miguel Angel Nieto | Aug 21, 2015 | MongoDB
Finding and removing unused indexes is a pretty common technique to improve overall performance of relational databases. Less indexes means faster insert and updates but also less disk space used. The usual way to do it is to log all queries’ execution plans and...
by Jay Janssen | Aug 20, 2015 | MySQL, Percona Software
State Snapshot Transfer (SST) at a glance PXC uses a protocol called State Snapshot Transfer to provision a node joining an existing cluster with all the data it needs to synchronize. This is analogous to cloning a slave in asynchronous replication: you take a full...
