by Sveta Smirnova | Jan 25, 2016 | Insight for DBAs, MySQL
by Dave Avery | Jan 22, 2016 | MySQL, Percona Events
Percona invites you to attend a webinar Wednesday, January 27th, with CEO Peter Zaitsev: Compression In Open Source Databases. Register now! Data growth has been tremendous in the last decade and shows no signs of stopping. To deal with this trend database...
by Kortney Runyan | Jan 22, 2016 | MariaDB, MongoDB, MySQL, Percona Events
The Percona Live Data Performance Conference 2016 is rapidly approaching, and we’re looking forward to providing an outstanding experience April 18-21 for all whom attend. Percona Live is the premier event for the rich and diverse open source community and businesses...
by Alexander Rubin | Jan 21, 2016 | MySQL
We’d like to thank everybody for joining us on January 7th for our “Tired of MySQL Making You Wait?” webinar with Percona’s Alexander Rubin, Principal Consultant and SolarWinds’ Janis Griffin, Database Evangelist. Too often developers and DBAs struggle to pinpoint the...
by Miguel Angel Nieto | Jan 19, 2016 | MySQL
Data corruption! It can happen. Maybe because of a bug or storage problem that you didn’t expect, or MySQL crashes when a page checksum’s result is different from what is expected. Either way, corrupted InnoDB data can and does occur. What do you do then?...
by Vadim Tkachenko | Jan 15, 2016 | Insight for DBAs, MySQL
This is a followup to my previous post Apache Spark with Air ontime performance data. To recap an interesting point in that post: when using 48 cores with the server, the result was worse than with 12 cores. I wanted to understand the reason is was true, so I started...
by David Busby | Jan 14, 2016 | MySQL, Security
Earlier today advisories were sent out regarding OpenSSH versions 5.4 through 7.1., informing users about a security bug in the software. In essence, the advisory instructed people to add the UseRoaming no option to their ssh_config file, with a promise for further...
by Peter Zaitsev | Jan 14, 2016 | MySQL
When I first discovered Graphite years ago, I was very impressed with its monitoring capabilities. Compared to many RRD-based tools that were popular at the time (like Cacti), Graphite separated the captured data and graphs, allowing you to do all kinds of math and...
by Dave Avery | Jan 11, 2016 | Cloud, MySQL
Enterprises’ demand flexibility, scalability and efficiency to keep up with the demands of their customers — while maintaining the bottom line. To solve this, they’re running to cloud infrastructure services to both cut costs and take advantage of...
by Vadim Tkachenko | Jan 7, 2016 | Benchmarks, Insight for DBAs, MySQL
There is a growing interest in Apache Spark, so I wanted to play with it (especially after Alexander Rubin’s Using Apache Spark post). To start, I used the recently released Apache Spark 1.6.0 for this experiment, and I will play with “Airlines On-Time...
by Emily Ikuta | Dec 30, 2015 | MySQL, Webinars
Too often developers and DBAs struggle to pinpoint the root cause of MySQL database performance issues, and then spend too much time in trying to fix them. Wouldn’t it be great to bypass wasted guesswork and get right to the issue? In our upcoming webinar Tired of...
by Kortney Runyan | Dec 29, 2015 | Cloud, Insight for DBAs, MongoDB, Percona Events, Percona Live
We are excited to announce that the tutorial schedule for the Percona Live Data Performance Conference 2016 is up! The schedule shows all the details for each of our informative and enlightening Percona Live tutorial sessions, including insights into InnoDB, MySQL...
by Przemysław Malkowski | Dec 21, 2015 | Insight for DBAs, MySQL, Percona Software
High Availability Have you ever wondered if your application should be able to work in read-only mode? How important is that question? MySQL seems to be the most popular database solution for web-based products. Most typical Internet application workloads consist of...
by Jervin Real | Dec 18, 2015 | Insight for DBAs, MySQL
Performance Schema In many types of database workloads, using a multi-threaded slave from 5.6+ helps improve replication performance. I’ve had a number of users enable this feature, but have not seen anyone ask how each thread is performing. Here’s a quick...
by Kortney Runyan | Dec 17, 2015 | Percona Events, Percona Live
On behalf of the Percona Live Conference Committee, I am excited to announce the sneak peek schedule for the Percona Live Data Performance Conference and Expo 2016! Percona Live Data Performance Conference and Expo Live 2016 will feature a variety of formal tracks and...
by Alexander Rubin | Nov 25, 2015 | Hardware and Storage, MySQL, Percona Software
Introduction In my last blog post, Internet of Things, Messaging and MySQL, I have showed how to start your own Internet of Things with Particle Photon board. That implementation is great, but requires constant internet (wi-fi) access as the Particle Photon board does...
by Miguel Angel Nieto | Nov 13, 2015 | MySQL
Recently we released an updated version of our Percona Toolkit with an important update for pt-online-schema-change if you use MySQL 5.6. A new parameter has been added, analyze-before-swap. What does it do? Let me explain it in more detail. A bug not a bug A customer...
by Max Bubenick | Nov 12, 2015 | MySQL
The new Mydumper 0.9.1 version, which includes many new features and bug fixes, is now available. You can download the code from here. A significant change included in this version now enables Mydumper to handle all schema objects!! So there is no longer a...
by Muhammad Irfan | Nov 4, 2015 | MySQL
MySQL 5.7 has a lot of enhancements and new features. I summarized this list previously in this blog post. Adding replication filters online is one of the MySQL 5.7 features described in this manual. However, I will describe and summarize a few examples in this blog...
by Yves Trudeau | Nov 2, 2015 | Insight for DBAs, MySQL, Percona Software
Recently, I happened to have an onsite engagement and the goal of the engagement was to move a database service to RDS Aurora. Like probably most of you, I knew the service by name but I couldn’t say much about it, so, I Googled, I listened to talks and I read...
