by Mike Benshoof | Jun 24, 2013 | Insight for DBAs, MySQL
Statement-based or row-based, or mixed? We’ve all seen this discussed at length so I’m not trying to rehash tired arguments. At a high level, the difference is simple: Statement based replication (SBR) replicates the SQL statements to the slave to be...
by Roman Vynar | Jun 22, 2013 | Insight for DBAs, Insight for Developers, MySQL
There are different articles on how to setup MySQL with SSL but it’s sometimes difficult to end up with a good simple one. Usually, setting up MySQL SSL is not really a smooth process due to such factors like “it’s not your day”, something is...
by Jay Janssen | Jun 21, 2013 | MySQL, Percona Software
Async and PXC A common question I get about Percona XtraDB Cluster is if you can mix it with asynchronous replication, and the answer is yes! You can pick any node in your cluster and it can either be either a slave or a master just like any other regular MySQL...
by Martin.FarachColton | Jun 19, 2013 | MySQL
Tokutek is known for its full-featured fast-indexing technology. MongoDB is known for its great document-based data model and ease of use. TokuMX, version 1.0, combines the best of both worlds. So what, exactly, is TokuMX? The simplest (but incomplete) answer is that...
by Peter Zaitsev | Jun 19, 2013 | MySQL
In many environments MySQL is not the only technology used to store in-process data. Quite frequently, especially with large-scale or complicated applications, we use MySQL alongside other technologies for certain tasks of reporting, caching as well as main data-store...
by Jay Janssen | Jun 18, 2013 | Percona Events, Percona Software
Percona XtraDB Cluster (PXC) was released over a year ago and since then there has been tremendous interest and adoption. There’s plenty of talks that explain the fundamentals of PXC, but we’re starting to reach a threshold where it’s easier to find...
by Dave Rosenlund | Jun 17, 2013 | MySQL
We managed to reduce the database size from over 120Gb to just 53Gb. This matters because it means faster reading, less RAM usage, more space for more posts, and faster, lighter backups. The performance improvement is astonishing, and we’re basically running on stock...
by Raghavendra | Jun 17, 2013 | MySQL, Percona Software
The aim of this post is to enumerate real-world usage of Percona XtraDB Cluster (PXC), and also to solicit use cases from the readers. One of the prominent usages in the production environment that we have come across (and our Percona consultants have assisted) is...
by Tom Diederich | Jun 14, 2013 | MySQL, Percona Live
If you attended last April’s Percona Live MySQL Conference and Expo in Santa Clara, you know it was a rare opportunity to learn from some of the most accomplished system architects and developers in the business. Now it’s time to give back. The call for papers (CFP)...
by Peter Zaitsev | Jun 12, 2013 | MySQL, Percona Events, Percona Services
We’re less than a week away from Percona MySQL University at Portland, Oregon next Monday, June 17. The latest in a series of FREE one-day educational events, we are pleased to feature 10 technical talks by members of Team Percona as well as local members of the...
by Martin.FarachColton | Jun 11, 2013 | MySQL
As promised, the Enterprise Edition of TokuDB®, Version 7, is ready. TokuDB Version 7, Enterprise Edition, introduces Hot Backup. You can now back up all your TokuDB tables directly from MySQL or MariaDB, with no down time. In addition, TokuDB Enterprise Edition comes...
by Peter Boros | Jun 11, 2013 | MySQL, Percona Events
MySQL can be deployed in several ways, and that means you can choose a tailor-made path that best meets your needs. With simple services or development systems, many people are using a single server with some backups configured, and then simply take the downtime when...
by Hrvoje Matijakovic | Jun 10, 2013 | MySQL, Percona Software
Percona is glad to announce the release of Percona Server 5.1.69-14.7 on June 10, 2013. A drop in replacement for MySQL, downloads are available here and from the Percona Software Repositories. Based on MySQL 5.1.69, this release will include all the bug fixes in it....
by Mike Benshoof | Jun 10, 2013 | Insight for DBAs, MySQL
Recently, I was working with a client that asked about using Percona Xtrabackup to take a snapshot of a particular MySQL schema and then reload it with a different schema name on the same server. It caught me off guard because I’d never really thought about it...
by Ernie Souhrada | Jun 7, 2013 | Insight for DBAs, Insight for Developers, MySQL, Webinars
Thanks to everyone who was in attendance on 05 June 2013 for my “Choosing a MySQL HA Solution” webinar. If you weren’t able to make it but are interested in listening to the presentation, it’s currently up and available for viewing over at...
by David Hildebrandt | Jun 7, 2013 | MySQL
During the Percona Live MySQL Community Event this year we had the pleasure of Alexei Rodriguez discussing why Evernote uses Percona’s Private Custom MySQL Training. Alexei is VP of operations there and you can watch a video of his presentation on YouTube....
by Tim.Callaghan | Jun 6, 2013 | MySQL
Tokutek created the iiBench benchmark back in 2008. The point of the benchmark is to measure the performance of indexed insertions over time. It uses an extremely simple schema, one table with a sequential insertion pattern for the primary key along with three integer...
by David Hildebrandt | Jun 6, 2013 | MySQL
Now that June has arrived it is time to plan what you will do over the summer months. In addition to your summer vacation plans, give thought to MySQL training for you and your team. Summer is the time to brush up on those critical skills needed to ensure all systems...
by Michael Coburn | Jun 4, 2013 | Insight for DBAs, Insight for Developers, MySQL
Lately I have been working with a set of customers on a longer term basis which has given me time to explore new tools using their environments. One tool that I am finding very helpful is called SchemaSpy. SchemaSpy is a Java-based tool (requires Java 5 or higher)...
by Zardosht.Kasheff | Jun 3, 2013 | MySQL
Over several blog posts, Tim has presented performance results on large data sets of TokuMX, our MongoDB product with fractal tree indexes integrated, side by side with MongoDB. Results look good. We’ve shown improved throughput numbers on a sysbench benchmark,...
