下載perconal二進制包解壓後啟動提示
while loading shared libraries: libssl.so.6: cannot open shared object file:
查看系統已經安裝了openssl等rpm包,因此做軟連接
32位系統
ln -sf /usr/lib/libssl.so.10 /usr/lib/libssl.so.6
ln -sf /usr/lib/libcrypto.so.10 /usr/lib/libcrypto.so.6
64位系統
ln -sf /usr/lib64/libssl.so.10 /usr/lib64/libssl.so.6
ln -sf /usr/lib64/libcrypto.so.10 /usr/lib64/libcrypto.so.6
安裝percona
下載Percona DB
wget http://www.percona.com/redir/downloads/Percona-Server-5.5/Percona-Server-5.5.17-22.1/source/Percona-Server-5.5.17-rel22.1.tar.gz
下載CMAKE
wget http://www.cmake.org/files/v2.8/cmake-2.8.5.tar.gz
安裝CMAKE
tar zxf cmake-2.8.5.tar.gz
cd cmake-2.8.5
./bootstrap
make
make install
為安裝Percona做准備
yum install libaio-devel
useradd mysql
安裝Percona DB
tar -zxvf Percona-Server-5.5.17-rel22.1.tar.gz
cd Percona-Server-5.5.17-rel22.1
配置
cmake . -DCMAKE_INSTALL_PREFIX=/usr/local/perconamysql -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DEXTRA_CHARSETS=all -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DWITH_DEBUG=0 -DBUILD_CONFIG=mysql_release -DFEATURE_SET=community -DWITH_EMBEDDED_SERVER=OFF
編譯安裝
make && make install
創建配置文件
cp support-files/my-innodb-heavy-4G.cnf /etc/my.cnf
初始化數據庫
/usr/local/perconamysql/scripts/mysql_install_db --basedir=/usr/local/perconamysql/ --datadir=/usr/local/perconamysql/data/ --user=mysql
啟動數據庫
/usr/local/perconamysql/bin/mysqld_safe --user=mysql &