by Frederic Descamps | Sep 18, 2013 | MySQL, Percona Events
I will be in Prato (Firenze), Italy Thursday and Friday (September 19th and 20th) to deliver 2 presentations at OSS4B: Installing and managing MySQL like a real devops: automation in production Introduction to Percona XtraDB Cluster If you want to learn about these...
by Ignacio Nin | Sep 17, 2013 | Insight for DBAs, MySQL
One type of question we get very often (even in the form of filed bugs!) is how to switch from stock MySQL to Percona Server or switch from Percona Server 5.5 to Percona XtraDB Cluster using yum, but à la apt-get, i.e. having yum handle the replace. In its simplest...
by Roman Vynar | Sep 16, 2013 | Insight for DBAs, MySQL
Working day to day with Percona Remote DBA customers, we have been facing an issue from time to time when MySQL replication lag is flapping between 0 and XXXXX constantly – i.e. Seconds_Behind_Master is 0 for a few secs, then it’s like 6287 or 25341, again...
by Stephane Combaudon | Sep 13, 2013 | Insight for DBAs, MySQL
Being able to configure slaves to be crash-safe is one of the major improvements of MySQL 5.6 with regards to replication. However we noticed confusion on how to enable this feature correctly, so let’s clarify how it should be done. In short 1. Stop MySQL on...
by Christian.Rober | Sep 12, 2013 | MySQL
There are multiple ways to backup a MySQL database. Some are more painful than others. In this two part blog we are going to discuss why the new hot backup system in TokuDB is special amidst the existing solutions. First let’s look at existing backup solutions for...
by Justin Swanhart | Sep 12, 2013 | MySQL, Webinars
Join me Wednesday, September 18 at 10 a.m. PDT for an hour-long webinar where I will introduce the basic concepts behind column store technology. The webinar’s title is: “Introduction to open source column stores.” What will be discussed? This...
by Vadim Tkachenko | Sep 12, 2013 | MySQL, Percona Software
While we are working hard on the final push of Percona Server 5.6 GA (I know that many people are waiting on this, but stay with us – we want to ensure that we have a quality release with great performance), I decided to make an experimental build of Percona...
by Nickolay Ihalainen | Sep 11, 2013 | Insight for DBAs, MySQL
This post focuses on the problem of the InnoDB log sequence number being in the future. Preface: What is an InnoDB log sequence number? The log sequence number (LSN) is an important database parameter used by InnoDB in many places. The most important use is for crash...
by Tim.Callaghan | Sep 10, 2013 | MySQL
In talking to existing MongoDB users and TokuMX evaluators, I’ve often heard that the performance of MongoDB is very good as long as your working data set fits in RAM. The story continues that if your working data set grows to be larger than the RAM on your...
by Ryan Lowe | Sep 10, 2013 | Insight for DBAs, Insight for Developers, MySQL
The other day I was running pt-duplicate-key-checker on behalf of a customer and noticed some peculiar recommendations on an InnoDB table with an odd structure (no PRIMARY key, but multiple UNIQUE constraints). This got me thinking about how InnoDB promotes UNIQUE...
by Peter Zaitsev | Sep 9, 2013 | MySQL, Percona Events
Now with summer winding down and school back in session, we get into a very busy time with many great opportunities to discover more about MySQL with several excellent MySQL events. At first I wanted to cover all autumn events here but if I did that this post would be...
by George O. Lorch III | Sep 6, 2013 | Percona Software, Webinars
Percona XtraBackup 2.1 has been in GA now for a little over four months and has some impressive new features to improve backup performance, security, and storage requirements. When used with Percona Server, additional features are enabled that can provide even more...
by Tom Diederich | Sep 6, 2013 | MySQL, Percona Live
The Sept. 8 deadline is looming to submit your speaker proposals for Percona Live London 2013’s conference breakout sessions and tutorial sessions. In addition to fame (and dare I say fortune?), if selected as a speaker by our amazing conference committee,...
by Tim.Callaghan | Sep 5, 2013 | MySQL
We’ve been hard at work on TokuMX since it’s initial release just over 2 months ago. Today we released TokuMX v1.2 which includes Hot Backup in the Enterprise Edition. Hot Backup allows users to create a backup of a running TokuMX primary or secondary...
by Vadim Tkachenko | Sep 5, 2013 | Benchmarks, MySQL
This post is a continuation of my research of TokuDB’s storage engine to understand if it is suitable for timeseries workloads. While inserting LOAD DATA INFILE into an empty table shows great results for TokuDB, what’s more interesting is seeing some...
by Aurimas Mikalauskas | Sep 5, 2013 | MySQL
MySQL 5.6 has a great many new features, including, but certainly not limited to a number of performance improvements. However, besides the widely talked-about features such as InnoDB support for full text search, optimizer, performance schema improvements and GTID,...
by Hrvoje Matijakovic | Sep 4, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.0.8 on September 4, 2013. Downloads are available from our download site here and Percona Software Repositories. Percona XtraBackup is the world’s only open-source, free MySQL hot backup software...
by Ryan Lowe | Sep 4, 2013 | Cloud, MySQL, Webinars
Thanks to everyone who attended last week’s webinar, Q: Would you recommend Amazon RDS over manually setting up MySQL/Percona server on an EC2 instance? A: This depends on many factors including your data set size, workload, uptime requirements, what the rest of your...
by Hrvoje Matijakovic | Sep 3, 2013 | Percona Events, Percona Software
Percona is glad to announce the third Release Candidate of Percona Server 5.6.13-60.5 (downloads are available here and from the Percona Software Repositories). The final release is almost ready. Thank you to everyone who has been testing and filing bugs. You’ve...
by Vadim Tkachenko | Aug 29, 2013 | Benchmarks, MySQL
I am working on a customer’s system where the requirement is to store a lot of timeseries data from different sensors. For performance reasons we are going to use SSD, and therefore there is a list of requirements for the architecture: Provide high insertion...
