by Vadim Tkachenko | Oct 25, 2013 | MySQL, Percona Software
We just announced Percona Server 5.6.14 release, and I decided to make this build with the TokuDB 7.1 engine. The build is available here in the TESTING area. You are welcome to play with these binaries, but keep in mind: This is an experimental build and not supposed...
by Leif.Walsh | Oct 24, 2013 | MySQL
Getting ready for tomorrow’s MongoDB Boston conference (come say hi if you see us!), I’m spending some time thinking about a post last week by Bryce Nyeggen: The Genius and Folly of MongoDB. It hits home in a lot of ways for me and the whole TokuMX team, because it...
by Hrvoje Matijakovic | Oct 24, 2013 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.14-62.0 on October 24th, 2013 (Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.14, including all the bug fixes in it, Percona Server 5.6.14-62.0 is the current GA...
by Rich.Prohaska | Oct 23, 2013 | MySQL
While integrating TokuDB into MySQL 5.6, we found that MySQL 5.6 does not support more than one XA storage engine. For example, there is an assert in the ha_recover function that fires when the total number of XA storage engines is greater than one. After disabling...
by Yves Trudeau | Oct 23, 2013 | Insight for DBAs, MySQL, Percona Software
The technologies allowing to build highly-available (HA) MySQL solutions are in constant evolution and they cover very different needs and use cases. In order to help people choose the best HA solution for their needs, we decided, Jay Janssen and I, to publish, on a...
by Alexander Rubin | Oct 23, 2013 | MySQL, Percona Events, Percona Live
The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features: Opening keynote highlights MySQL 5.6 new features....
by Michael Rikmas | Oct 22, 2013 | Insight for DBAs, MySQL
In the very early days of Percona, Vadim wrote very nice post about MySQL GROUP_CONCAT (GROUP_CONCAT). But I want to show you a bit more about it. When is MySQL GROUP_CONCAT useful? Usually while working with Support customers I recommend it when you have aggregation...
by Stephane Combaudon | Oct 22, 2013 | MongoDB, MySQL
We already discussed one to one relations in MongoDB, and the main conclusion was that you should design your collections according to the most frequent access pattern. With one to many relations, this is still valid, but other factors may come into play. Let’s...
by Stewart Smith | Oct 22, 2013 | MySQL, Percona Events
Percona is glad to announce the release of Percona Playback 0.7 for MySQL on October 22nd, 2013. Downloads are available from our download site and Percona Software Repositories. Percona Playback for MySQL is a tool for replaying the load of one database server to...
by Stephane Combaudon | Oct 21, 2013 | MySQL, Webinars
On Wednesday I’ll be leading a webinar exploring MySQL 5.6’s new replication features. And yes, as usual I’ll deliver news on the good, the bad and the ugly (that is to say the benefits, limitations and challenges). The webinar, appropriately titled, “New...
by Alexander Rubin | Oct 21, 2013 | MySQL
Geo-enabled (or location-enabled) applications are very common nowadays and many of them use MySQL spatial functions. The common tasks for such applications are: Find all points of interests (i.e. coffee shops) around (i.e. a 10-mile radius) the given location...
by Tim.Callaghan | Oct 18, 2013 | MySQL
Tokutek is pleased to announce today’s release of TokuMX v1.3. The goal of this release was to bring full MongoDB v2.4 compatibility (with the noted exception of Text Search and Geospatial Indexes). The initial release of TokuMX was based on MongoDB v2.2, but...
by Ovais Tariq | Oct 18, 2013 | Insight for DBAs, MySQL
Each day there is probably work done to improve performance of the InnoDB storage engine and remove bottlenecks and scalability issues. Hence there was another one I wanted to highlight: Scalability issues due to tables without primary keys This scalability issue is...
by Hrvoje Matijakovic | Oct 17, 2013 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Toolkit 2.2.5 on October 17th, 2013 (Downloads are available here and from the Percona Software Repositories). This release is the current GA (Generally Available) stable release in the 2.2 series. New Features:...
by Jay Janssen | Oct 17, 2013 | MySQL
Checking throughput with async MySQL replication Replication throughput is the measure of just how fast the slaves can apply replication (at least by my definition). In MySQL async replication this is important to know because the single-threaded apply nature of...
by Dave Rosenlund | Oct 16, 2013 | MySQL
Tokutek is proud to be a sponsor of the MongoDB Boston 2013 event in Boston next Friday, October 25. The annual one-day conference is dedicated to MongoDB and is featuring all new advanced sessions this year. A few things to look forward to according to...
by Rich.Prohaska | Oct 16, 2013 | MySQL
I am developing a concurrent application that uses TokuDB to store its database. Sometimes, one of my SQL statements returns with a ‘lock wait timeout exceeded’ error. How do I identify the cause of this error? First, I need to understand a little bit...
by Jervin Real | Oct 16, 2013 | Insight for DBAs, MySQL
Here’s a problem some or most of us have encountered. You have a latin1 table defined like below, and your application is storing utf8 data to the column on a latin1 connection. Obviously, double encoding occurs. Now your development team decided to use utf8...
by Jay Janssen | Oct 15, 2013 | MySQL
Percona XtraDB Cluster (PXC) itself manages quorum and node failure. Minorities of nodes in a network partition situation will move themselves into a Non-primary state and not allow any DB activity. Nodes in such a state will be easily detectable via SHOW GLOBAL...
by Tim.Callaghan | Oct 14, 2013 | MySQL
Today we released TokuDB v7.1, which includes the following important features and fixes: Added ability for users to view lock information via information_schema.tokudb_trx, information_schema.tokudb_locks, and information_schema.tokudb_lock_waits tables. Changed the...
