单机安装多个mysql
来源:互联网 发布:php视频管理系统 编辑:程序博客网 时间:2024/06/06 13:12
单机mysql测试主从复制
cd /tools/mysql-5.5.15
./scripts/mysql_install_db --user=mysql --basedir=/usr/local/mysql --datadir=/opt/mydata01
# The following options will be passed to all MySQL clients
[client]
#password = your_password
port = 3307
socket = /tmp/mysql01.sock
# Here follows entries for some specific programs
# The MySQL server
[mysqld]
port = 3307
socket = /tmp/mysql01.sock
datadir=/opt/mydata01
[root@dd]vim /etc/init.d/mysql01
---------------------------------------------------------------------------------------------------------------------
#!/bin/sh
mysql_port=3307
mysql_username="root"
mysql_password=""
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my01.cnf 2>&1 > /dev/null &
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/usr/local/mysql/bin/mysqladmin -u ${mysql_username} -S /tmp/mysql01.sock shutdown
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
sleep 5
function_start_mysql
}
function_kill_mysql()
{
kill -9 $(ps -ef |grep 'bin/mysqld_safe'| grep ${mysql_port} | awk '{printf $2}')
kill -9 $(ps -ef |grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')
}
if [ "$1" = "start" ]; then
function_start_mysql
elif [ "$1" = "stop" ]; then
function_stop_mysql
elif [ "$1" = "restart" ]; then
function_restart_mysql
elif [ "$1" = "kill" ]; then
function_kill_mysql
else
printf "Usage: /etc/init.d/mysql01 {start;stop;restart;kill}\n"
#!/bin/sh
#!/bin/sh
mysql_port=3307
mysql_username="root"
mysql_password=""
function_start_mysql()
{
printf "Starting MySQL...\n"
/bin/sh /usr/local/mysql/bin/mysqld_safe --defaults-file=/etc/my01.cnf 2>&1 > /dev/null &
}
function_stop_mysql()
{
printf "Stoping MySQL...\n"
/usr/local/mysql/bin/mysqladmin -u ${mysql_username} -S /tmp/mysql01.sock shutdown
}
function_restart_mysql()
{
printf "Restarting MySQL...\n"
function_stop_mysql
sleep 5
function_start_mysql
}
function_kill_mysql()
{
kill -9 $(ps -ef |grep 'bin/mysqld_safe'| grep ${mysql_port} | awk '{printf $2}')
kill -9 $(ps -ef |grep 'libexec/mysqld' | grep ${mysql_port} | awk '{printf $2}')
}
if [ "$1" = "start" ]; then
function_start_mysql
elif [ "$1" = "stop" ]; then
function_stop_mysql
elif [ "$1" = "restart" ]; then
function_restart_mysql
elif [ "$1" = "kill" ]; then
function_kill_mysql
else
printf "Usage: /etc/init.d/mysql01 {start;stop;restart;kill}\n"
fi
--------------------------------------------------------------------------------------------
- 单机安装多个mysql
- 单机环境下安装多个MySQL服务器
- 单机启动多个mysql
- 单机MySQL多实例安装
- mysqld_multi单机启动多个mysql
- 单机启动多个mysql服务(修改)
- MySQL 安装及其单机多实例部署
- MySQL单机版安装
- Linux 单机启动多个mysql 实例(mysqld_multi )
- mysql单机多实例
- MySQL实现单机多实例安装并配置主从复制
- MySQL单机多实例安装并配置主从复制
- ubuntu单机下安装多mysql 5.7.14
- 安装多个mysql
- MySQL之——Linux单机启动多个MySQL实例(mysqld_multi )
- Red Hat安装单机版mysql数据
- MySQL单机多实例方案
- MySQL单机多实例方案
- WebRTC将如何影响当前的移动互联网? .
- HelloWorld
- C# 序列化与反序列化几种格式的转换
- 安装pyserial到win7-64位电脑
- Hanoi的实现
- 单机安装多个mysql
- 去除java代码中的UTF-8 BOM标识
- ORACLE之 几种常用的表连接方式
- 采购机柜要看重电源温升
- GetSysInfoPath
- AJAX学习笔记
- Java/C/C++中方法(函数)传值和传引用的问题
- Html 框架(分上下区)例子
- Hibernate第三方缓存实现