by Peter Zaitsev | May 28, 2015 | MongoDB
If you can make it to Manhattan next Monday, please join me at the MongoDB Community Open House. The June 1 event is free and open to all. It runs from 3:30-6:30 p.m. just across the road from MongoDB World. The MongoDB Community Open House, held at the New York...
by Hrvoje Matijakovic | May 28, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.2.11 on May 28, 2015. Downloads are available from our download site or Percona Software Repositories. Percona XtraBackup enables MySQL backups without blocking user queries, making it ideal for companies...
by Muhammad Irfan | May 27, 2015 | MySQL, Percona Services
The other day I was discussing new features of MySQL 5.7 with a Percona Support customer. After that conversation, I thought it would be a good idea to compile list of important features of MySQL 5.7. The latest MySQL 5.7.6 release candidate (RC) is out and is packed...
by Stephane Combaudon | May 26, 2015 | MongoDB
Storing time-series data is a frequent pattern for databases – be it for logs or for any kind of monitoring. Such data has the following properties: records are inserted but also never updated, the insertion rate can be high and records are likely to expire...
by David Bennett | May 22, 2015 | Benchmarks, MongoDB
“There’s no benchmark for how life’s “supposed” to happen. There is no ideal world for you to wait around for. The world is always just what it is now, it’s up to you how you respond to it.” ― Isaac Marion, Warm Bodies At one time or...
by Hrvoje Matijakovic | May 20, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona XtraBackup 2.3.1-beta1 on May 20th 2015. Downloads are available from our download site here. This BETA release, will be available in Debian testing and CentOS testing repositories. This is an BETA quality release and...
by David Busby | May 18, 2015 | MySQL, Security
We have recently become a member of oCERT to aid in allowing responsible disclosure for Percona products and services as can be seen on their members page. We are presently working on the verbiage for the responsible disclosure program, and we are also investigating...
by Roel Van de Paar | May 15, 2015 | Insight for DBAs, Insight for Developers, MySQL, Percona Services, Percona Software
Welcome to MySQL QA Episode 2: Build a MySQL Server – Git, Bazaar (bzr), Compiling, and Build Tools In this episode you’ll learn how to build Percona Server and/or MySQL Server for QA purposes & more in this short 25 minute tutorial. In HD quality (set...
by Hrvoje Matijakovic | May 8, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.24-72.2 on May 8, 2015. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.6.24, including all the bug fixes in it, Percona Server 5.6.24-72.2...
by Hrvoje Matijakovic | May 8, 2015 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.43-37.2 on May 8, 2015. Based on MySQL 5.5.43, including all the bug fixes in it, Percona Server 5.5.43-37.2 is now the current stable release in the 5.5 series. Percona Server is open-source and free....
by Vadim Tkachenko | May 8, 2015 | MongoDB, MySQL
While our engineering team is working on finalizing the TokuMXse storage engine, I want to provide an experimental build that you can try and test MongoDB 3.0 with our storage engine. It is available here...
by Stephane Combaudon | May 8, 2015 | Insight for DBAs, MySQL
We discussed in an earlier post how to design indexes for many types of queries using a single table. Here is a real-world example of the challenges you will face when trying to optimize queries: two similar queries, but one is performing a full table scan while the...
by Alexey Zhebel | May 7, 2015 | MySQL, Percona Software
For those PCT users who forget to regularly check query performance, you can now get server query reports delivered to your email daily or weekly. The report contains a digest of the most critical performance information related to a particular MySQL instance,...
by David Busby | May 6, 2015 | MySQL, Security
Contents Summary Analysis Mitigating factors P.O.C Acknowledgments Summary During a code audit performed internally at Percona, we discovered a viable information disclosure attack when coupled with a MITM attack in which percona-toolkit and xtrabackup perl components...
by Tom Diederich | May 6, 2015 | MySQL, Percona Events
Percona CEO Peter Zaitsev and Big Data guru Alexander Rubin will be speaking at Meetups along the East Coast next week with stops in Boston (May 11), New York City (May 12), Philadelphia (May 13) and Baltimore (May 14). Dubbed the “MySQL Whistle-Stop Tour” since...
by Stephane Combaudon | May 5, 2015 | MySQL
Being schemaless is one of the key features of MongoDB. On the bright side this allows developers to easily modify the schema of their collections without waiting for the database to be ready to accept a new schema. However schemaless is not free and one of the...
by Francisco Bordenave | May 4, 2015 | Insight for DBAs, MariaDB, MySQL
MySQL replication isn’t perfect and sometimes our data gets out of sync, either by a failure in replication or human intervention. We are all familiar with Percona Toolkit’s pt-table-checksum and pt-table-sync to help us check and fix data inconsistencies...
by Vadim Tkachenko | May 1, 2015 | Benchmarks, MySQL
An idea for a benchmark based on the “arrival request” rate that I wrote about in a post headlined “Introducing new type of benchmark” back in 2012 was implemented in Sysbench. However, Sysbench provides only a simple workload, so to be able to...
by Sveta Smirnova | Apr 30, 2015 | Insight for DBAs, MySQL, Percona Live
In version MySQL 5.7.7 Oracle presented a new promising feature: optimizer hints. However it did not publish any documentation about the hints. The only note which I found in the user manual about the hints is: It is now possible to provide hints to the optimizer by...
by Alexander Rubin | Apr 29, 2015 | MySQL
About 2 weeks ago Oracle published the MySQL 5.7.7-labs-json version which includes a very interesting feature called “Generated columns” (also know as Virtual or Computed columns). MariaDB has a similar feature as well: Virtual (Computed) Columns. The...
