您好,登录后才能下订单哦!
密码登录
登录注册
点击 登录注册 即表示同意《亿速云用户服务条款》
- mkdir -p /data/master
- mkdir -p /data/slave
- mkdir -p /data/master_binlog
- mkdir -p /data/slave_binlog
- mkdir /var/log/mysql1
- mkdir /var/log/mysql2
- chown mysql.mysql /data/master -R
- chown mysql.mysql /data/slave -R
- chmod 777 /var/log/mysql1
- chmod 777 /var/log/mysql2
- chmod 777 /var/lib/mysql
/usr/local/mysql/scripts/mysql_install_db --datadir=/data/master
/usr/local/mysql/scripts/mysql_install_db --datadir=/data/slave
4. 安装工具
5.修改环境变量
- cp /usr/local/mysql/bin/my_print_defaults /usr/bin/
- cp /usr/local/mysql/bin/mysqld_multi /usr/bin
1.mysql启动
- mysqld_multi start 1 启动实例1
- mysqld_multi start 1-2 启动实例1,2
2.命令行登陆
- mysql -u your_user -p your_password -P3307 -S /tmp/mysql3307.sock
由于涉及权限问题,mysqld_multi不能控制关闭mysql多实例,自己写了个关闭脚本#!/bin/bashuser=""password=""read -p "Please input mysqld ID 1-2:" IDif [ "$ID" == "1" ]; then#read -p "Please input mysqld port number 3306-3307:" port/usr/local/mysql/bin/mysqladmin -u$user -p$password -S /var/lib/mysql/mysql3306.sock shutdown && echo "close mysqld master successful"elif [ "$ID" == "2" ]; then/usr/local/mysql/bin/mysqladmin -u$user -p$password -S /var/lib/mysql/mysql3307.sock shutdown && echo "close mysqld slave successful"elseecho "Please input mysqld ID 1-2:"fi
亿速云「云数据库 MySQL」免部署即开即用,比自行安装部署数据库高出1倍以上的性能,双节点冗余防止单节点故障,数据自动定期备份随时恢复。点击查看>>
开发者交流群:
免责声明:本站发布的内容(图片、视频和文字)以原创、转载和分享为主,文章观点不代表本网站立场,如果涉及侵权请联系站长邮箱:is@yisu.com进行举报,并提供相关证据,一经查实,将立刻删除涉嫌侵权内容。
原文链接:http://blog.itpub.net/31401161/viewspace-2132350/