Tagged: mysql

CentOS 6.0 fix for VBoxGuestAdditions installation for VirtualBox

Virtualbox is a useful tool for testing various Linux and Windows operating systems in a virtualized environment. However, while testing my modified Centmin Nginx installation script on CentOS 6.0 64bit, I came across an issue with installing VBoxGuestAddition components – the VirtualBox Guest Additions’ kernel modules failed to get built....

MariaDB 5.2 MySQL repository for RHEL/CentOS YUM installs

OurDelta announced they have setup a MariaDB 5.2 MySQL repository for easy MySQL installs and upgrades on RHEL and CentOS. Instructions for MariaDB 5.2 (new release) Install the OurDelta release RPM : rpm -ivh http://master.ourdelta.org/yum/CentOS-MariaDB52/ourdelta-release-5-1.noarch.rpmrpm -ivh http://master.ourdelta.org/yum/CentOS-MariaDB52/ourdelta-release-5-1.noarch.rpm You’re done. From that, proceed to install the MariaDB packages as usual, using...

mysqlmybackup.sh – multi feature MySQL database backup and restore script with Percona XtraBackup & Mydumper tool support

mysqlmybackup.sh started out as a mysqldump based MySQL back up script which I started on June 20th, 2011. I compiled the script based on the modified MySQL mysqldump backup script by Vivek Gite and merged it with Zarafa.com script. Script Evolution: The script has since evolved from the original Vivek...

MariaDB 5.2.7 MySQL Server Released

MariaDB 5.2.7 MySQL has been released. Already updated my custom Centmin Nginx installation script with MariaDB 5.2.7. The MariaDB 5.2.7 change log is pretty long so summary: Faster Internal Temporary Tables HeidiSQL GUI client now included in Windows MSI package Red Hat Enterprise Linux (RHEL) 5 RPMs Other fixes and...

MySQL Benchmarks: MySQL 5.5.11 vs Percona 5.5.10-20.1 vs MariaDB 5.2.5 – InnoDB and MyISAM

Updated MySQL benchmark results for MySQL 5.5.11 vs Percona 5.5.10-20.1 vs MariaDB 5.2.5 were made possible as I managed to gain further access to the Quad Intel Xeon Nehalem-EX L7555 Octo-Core 1.86Ghz, 64GB memory server.  Apparently, it sat untouched for nearly 3 weeks after I last used the server as...