by Peter Zaitsev | Mar 24, 2014 | Insight for DBAs, MySQL, Webinars
I’m looking forward to Wednesday’s joint webinar on MySQL clustering technologies with Matt Aslett, research director of data management and analytics over at 451 Research. We’ll be participating in a live, in-depth discussion of MySQL Clustering for...
by Zardosht.Kasheff | Mar 24, 2014 | MySQL
MongoDB replication has some great features. As I discussed in my last post, MongoDB’s crash safety design is very elegant. In addition to that, MongoDB has automatic failover, parallel slave replication, and prefetch threads on secondaries. The latter, as Mark...
by Alexander Rubin | Mar 24, 2014 | MySQL, Percona Live
In my previous post I’ve showed some new MySQL 5.6 features which can be very helpful when creating geo-enabled applications. In this post I will show how we can obtain open-source GIS data, convert it to MySQL and use it in our GEO-enabled applications. I will...
by Tim Sharp | Mar 21, 2014 | MySQL, Percona Software
Notes from the Newb. I’m relatively new to MySQL having come from the world of embedded micro-databases, and though I’m pretty familiar with a number of database systems, I’ve discovered that I have a lot to learn about MySQL. As a new member to the Percona team, I...
by Roman Vynar | Mar 21, 2014 | MySQL, Percona Events
Percona is glad to announce the release of Percona Monitoring Plugins 1.1.3. Changelog: * Introduced more secure location of PHP script configs to harden a Cacti setup * Addressed CVE-2014-2569 We have introduced a more secure location /etc/cacti/ for PHP script...
by Hrvoje Matijakovic | Mar 20, 2014 | Percona Events, Percona Software
Percona is glad to announce the new release of Percona XtraDB Cluster 5.6 on March 20th 2014. Binaries are available from downloads area or from our software repositories. Based on Percona Server 5.6.15-63.0 including all the bug fixes in it, Galera Replicator 3.4 and...
by Nilnandan Joshi | Mar 20, 2014 | Insight for DBAs, MySQL, Percona Software
Working as a Percona Support Engineer, every day we are seeing lots of issues related to MySQL replication. One very common issue is slave lagging. There are many reasons for slave lag but one common reason is that queries are taking more time on slave then master....
by Terry Erisman | Mar 19, 2014 | Insight for DBAs, MySQL, Percona Events, Percona Live
The Percona Live MySQL Conference 2014 is less than two weeks away, running April 1-4, and excitement is building for the great lineup of speakers, events, and networking opportunities it offers. This year’s conference also features the first-ever CentOS Dojo Santa...
by Roman Vynar | Mar 19, 2014 | Security
If you are using Percona Monitoring Plugins for Cacti, this article should be important to you. By default, the Cacti setup is closed from accessing from Web. Here is an excerpt from /etc/httpd/conf.d/cacti.conf: # httpd 2.4 Require host localhost # httpd 2.2 Order...
by Zardosht.Kasheff | Mar 18, 2014 | MySQL
At an extremely high level, replication in MongoDB and MySQL are similar. Both databases have exactly one machine, the primary (or master), that accepts writes from clients. With a single transaction (or atomic operation, in MongoDB’s case), the tables and oplog (or...
by Vadim Tkachenko | Mar 18, 2014 | MySQL, Percona Software
Two weeks ago we released
by Rich.Prohaska | Mar 17, 2014 | MySQL
What good is a zero-length character column in a MySQL table? A zero-length character column has type of ‘char(0)’. If it is nullable, then it can at least store one bit. If it is not nullable, then the value for this column in all rows is a null string....
by Hrvoje Matijakovic | Mar 17, 2014 | MySQL, Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.6.16-64.1 on March 17th, 2014 (Downloads are available here and from the Percona Software Repositories. Based on MySQL 5.6.16, including all the bug fixes in it, Percona Server 5.6.16-64.1 is the current GA...
by Hrvoje Matijakovic | Mar 17, 2014 | Percona Events, Percona Software
Percona is glad to announce the release of Percona Server 5.5.36-34.1 on March 17th, 2014 (Downloads are available here and from the Percona Software Repositories). Based on MySQL 5.5.36, including all the bug fixes in it, Percona Server 5.5.36-34.1 is now the current...
by Muhammad Irfan | Mar 14, 2014 | Insight for DBAs, MySQL
MySQL has a nice feature: MySQL slow query log, which allows you to log all queries that exceed a predefined about of time to execute. Peter Zaitsev first wrote about this back in 2006 – there have been a few other posts here on the MySQL Performance Blog since...
by Roman Vynar | Mar 14, 2014 | Cloud, MySQL, Percona Events
Percona is glad to announce the release of RDS metrics from Amazon CloudWatch. With Nagios you can have the following checks per instance: RDS Status, RDS Load Average, RDS Free Storage, RDS Free Memory. Also check out the examples of Configuration Best Practices...
by Dave Rosenlund | Mar 13, 2014 | MySQL
You may think that you have to buy, install, and get up to speed on a new database if you want to work with large amounts of data, but you can do more than you think with the MySQL you already have. Register Now! SPEAKER: Jon Tobin, Tokutek DATE: Thursday, March 20th...
by Terry Erisman | Mar 13, 2014 | Insight for DBAs, Insight for Developers, MySQL, Percona Events, Percona Live, Percona Software
I am very pleased to announce a new event in conjunction with the Percona Live MySQL Conference and Expo this year: Open Source Appreciation Day on Monday, March 31st in the Santa Clara Convention Center! We are pleased to announce two separate groups holding events...
by Peter Zaitsev | Mar 12, 2014 | MySQL, Percona Events, Percona Services, Percona Software
Monitoring MySQL and effectively managing it can be challenging. Identifying issues before they grow into performance problems that impact end users can be crucial. Knowing which tools to use, which key metrics to monitor, and how to resolve issues can be enormously...
by Tim.Callaghan | Mar 12, 2014 | MySQL
Yesterday we released TokuDB v7.1.5, which includes the following important features and fixes: Upgraded MySQL and MariaDB to version 5.5.36. Six months of performance improvements to our underlying Fractal Tree indexing. Fixes for bugs, stalls, and behavioral issues...
