CENTOS安装MYSQL多实例服务器.pdf

操作系统：CentOS 5.6 x86_64 硬件环境： CPU:Intel (R) Xeon (R) CPU E5620 @ 2.40GHz 内存：32G 硬盘：300G*2 10K 软件环境： gcc version 4.1.2(Red Hat 4.1.2-50) mysql 5.1.59.tar.gz libunwind-1.0.tar.gz google-perftools-1.8.3.tar.gz 上述软件假设存放在目录/root/soft 下 实验目的：在CentOS 下安装MySQL 并实现多实例数据库服务器及innodb-plugin 应用 步骤： #创建日志和运行目录 mkdir -p /opt/logs /opt/run chmod 777 /opt/run #添加组和用户 groupadd mysql useradd -g mysql -s /sbin/nologin mysql #安装libunwind tar zxf libunwind-1.0.tar.gz cd libunwind-1.0 autoreconf -fi CHOST x86_64-redhat-linux \ CFLAGS -O3 -fPIC -fomit-frame-pointer \ -pipe -march nocona -mfpmath sse -m128bit-long-double \ -mmmx -msse -msse2 -maccumulate-outgoing-args -m64 \ -ftree-loop-linear -fprefetch-loop-arrays -fno-omit-frame-pointer \ -freg-struct-return -fgcse-sm -fgcse-las -frename-registers \ -fforce-addr -fivopts -ftree-vectorize -ftracer -frename-registers \ -minline-all-stringops -fbranch-target-load-optimize2 CXXFLAGS ${CFLAGS} ./configure make make install #安装google-perftools tar zxf google-perftools-1.8.3.tar.gz cd google-perftools-1.8.3 CHOST x86_64-redhat-linux \ CFLAGS -O3 -fomit-frame-pointer -pipe -march nocona \ -mfpmath sse -m128bit-long-double -mmmx -msse -msse2 \ -maccumulate-outgoing-args -m64 -ftree-loop-linear \ -fprefetch-loop-arrays -fno-omit-frame-pointer \ -freg-struct-return -fgcse-sm -fgcse-las \ -fforce-addr -fivopts -ftree-vectorize -ftracer \ -frename-registers -minline-all-stringops \ -fbranch-target-load-optimize2 \ CXXFLAGS ${CFLAGS} -DTCMALLOC_LARGE_PAGES \ ./configure \ --disable-heap-checker \ --disable-debugalloc \ --enable-frame-pointers make make install echo /usr/local/lib /etc/ld.so.conf.d/usr_local_lib .conf echo /usr/lib /etc/ld.so.conf.d/usr_local_lib .conf echo /usr/lib64 /etc/ld.so.conf.d/usr_local_lib .conf echo /usr/local/lib64 /etc/ld.so.conf.d/usr_local_lib .conf /sbin/ldconfig #安装MySQL tar zxf mysql-5.1.59.tar.gz cd mysql-5.1.59 CXX gcc CHOST x86_64-redhat-lin