openssl 1.0.1g heartbleed updates for Centos,Redhat and Fedora

The openssl heartbleed bug has made the rounds today here i have given how to update it to latest one from source file.

Check you openssl version

#openssl version
OpenSSL 1.0.1 14 Mar 2012  --  it is very old version

Download openssl-1.0.1g.tar.gz  from http://www.openssl.org/source/

Check gcc and glibc installed or not by,

#rpm -qa|grep gcc

#rpm -qa|grep glibc

if the both files are not  installed then install it.

now extract openssl-1.0.1g.tar.gz

cd  openssl-1.0.1g

./config

make

make install

cp /usr/bin/openssl /usr/bin/openssl.org

cp -r /usr/local/ssl/bin/openssl /usr/bin/openssl

cp -r /etc/pki/tls/openssl.cnf /etc/pki/tls/openssl.cnf.org

cp -r /usr/local/ssl/openssl.cnf /etc/pki/tls/openssl.cnf

#openssl version
OpenSSL 1.0.1g 7 Apr 2014


Now you have updated the openssl to latest one.

Percona Xtrabackup Tool

We all know to take backup MySQL databases through Mysqldump options but here I am going to explain another tool called Xtrabackup to backup our MySQL databases without any disturbance to your Server.

We can download Xtrabackup from this link : http://www.percona.com/downloads/XtraBackup/


Xtrabackup RPM  Installation:

In RPM there is 3 files:

1.Xtrabackup ( percona-xtrabackup-2.1.2-611.rhel6.x86_64.rpm )
2.Debug-files (percona-xtrabackup-debuginfo-2.1.2-611.rhel6.x86_64.rpm )
3.Test (percona-xtrabackup-test-2.1.2-611.rhel6.x86_64.rpm )

Download these above three files.

Installation :

Step 1:

$ rpm -Uvh percona-xtrabackup-2.1.2-611.rhel6.x86_64.rpm

Step 2:

$ rpm -Uvh  percona-xtrabackup-debuginfo-2.1.2-611.rhel6.x86_64.rpm

Step 3:

$ rpm -Uvh  percona-xtrabackup-test-2.1.2-611.rhel6.x86_64.rpm


After installed it check it whether it is installed or not by using,

$ yum list|grep percona

Here you can see the list for percona files was installed.


Take Backup Using Xtrabackup:

Add your data directory in my.cnf or my.ini file.

$ innobackupex --user=root --password=pa$$word --export  /nfsdrive

/nfsdrive  --> backup path.

Take compressed backup:

$ innobackupex --user=root --password=pa$$word --export --compress /nfsdrive

or

$ innobackupex --user=root --password=pa$$word --stream=tar ./ | gzip -c > /nfsdrive/backup.tar.gz


Restore Backup:

1.Stop mysql
2.Move your mysql data directory to other location.

3.Copy the backup from backup path to mysql data directory.
4.Start the server.

Now you can use your databases.

Note:

If you are using "--compress" option while taking backup.It will save in ".qp" format you need to extract it by download qpress and extract it by,

/path/qpress  -d  /backup_path/example.qp  /backup_path

More details : http://www.percona.com/software/percona-xtrabackup