wangdi244 发表于 2015-03-11 13:24

一台mysql服务器启动多个端口实验中的问题 请教大家~!

今天在做mysql多端口的实验遇到了问题!用二进制格式的mysql,初始化
./scripts/mysql_install_db --datadir=/home/mysql1 --user=mysql
./scripts/mysql_install_db --datadir=/home/mysql2 --user=mysql
之后编辑配置文件vim /etc/my.cnf在里面添加如下配置

port            = 3300
socket          = /tmp/mysql1.sock
pid-file      = /home/mysql1/localhost.localdomain1.pid
datadir         = /home/mysql1
#log            = /data/mysql1/mysql1.log
user            = mysql
skip-locking
skip-name-resolve
skip-bdb
skip-innodb
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 864
sort_buffer_size = 1M
read_buffer_size = 512K
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 32M
thread_cache_size = 16
query_cache_size = 32M
thread_concurrency = 8
#skip-networking
wait_timeout=8
max_connections=512
max_connect_errors = 10000000
max_user_connections=20
#slow_queries=/data/mysql1slowquer.sql
#log_slow_queries=/data/mysql1slowquer.sql
long_query_time=3
log-bin=mysql1-bin
###########################

port            = 3301
socket          = /tmp/mysql2.sock
pid-file      = /home/mysql2/localhost.localdomain2.pid
datadir         = /home/mysql2
#log            = /data/mysql2/mysql2.log
user            = mysql
skip-locking
skip-name-resolve
skip-innodb
skip-bdb
key_buffer = 128M
max_allowed_packet = 1M
table_cache = 864
sort_buffer_size = 1M
read_buffer_size = 512K
read_rnd_buffer_size = 1M
myisam_sort_buffer_size = 32M
thread_cache_size = 16
query_cache_size = 32M
thread_concurrency = 8
#skip-networking
wait_timeout=8
max_connections=512
max_connect_errors = 10000000
max_user_connections=20
#log_slow_queries=/data/mysql1slowquer.sql
long_query_time=3
log-bin=mysql2-bin
########################################
最后执行 /usr/local/mysql/bin/mysqld_multi start 1-2 无法启动
请教大家如何解决?

lyhabc 发表于 2015-03-13 17:35

详细报错信息呢
页: [1]
查看完整版本: 一台mysql服务器启动多个端口实验中的问题 请教大家~!