by Vadim Tkachenko | Aug 28, 2013 | Benchmarks, Hardware and Storage
While working on the service architecture for one of our projects, I considered several SATA SSD options as the possible main storage for the data. The system will be quite write intensive, so the main interest is the write performance on capacities close to full-size...
by Hrvoje Matijakovic | Aug 27, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.1.71-14.9 on August 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.1.71, including all the bug fixes in it, Percona Server 5.1.71-14.9 is now the...
by Hrvoje Matijakovic | Aug 27, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.33-31.1 on August 27th, 2013 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.33, including all the bug fixes in it, Percona Server 5.5.33-31.1 is now the...
by Ernie Souhrada | Aug 26, 2013 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Thanks to everyone who attended last week’s webinar on MySQL security; hopefully you’ve all gone out and set SELinux to enforcing mode if you weren’t already running that way. If you weren’t able to attend, the recording and slides are...
by Ryan Lowe | Aug 21, 2013 | Cloud, MySQL, Webinars
One longstanding complaint I have heard for the past several years, and still hear today, is that Amazon’s Relational Database Service (RDS) does not allow the configuration flexibility as running MySQL in an ec2 instance. While true, this ignores the consistent...
by Miguel Angel Nieto | Aug 20, 2013 | Insight for DBAs, MySQL, Percona Services, Percona Software
We often receive this question about the ibdata1 file in MySQL at Percona Support. The panic starts when the monitoring server sends an alert about the storage of the MySQL server – saying that the disk is about to get filled. After some research, you realize...
by Peter Zaitsev | Aug 17, 2013 | MySQL
MySQL 5.6 surely changes the game when it comes to security vs ease of use. Before MySQL 5.6 we would get default MySQL installation being pretty insecure – the user “root” will be created with no password as well as anonymous user with limited...
by Jay Janssen | Aug 16, 2013 | Insight for DBAs, MySQL, Webinars
My colleague and teammate Ernie Souhrada will be presenting a webinar on Wednesday, August 21, 2013 at 10 a.m. PDT titled “MySQL Security: Armoring Your Dolphin.” This is a popular topic with news breaking routinely that yet another Internet company has...
by Zardosht.Kasheff | Aug 15, 2013 | MySQL
A common MongoDB tip is to create short field names to save storage space. Because MongoDB does not compress its data on disk and stores field names in each document, using longer field names leads to bigger documents which leads to more storage space usage. The...
by Peter Zaitsev | Aug 15, 2013 | Insight for DBAs, Insight for Developers, MySQL, Percona Events
Following our events earlier this year in Raleigh, Montevideo, Buenos Aires, Toronto and Portland, we bring Percona University to Washington, D.C. on September 12. This free one-day technical education event will cover many MySQL ecosystem technologies, including:...
by Jaime Sicam | Aug 14, 2013 | MySQL
Percona Server is bundled with the PAM plugin which opens a plethora of ways to authenticate to MySQL such as restricting time when users can connect to MySQL, authenticate via a USB key, authenticate to an external authentication system such as LDAP and many, many...
by Nilnandan Joshi | Aug 12, 2013 | MySQL, Percona Software
Percona Toolkit’s pt-archiver is one of the best utilities to archive the records from large tables to another tables or files. One interesting thing is that pt-archiver is a read-write tool. It deletes data from the source by default, so after archiving you...
by Peter Zaitsev | Aug 11, 2013 | MySQL
When we started Percona about 7 years ago one of the ideas behind the business was to provide customer focused services, which I refereed to as “bias free” at the time. What do I mean by customer focused services ? Is not this something most of the company...
by Hrvoje Matijakovic | Aug 9, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.1.4 on August 9th, 2013. Downloads are available from our download site here and Percona Software Repositories. This release is the current GA (Generally Available) stable release in the 2.1 series....
by Fernando Ipar | Aug 9, 2013 | MySQL, Percona Software, Webinars
I’m happy to announce that the recording for my recent webinar “5 Proactive Measures to Minimize MySQL Downtime” is now available, along with the slides. They can both be found here. My webinar focused on the top 5 operational measures that prevent...
by Alexander Rubin | Aug 8, 2013 | MySQL
I will be talking about Big Data with MySQL and Hadoop at MySQL Connect 2013 (Sept. 21-22) in San Francisco as well as at Percona University at Washington, DC (September 12, 2013). Apache Hadoop is a very popular Big Data solution and we can nowadays easily integrate...
by Leif.Walsh | Aug 7, 2013 | MySQL
Recently, we’ve seen a few people ask us about building TokuMX from scratch. While it’s best if you just use the binaries you can get from us (they have all the right optimizations, we’ve tested them, and we can interpret coredumps they generate), we...
by Stewart Smith | Aug 7, 2013 | MySQL, Webinars
Good news everyone! I recently presented a webinar: Percona Server 5.6: Enterprise Grade MySQL. It was also recorded so you can watch along or view the slide deck. As with all my talks, I am not simply reading the slides so it really is worth to listen to the audio...
by David Hildebrandt | Aug 5, 2013 | MySQL, Percona Live, Percona Services
Senior MySQL DBA John Cesario of Go Daddy spoke at Percona Live in April and shared his views on Percona MySQL Training. Here’s what he had to say: “Go Daddy is passionate about helping our customers. Percona Innodb training gives us another tool to...
by Zardosht.Kasheff | Aug 2, 2013 | MySQL
On Wednesday night, the Boston MongoDB User group was kind enough to have me speak about TokuMX Internals. I spoke about Fractal Tree® indexes and the technical reasons behind the benefits they provide to MongoDB applications. Although the talk mostly references...
