Linux下mysql多版本共存安装_MySQL多版本安装在同一linux主机上

我的环境：

我的主机是CentOS5.2，已经安装了默认自带的mysql5045,现在想安装最新的5129和607来做测试

安装注意事项：

配置时的路径如下填写

./configure --with-tcp-port=5506 --with-unix-socket-path=/opt/MySQL5129 --prefix=/opt/MySQL5129

./configure --with-tcp-port=5507 --with-unix--socket-path=/opt/MySQL607 --prefix=/opt/MySQL607

--with-unix-socket-path这个参数可以不要，最后在my.cnf里面指定socket文件存放在什么路径

make

make install

这两步就没有什么好说的了

安装后的配置:

初始化数据库权限表

./mysql_install_db --basedir=/opt/MySQL5129 --datadir=/opt/MySQL5129/var --user=mysql

./mysql_install_db --basedir=/opt/MySQL607 --datadir=/opt/MySQL607/var --user=mysql

配置/etc/my.cnf参数文件:

[mysqld5129]

port=5506

socket=/tmp/mysql5129.sock

basedir=/opt/MySQL5129

datadir=/opt/MySQL5129/var

user=mysql

log-error=/var/log/mysqld5129.log

pid-file=/tmp/mysqld5129.pid

[mysqld607]

port=5507

socket=/tmp/mysql607.sock

basedir=/opt/MySQL607

datadir=/opt/MySQL607/var

user=mysql

log-error=/var/log/mysqld607.log

pid-file=/tmp/mysqld607.pid

启动数据库：

/opt/MySQL5129/bin/mysqld_multi start|stop  5129

/opt/MySQL607/bin/mysqld_multi start|stop  607

连接数据库：

mysql --socket=/tmp/mysql5129.sock

mysql --socket=/tmp/mysql607.sock

CU的yejr也推荐用mysqlmanager来管理mysql

有时间安装mysqlmanager来看看

常见的编译参数：

--without-debug

--with-low-memory

--with-charset=cp1251(gbk,gb2312,utf8)

--with-collation=cp1251_general_ci(gbk,gb2312,utf8)

--with-extra-charset=all

--with-plugins

--with-mysqld-ldflags=-all-static

mysqlperformanceblog在Freebsd平台上编译客户端的一个示例

./configure

'--localstatedir=/var/db/mysql'

'--without-debug'

'--without-readline'

'--without-libedit'

'--without-bench'

'--without-extra-tools'

'--with-libwrap'

'--with-mysqlfs'

'--with-low-memory'

'--with-comment=FreeBSD port: mysql-client-5.0.67_1'

'--enable-thread-safe-client'

'--with-charset=cp1251'

'--with-collation=cp1251_general_ci'

'--with-extra-charset=all'

'--with-named-thread-libs=-pthread'

'--without-server'

'--prefix=/usr/local'

'--mandir=/usr/local/man'

'--infodir=/usr/local/info/'

'--build=amd64-portbld-freebsd7.0'

'CC=cc' 'CFLAGS=-O2 -mmmx -msse -msse2 -msse3 -pipe -march=nocona  -fno-strict-aliasing'

'CXXFLAGS=-O2 -mmmx -msse -msse2 -msse3 -pipe -march=nocona -fno-strict-aliasing -O2 -mmmx -msse -msse2 -msse3 -pipe -march=nocona  -fno-strict-aliasing -felide-constructors -fno-rtti -fno-exceptions'

'CXX=c++'

'build_alias=amd64-portbld-freebsd7.0'

linux平台下的一个示例

./configure --prefix=/usr/local/mysql

--with-charset=utf8

--with-collation=utf8_general_ci

--with-client-ldflags=-all-static

--with-mysqld-ldflags=-all-static

--enable-assembler

--enable-thread-safe-client

–without-debug

--enable-local-infile

--with-big-tables

--with-ssl

--without-readline

--with-plugins=innodb,partition

--with-fast-mutexes

--with-zlib-dir=bundled

--with-××ded-server

--with-pthread

CFLAGS="-O3" CC=gcc CXX=gcc CXXFLAGS="-O3 -felide-constructors -fno-exceptions -fno-rtti"

./configure

--prefix=/usr/local/mysql

--localstatedir=/data/mysql/data

--enable-assembler

--with-charset=utf8

--with-client-ldflags=-all-static

--with-mysqld-ldflags=-all-static

--with-innodb

--with-plugins=partition

mysql编译参数详解

./configure \

--prefix=/usr/local/mysql \

--enable-assembler \

--without-debug \

--with-charset=utf8 \

--with-extra-charsets=all \

--with-pthread \

--enable-thread-safe-client \

--enable-local-infile \

--with-client-ldflags=-all-static \

--with-mysqld-ldflags=-all-static \

--with-big-tables \

--without-innod \

--without-isam 2;

--with-ssl \

--with-embedded-server \

--enable-assembler \使用一些字符函数的汇编版本

--without-debug \去除debug模式

--with-charset=utf8 \

--with-extra-charsets=complex字符支持

--with-pthread \强制使用pthread库(posix线程库)

--enable-thread-safe-client \以线程方式编译客户端

--with-client-ldflags=-all-static \以纯静态方式编译客户端

--with-mysqld-ldflags=-all-static \以纯静态方式编译服务端

--with-big-tables

There is a limit of 232 (~4.295E+09) rows in a MyISAM table. If you build MySQL with the --with-big-tables option, the row limitation is increased to (232)2 (1.844E+19) rows

--without-innodb \去掉innodb表支持，innodb是一种支持事务处理的表，适合企业级应用

--enable-local-infile #让mysql支持从本地文件 导入数据库

--without-isam \去掉isam表类型支持，现在很少用了，isam表是一种依赖平台的表

--with-embedded-server #编译成embedded MySQL library (libmysqld.a)