本文主要包含tcmalloc,jemalloc tcmalloc,tcmalloc 安装,mysql主从复制,mysql主从配置等服务器相关知识,网友希望可以进行参考
实现环境:mysql 5.5.27,cenot 6.2 64bit,centos 最小化安装。软件cmake-2.8.8.tar.gz,
libunwind-1.0.tar.gz ,gperftools-2.0.tar.gz 。
一,主服务器IP:192.168.1.15,从服务器IP:192.168.1.16。先配置主服务器,安装好系统后需要安装开发环境:yum -y groupinstall 'Development tools' ,centos 6.0的系统只需安装Development tools。
二,安装libunwind和gperftools。
- 安装libunwind库。
- # tar xf libunwind-1.0.tar.gz
- # tar xf libunwind-1.0
- #CFLAGS=-fPIC ./configure添加编译参数
- # make CFLAGS=-fPIC
- # make CFLAGS=-fPIC install
- 这样执行会出现如下错误:
- libtool: install: error: relink `libunwind-setjmp.la' with the above command before installing it
- make[3]: *** [install-libLTLIBRARIES] Error 1
- make[3]: Leaving directory `/down/libunwind-1.0/src'
- make[2]: *** [install-am] Error 2
- make[2]: Leaving directory `/down/libunwind-1.0/src'
- make[1]: *** [install] Error 2
- make[1]: Leaving directory `/down/libunwind-1.0/src'
- make: *** [install-recursive] Error 1
- 产生这种问题的原因:autotools兼容性的问题,运行命令autoreconf -i -f ,在重新编译安装下。
- #autoreconf -i -f
- #make clean
- #CFLAGS=-fPIC ./configure
- #make CFLAGS=-fPIC
- #make CFLAGS=-fPIC install
- 安装gpperftools:
- #tar xf gperftools-2.0.tar.gz
- # cd gperftools-2.0
- #./configure
- #make && make install
- 这样安装会会报如下错误:
- cc1plus: warning: unrecognized command line option "-Wno-unused-result"
- ake: *** [stacktrace.lo] Error 1
- 为什么出现在这种错误,因此是64bit系统,至于更深度的解释,安装说明中有。下面重新编译。
- #make clean
- #./configure --enable-frame-pointers
- #make && make install
- #echo "/usr/local/lib" > /etc/ld.so.conf.d/usr_local_lib.conf
- #ldconfig
三,安装cmake与mysql
- 安装cmake
- #tar xf cmake-2.8.8.tar.gz
- #cd cmake-2.8.8
- # ./bootstrap
- # gmake && gmake install
- 安装mysql
- #useradd -r mysql -s /sbin/nologin
- #mkdir -p /data/mysql/{data,binlog,relaylog}
- #chown mysql:mysql -R /data/mysql
- # tar xf mysql-5.5.27.tar.gz
- #cd mysql-5.5.27
- #cmake -DCMAKE_INSTALL_PREFIX=/usr/local/mysql -DDEFAULT_CHARSET=utf8 -DDEFAULT_COLLATION=utf8_general_ci -DEXTRA_CHARSETS=all -DWITH_MYISAM_STORAGE_ENGINE=1 -DWITH_INNOBASE_STORAGE_ENGINE=1 -DENABLED_LOCAL_INFILE=1 -DMYSQL_DATADIR=/data/mysql/data -DWITH_DEBUG=0 -DSYSCONFDIR=/etc -DMYSQL_TCP_PORT=3306
- #会编译不过去,提示需要安装ncurses-devel,yum -y install ncurses-devel
- #rm -f CMakeCache.txe 重新执行./configure
- # make && make install
- #cd /usr/local/mysql
- #chown -R mysql:mysql *
- # cp support-files/mysql.server /etc/rc.d/init.d/mysqld
- #chmod +x /etc/init.d/mysqld
- #chkconfig mysqld on
- # vim /etc/profile 添加PATH=$PATH:/usr/local/mysql/bin
- # . /etc/profile(或

