单台[DELL R720]服务器部署多个MySQL实例

单台[DELL R720]服务器部署多个MySQL实例一、安装mysql准备1.1 下载mysql软件包mkdir -p /home/xuekun/mysqlcd /home/xuekun/tools/mysqlwgethttp://dev.mysql.com/get/Downloads/MySQL-5.5/mysql-5.5.10.tar.gz1.2安装mysql软件yum-y install make gcc-c++ cmake bison bison-devel ncurses-develtarxvf mysql-5.6.16.tar.gzcdmysql-5.6.16cmake-DCMAKE_INSTALL_PREFIX=/usr/local/mysql-DMYSQL_DATADIR=/data-DSYSCONFDIR=/etc-DWITH_MYISAM_STORAGE_ENGINE=1-DWITH_INNOBASE_STORAGE_ENGINE=1-DWITH_MEMORY_STORAGE_ENGINE=1-DWITH_READLINE=1-DMYSQL_UNIX_ADDR=/var/lib/mysql/mysql.sock-DMYSQL_TCP_PORT=3306-DENABLED_LOCAL_INFILE=1-DWITH_PARTITION_STORAGE_ENGINE=1-DEXTRA_CHARSETS=all-DDEFAULT_CHARSET=utf8-DDEFAULT_COLLATION=utf8_general_ci make&& make install 1.3创建mysql用户groupadd mysqluseradd -g mysql -M -s /sbin/nologin mysql1.4创建mysql数据文件目录mkdir -p/data/3306/datamkdir -p/data/3307/datatree /data//data/|-- 3306| `-- data`-- 3307`-- data4 directories, 0 files1.5 授权mysql用户及组访问数据文件目录chown -Rmysql:mysql /data/3306chown -Rmysql:mysql /data/33071.6 建立3306,3307my.cnf配置文件vim /data/3306/my.cnfvim /data/3307/my.cnf需要添加的my.cnf内容见附录B：或本文档目录下的my.cnf文件#授权mysql用户及组访问my.cnfchown -Rmysql:mysql /data/3306/my.cnfchown -Rmysql:mysql /data/3307/my.cnf1.7 建立mysql启动脚本vim /data/3306/mysqlvim /data/3307/mysql 需要添加的mysql 内容见附录C：或本文档目录下的mysql文件chmod 700/data/3306/mysqlchmod 700/data/3307/mysql1.8初始化数据库vim/etc/profilePATH=/usr/local/mysql/bin:$PATHexportPATH#关闭文件，运行下面的命令，让配置立即生效source/etc/profilecd/usr/local/mysqlscripts/mysql_install_db--datadir=/data/3306/dataInstallingMySQL system tables...OKFilling helptables...OKTo start mysqldat boot time you have to copysupport-files/mysql.serverto the right place for your systemPLEASE REMEMBERTO SET A PASSWORD FOR THE MySQL root USER ！To do so, startthe server, then issue the following commands:/usr/local/mysql/bin/mysqladmin-u root password "new-password"/usr/local/mysql/bin/mysqladmin-u root -h A password "new-password"Alternativelyyou can run:/usr/local/mysql/bin/mysql_secure_installationwhich will alsogive you the option of removing the testdatabases andanonymous user created by default. This isstronglyrecommended for production servers.See the manualfor more instructions.You can startthe MySQL daemon with:cd/usr/local/mysql ; /usr/local/mysql/bin/mysqld_safe &You can testthe MySQL daemon with mysql-test-run.plcd/usr/local/mysql/mysql-test ; perl mysql-test-run.plPlease reportany problems with the /usr/local/mysql/bin/mysqlbug script！ scripts/mysql_install_db--datadir=/data/3307/dataInstallingMySQL system tables...OKFilling helptables...OK同上面3306的内容，因此，此处省略。 chown -Rmysql:mysql /data1.9 启动数据库启动mysql实例的命令为/data/3306/mysqlstartStartingMySQL.../data/3307/mysqlstartStartingMySQL...检查启动情况：netstat-lnt|grep 330[6-7]tcp 0 00.0.0.0:3306 0.0.0.0:* LISTENtcp 0 00.0.0.0:3307 0.0.0.0:* LISTEN并加入/etc/rc.local，设置为开机自启动echo"/data/3306/mysql start" >>/etc/rc.localecho"/data/3307/mysql start" >>/etc/rc.localcat/etc/rc.local#！/bin/sh## This scriptwill be executed *after* all the other init scripts.# You can putyour own initialization stuff in here if you don"t# want to dothe full Sys V style init stuff.touch/var/lock/subsys/local/data/3306/mysqlstart/data/3307/mysql start提示：如果此步中的数据库启动不了，请稍微等待下，如果还不行请查看错误日志，路径在my.cnf的最下面。 --------------------------------------分割线 --------------------------------------Ubuntu 14.04下安装MySQL http://www.linuxidc.com/Linux/2014-05/102366.htm《MySQL权威指南（原书第2版）》清晰中文扫描版 PDF http://www.linuxidc.com/Linux/2014-03/98821.htmUbuntu 14.04 LTS 安装 LNMP NginxPHP5 （PHP-FPM）MySQL http://www.linuxidc.com/Linux/2014-05/102351.htmUbuntu 14.04下搭建MySQL主从服务器 http://www.linuxidc.com/Linux/2014-05/101599.htmUbuntu 12.04 LTS 构建高可用分布式 MySQL 集群 http://www.linuxidc.com/Linux/2013-11/93019.htmUbuntu 12.04下源代码安装MySQL5.6以及Python-MySQLdb http://www.linuxidc.com/Linux/2013-08/89270.htmMySQL-5.5.38通用二进制安装 http://www.linuxidc.com/Linux/2014-07/104509.htm--------------------------------------分割线 --------------------------------------更多详情见请继续阅读下一页的精彩内容： http://www.linuxidc.com/Linux/2014-10/108223p2.htm

使用mysqldump导出数据库MySQL的InnoDB引擎锁的原理试验相关资讯 MySQL实例

MySQL数据库实例参数对比脚本（05月11日）
MySQL多实例配置（10/28/2015 19:56:57）
MySQL 使用mysqld_multi部署单机多（05/19/2015 16:52:38）

MySQL管理多个实例的方法（12/21/2015 13:29:47）
MySQL优化之——安全地关闭MySQL实（07/11/2015 14:44:21）
MySQL “Bind on TCP/IP port: （01/27/2015 17:34:57）

本文评论查看全部评论（0）