… users. The new features in Percona XtraBackup will be part of the topics at the upcoming Percona Live MySQL Conference and Expo… conference on Percona XtraBackup and tools around it: Percona XtraBackup: install, usage, tricks tutorial, Tuesday 10th April Introducing XtraBackup Manager, Wednesday…
Post: Testing Percona Replication Manager (prm) with Vagrant
April 17, 2012 By 2 Comments
… Percona Replication Manager (PRM), a new high availability tool for MySQL. Percona Live DC 2012 Percona Live MySQL Conference & Expo 2012 PRM is… OCF Resource Agent for Corosync / Pacemaker that take cares of MySQL and manages the replication. Corosync allows any number of servers…. I have created a Vagrant environment to speed up installation and testing this new solution for HA. The url of the git…
Post: Percona welcomes Drizzle 7.1
April 10, 2012 By Leave a Comment
… of blog posts on each of the new features over the coming weeks. Major features …the Drizzle protocol plugin, authentication from a file, MySQL UNIX socket protocol, javascript plugin, authentication via … implemented in relatively small amounts of code. Installing Drizzle 7.1.33-stable The source …
Post: MySQL Installation and upgrade scripts.
May 21, 2007 By 3 Comments
… and your chances of successful downgrade if having problems with new major release will increase significantly. Making sure you can afford… gone now. mysql user removed I’m not sure if this one is done by RedHat uninstall script or MySQL install script but simply I find no mysql user after upgrade. MySQL Does not start after upgrade…
Post: Upgrading MySQL
January 5, 2010 By 23 Comments
… MySQL version and starting new one. MySQL always was very good maintaining on disk binary compatibility between version and so you can run MySQL… comparison. The tool will run SELECT queries on both new and old MySQL installations and check result set, explain plan and execution time…. Swapping master. Finally as you have your slave running on new MySQL version you want to promote it to the master and…
Post: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 37 Comments
…new features or slight performance improvements, however these days it is rarely important to MySQL…MYSQL, upgrade MySQL, 10x start/stop MySQL, upgrade MySQL, downgrade MySQL, upgrade MySQL, install a security fix for something, 20x start/stop MySQL, upgrade MySQL, … . Restarting and changing MySQL…
Post: What's the recommended MySQL version?
August 15, 2011 By 24 Comments
… by understanding whether we’re talking about an existing MySQL installation, or a new one. The answer is different for each case. (There… executing upgrades to MySQL 5.5. So what’s the bottom line? For new applications, I’ve said use MySQL 5.5 without… future. At this point, MySQL 5.1 is starting to get old, and MySQL 5.5′s new releases have just minor fixes…
Post: Why don't our new Nagios plugins use caching?
February 19, 2012 By 1 Comment
… response to the release of our new MySQL monitoring plugins on Friday, one commenter asked why the new Nagios plugins don’t use… high-quality Cacti templates for MySQL a few years ago (which are now replaced by the new project), making the Cacti templates… doesn’t add load to the server. Most real production installations I see actually have multiple people running innotop or what…
Post: How to Monitor MySQL with Percona's Nagios Plugins
February 22, 2012 By 8 Comments
In this post, I’ll cover the new MySQL monitoring plugins we created for Nagios, and explain their features … ships by default with many server installations) or a system administration mistake to delete one of MySQL‘s log or data files… down for a system reboot. The pmp-check-mysql-pidfile plugin verifies that MySQL‘s PID file exists. Evidence of contention in…
Post: Rebuilding MySQL with same options
April 8, 2010 By 4 Comments
… am working on the system with custom compiled MySQL. How to upgrade to the new MySQL Options while preserving as much of original compilation options as possible if original build scripts are not available ? MySQL distribution…=c++’ ‘build_alias=amd64-portbld-freebsd7.0′ Assuming MySQL was properly built and installed these are configuration options it was built with…
