… new Percona Toolkit series has been released: Percona Toolkit 2.2 for MySQL 5.6. Several months in the making and many new features, changes, and improvements make this a great new series… by default. If the IO::Socket::SSL Perl module is installed (easily available through your package manager), it will use a…
Post: Upgrading MySQL
January 5, 2010 By 24 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: 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: Which Linux distribution for a MySQL database server? A specific point of view.
December 8, 2011 By 38 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: How to use a smartphone for two-factor authentication with Percona Server for MySQL
February 24, 2013 By Leave a Comment
… follow steps: 1. Enable PAM plugin (more in our documentation): mysql> INSTALL PLUGIN auth_pam SONAME ‘auth_pam.so’; 2. Configure PAM…/p/google-authenticator/ if you are Ubuntu user – install package sudo apt-get install libpam-google-authenticator 5. From the user account…&chl=otpauth://totp/vadim@secrethost.percona.com%3Fsecret%3DEDCHNEEFQ5TYQFYL Your new secret key is: EDCHNEEFQ5TYQFYL It outputs URL, when you use…
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 11 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…
Post: Updated msl (microslow) patch, installation walk-through!
April 20, 2008 By 17 Comments
… you should determine how your current MySQL installation was built, so you can have the new binary to be as close to the… about installing MySQL on your platform. Also have a look at the files in the Docs directory. Thank you for choosing MySQL! Otherwise… to have the patched MySQL installed in the system. Locate where the original mysqld binary is with: (garfield:~/work/mysql-5.0.51a…
