by Yves Trudeau | Jul 13, 2016 | Hardware and Storage, Insight for DBAs, MySQL
Over the last year, the Ceph world drew me in. Partly because of my taste for distributed systems, but also because I think Ceph represents a great opportunity for MySQL specifically and databases in general. The shift from local storage to distributed storage is...
by David Murphy | Jul 12, 2016 | MySQL
Want to become one of the Percona Live Europe MongoDB speakers? Read this blog for details. The Percona Live Europe, Amsterdam call for papers is ending soon and we are looking for MongoDB speakers! This is a great way to build your personal and company brands. It...
by Alexey Zhebel | Jul 12, 2016 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.0.12-1.8 on July 12, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.0.12-1.8 is an enhanced, open source, fully compatible,...
by Dave Avery | Jul 11, 2016 | MySQL
Please join Sveta Smirnova for a webinar Thursday, July 14 at 10 am PDT (UTC-7) on an Introduction Into Storage Engine Troubleshooting. The number of MySQL storage engines provide great flexibility for database users, administrators and developers. At the same time,...
by Hrvoje Matijakovic | Jul 8, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.5.50-38.0 on July 8, 2016. Based on MySQL 5.5.50, including all the bug fixes in it, Percona Server 5.5.50-38.0 is now the current stable release in the 5.5 series. Percona Server is open-source and free. Details of...
by Hrvoje Matijakovic | Jul 8, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona XtraBackup 2.3.5 on July 8, 2016. 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 with large...
by Hrvoje Matijakovic | Jul 7, 2016 | MySQL, Percona Events, Percona Software
Percona announces the release of Percona Server 5.6.31-77.0 on July 7th, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Based on MySQL 5.6.31, including all the bug fixes in it, Percona Server 5.6.31-77.0 is the...
by Alexander Rubin | Jul 6, 2016 | MySQL
by Hrvoje Matijakovic | Jul 6, 2016 | MySQL, Percona Events, Percona Software
Percona announces the GA release of Percona Server 5.7.13-6 on July 6, 2016. Download the latest version from the Percona web site or from the Percona Software Repositories. Based on MySQL 5.7.13, including all the bug fixes in it, Percona Server 5.7.13-6 is the...
by Roel Van de Paar | Jul 5, 2016 | MySQL
If you haven’t heard the news yet, MySQL 8.0 is apparently the next release of the world-famous database server. Obviously abandoning plans to name the next release 5.8, Percona Server’s upstream provider relabelled all 5.8-related bugs to 8.0 as follows:...
by Alexander Rubin | Jul 5, 2016 | MySQL
In this post, I’ll discuss how MySQL 5.7 handles UTF8MB4 and the load data infile. Many of my clients have told me that they do not like using the LOAD DATA INFILE statement and prefer to manually parse and load the data. The main reason they do it are issues...
by Miguel Angel Nieto | Jul 1, 2016 | Cloud, MySQL
In this blog post, I discuss some of the insights needed when using Amazon RDS and pt-online-schema-change together. The pt-online-schema-change tool runs DDL queries (ALTER) online so that the table is not locked for reads and writes. It is a commonly used tool by...
by Manjot Singh | Jun 30, 2016 | Insight for DBAs, MySQL, Percona Software
This article discusses how to salvage a crashed pt-online-schema-change by leveraging pt-archiver and executing queries to ensure that the data gets accurately migrated. I will show you how to continue the data copy process, and how to safely close out the...
by Shahriyar Rzayev | Jun 29, 2016 | MySQL, Percona Events
In this post, I’ll share my experience attending the annual MySQL User Group Leaders Summit in Bucharest, Romania. The MySQL User Group Leaders Summit gathers together as many of the global MySQL user group leaders as possible. At the summit, we discuss further...
by Alexey Zhebel | Jun 29, 2016 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.2.7-1.1 on June 29, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.2.7-1.1 is an enhanced, open-source, fully compatible,...
by Dave Avery | Jun 27, 2016 | MySQL, Percona Software
Please join Jay Janssen for the webinar Percona XtraDB Cluster Reference Architecture Wednesday, June 29 at 10:00 AM PDT (UTC- 7). A reference architecture shows a typical, common, best-practice deployment of a system with all the surrounding infrastructure. In the...
by Vadim Tkachenko | Jun 27, 2016 | MySQL
In this blog, I will discuss how parallel crash recovery in MySQL benefits several processes. I recently filed an Oracle feature request to make crash recovery faster by running in multiple threads. This might not seem very important, because MySQL does not crash that...
by Alexey Zhebel | Jun 24, 2016 | MySQL, Percona Events, Percona Software
Percona announces the availability of Percona Toolkit 2.2.18, released on June 24, 2016. Percona Toolkit is a collection of advanced command-line tools to perform a variety of MySQL server and system tasks that are too difficult or complex for DBAs to perform...
by Alexey Zhebel | Jun 24, 2016 | MongoDB, Percona Events, Percona Software
Percona announces the release of Percona Server for MongoDB 3.0.12-1.7 on June 24, 2016. Download the latest version from the Percona web site or the Percona Software Repositories. Percona Server for MongoDB 3.0.12-1.7 is an enhanced, open source, fully compatible,...
by Alexander Rubin | Jun 23, 2016 | MySQL
In this blog series, I will share my experiences as I migrate commercial databases (i.e., Microsoft SQL or Oracle) to open source (MySQL). More specifically, we will look at how you can migrate from MS SQL Server to MySQL. For this first blog post I’ve chosen...
