找到项目里一个配置最复杂的linux mysql 服务器
上面有若干个mysql
主要 my.cnf 配置如下
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root
password = 123[mysqld2]
socket = /var/lib/mysql2/mysql.sock2
port = 3307
pid-file = /var/lib/mysql2/hostname.pid2
datadir = /var/lib/mysql2
language = /usr/share/mysql/english
user = root
master-host=192.168.10.1
.。其他省略log-error=/var/log/mysqld/mysql2.log[mysqld3]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
socket = /var/lib/mysql3/mysql.sock3
port = 3308
pid-file = /var/lib/mysql3/hostname.pid3
datadir = /var/lib/mysql3
language = /usr/share/mysql/english
user = root
server-id=2
master-host=192.168.10.2
master-user=slave
master-password=slavepass
#master_log_file=mysql-bin.000001
#master_log_pos=4028
master-connect-retry=60
default-character-set=utf8
character-set-server=utf8
default-collation=utf8_unicode_ci
default-table-type=INNODB
wait_timeout=800
connect_timeout=25
interactive_timeout=800
max_connections=50
sort_buffer = 228M
group_concat_max_len=65536
innodb_buffer_pool_size=4000MB
innodb_additional_mem_pool_size=20M
innodb_log_file_size=128M
innodb_log_buffer_size=8M
innodb_thread_concurrency=500
innodb_flush_method=O_DSYNC
table_cache=800
innodb_status_file = 1
innodb_flush_log_at_trx_commit = 0
innodb_autoextend_increment = 25M
skip-external-locking
innodb_table_locks=0
max_allowed_packet=32M
tmp_table_size=96M
thread_concurrency=10
thread_cache_size=500
log-error=/var/log/mysqld/mysql3.log
slave-skip-errors=1061,1062
skip-slave-start
#[mysqld_safe]
#log-error=/var/log/mysql/mysql.log
#pid-file=/var/run/mysqld/mysqld.pid可以判断至少有2个 mysql 服务器 在同台机器上 ps -ef | grep mysql
lh 14300 14112 0 06:48 pts/3 00:00:00 grep mysql
root 18664 1 0 2009 begin_of_the_skype_highlighting 18664 1 0 2009 end_of_the_skype_highlighting ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --socket=/var/lib/mysql2/mysql.sock2 --port=3307 --pid-file=/var/lib/mysql2/hostname.pid2 --datadir=/var/lib/mysql2 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.1 --master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --log-error=/var/log/mysqld/mysql2.log --socket=/var/lib/mysql2/mysql.sock2 --port=3307 --pid-file=/var/lib/mysql2/hostname.pid2 --datadir=/var/lib/mysql2 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.1--master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --log-error=/var/log/mysqld/mysql2.log
root 18923 18664 1 2009 ? 8-18:43:14 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql2 --user=root --pid-file=/var/lib/mysql2/hostname.pid2 --skip-external-locking --port=3307 --socket=/var/lib/mysql2/mysql.sock2 --language=/usr/share/mysql/english --server-id=2 --master-host=192.168.10.1 --master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --language=/usr/share/mysql/english --server-id=2 --master-host=192.168.10.1 --master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500
root 29417 1 0 2009 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --socket=/var/lib/mysql3/mysql.sock3 --port=3308 --pid-file=/var/lib/mysql3/hostname.pid3 --datadir=/var/lib/mysql3 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.2 --master-user=slave --master-password=slavepass --master-connect-retry=60 --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --default-table-type=INNODB --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=32M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --log-error=/var/log/mysqld/mysql3.log --slave-skip-errors=1061,1062 --skip-slave-start --socket=/var/lib/mysql3/mysql.sock3 --port=3308 --pid-file=/var/lib/mysql3/hostname.pid3 --datadir=/var/lib/mysql3 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.2 --master-user=slave --master-password=slavepass --master-connect-retry=60 --default-character-set=utf8 --character-set-server=utf8
从这个现实结果可以知道确实 是2个mysql在运行。问题如下:
1 我直接mysql -uroot -p123发现无法登陆
后来我换成./mysqld_safe --user=mysql[l@dbin]$ ./mysqld_safe --socket=/var/lib/mysql3/mysql.sock3 --port=3308
cat: /var/lib/mysql/devcph.betbrain.com.pid: Permission denied
rm: cannot remove `/var/lib/mysql/devcph.betbrain.com.pid': Permission denied
Fatal error: Can't remove the pid file: /var/lib/mysql/devcph.betbrain.com.pid
./mysqld_safe: line 353: /var/lib/mysql/devcph.betbrain.com.err: Permission denied
Please remove it manually and start ./mysqld_safe again
mysqld daemon not started
[lh@devcph bin]$--------------------------现在无法登陆到该2个mysql服务上
2 这2个mysql 是源码安装的还是2进制安装的 ,如何登陆
上面有若干个mysql
主要 my.cnf 配置如下
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
user = root
password = 123[mysqld2]
socket = /var/lib/mysql2/mysql.sock2
port = 3307
pid-file = /var/lib/mysql2/hostname.pid2
datadir = /var/lib/mysql2
language = /usr/share/mysql/english
user = root
master-host=192.168.10.1
.。其他省略log-error=/var/log/mysqld/mysql2.log[mysqld3]
mysqld = /usr/bin/mysqld_safe
mysqladmin = /usr/bin/mysqladmin
socket = /var/lib/mysql3/mysql.sock3
port = 3308
pid-file = /var/lib/mysql3/hostname.pid3
datadir = /var/lib/mysql3
language = /usr/share/mysql/english
user = root
server-id=2
master-host=192.168.10.2
master-user=slave
master-password=slavepass
#master_log_file=mysql-bin.000001
#master_log_pos=4028
master-connect-retry=60
default-character-set=utf8
character-set-server=utf8
default-collation=utf8_unicode_ci
default-table-type=INNODB
wait_timeout=800
connect_timeout=25
interactive_timeout=800
max_connections=50
sort_buffer = 228M
group_concat_max_len=65536
innodb_buffer_pool_size=4000MB
innodb_additional_mem_pool_size=20M
innodb_log_file_size=128M
innodb_log_buffer_size=8M
innodb_thread_concurrency=500
innodb_flush_method=O_DSYNC
table_cache=800
innodb_status_file = 1
innodb_flush_log_at_trx_commit = 0
innodb_autoextend_increment = 25M
skip-external-locking
innodb_table_locks=0
max_allowed_packet=32M
tmp_table_size=96M
thread_concurrency=10
thread_cache_size=500
log-error=/var/log/mysqld/mysql3.log
slave-skip-errors=1061,1062
skip-slave-start
#[mysqld_safe]
#log-error=/var/log/mysql/mysql.log
#pid-file=/var/run/mysqld/mysqld.pid可以判断至少有2个 mysql 服务器 在同台机器上 ps -ef | grep mysql
lh 14300 14112 0 06:48 pts/3 00:00:00 grep mysql
root 18664 1 0 2009 begin_of_the_skype_highlighting 18664 1 0 2009 end_of_the_skype_highlighting ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --socket=/var/lib/mysql2/mysql.sock2 --port=3307 --pid-file=/var/lib/mysql2/hostname.pid2 --datadir=/var/lib/mysql2 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.1 --master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --log-error=/var/log/mysqld/mysql2.log --socket=/var/lib/mysql2/mysql.sock2 --port=3307 --pid-file=/var/lib/mysql2/hostname.pid2 --datadir=/var/lib/mysql2 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.1--master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --log-error=/var/log/mysqld/mysql2.log
root 18923 18664 1 2009 ? 8-18:43:14 /usr/libexec/mysqld --basedir=/usr --datadir=/var/lib/mysql2 --user=root --pid-file=/var/lib/mysql2/hostname.pid2 --skip-external-locking --port=3307 --socket=/var/lib/mysql2/mysql.sock2 --language=/usr/share/mysql/english --server-id=2 --master-host=192.168.10.1 --master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --language=/usr/share/mysql/english --server-id=2 --master-host=192.168.10.1 --master-user=slave --master-password=slavepass --master-connect-retry=60 --replicate-do-db=oddsmatrixdb --relay-log=/var/log/mysqld/relay2.log --relay-log-info-file=/var/log/mysqld/relay2-log.info --relay-log-index=/var/log/mysqld/relay2-log.index --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=100M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500
root 29417 1 0 2009 ? 00:00:00 /bin/sh /usr/bin/mysqld_safe --socket=/var/lib/mysql3/mysql.sock3 --port=3308 --pid-file=/var/lib/mysql3/hostname.pid3 --datadir=/var/lib/mysql3 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.2 --master-user=slave --master-password=slavepass --master-connect-retry=60 --default-character-set=utf8 --character-set-server=utf8 --default-collation=utf8_unicode_ci --default-table-type=INNODB --wait_timeout=800 --connect_timeout=25 --interactive_timeout=800 --max_connections=50 --sort_buffer=228M --group_concat_max_len=65536 --innodb_buffer_pool_size=4000MB --innodb_additional_mem_pool_size=20M --innodb_log_file_size=128M --innodb_log_buffer_size=8M --innodb_thread_concurrency=500 --innodb_flush_method=O_DSYNC --table_cache=800 --innodb_status_file=1 --innodb_flush_log_at_trx_commit=0 --innodb_autoextend_increment=25M --skip-external-locking --innodb_table_locks=0 --max_allowed_packet=32M --tmp_table_size=96M --thread_concurrency=10 --thread_cache_size=500 --log-error=/var/log/mysqld/mysql3.log --slave-skip-errors=1061,1062 --skip-slave-start --socket=/var/lib/mysql3/mysql.sock3 --port=3308 --pid-file=/var/lib/mysql3/hostname.pid3 --datadir=/var/lib/mysql3 --language=/usr/share/mysql/english --user=root --server-id=2 --master-host=192.168.10.2 --master-user=slave --master-password=slavepass --master-connect-retry=60 --default-character-set=utf8 --character-set-server=utf8
从这个现实结果可以知道确实 是2个mysql在运行。问题如下:
1 我直接mysql -uroot -p123发现无法登陆
后来我换成./mysqld_safe --user=mysql[l@dbin]$ ./mysqld_safe --socket=/var/lib/mysql3/mysql.sock3 --port=3308
cat: /var/lib/mysql/devcph.betbrain.com.pid: Permission denied
rm: cannot remove `/var/lib/mysql/devcph.betbrain.com.pid': Permission denied
Fatal error: Can't remove the pid file: /var/lib/mysql/devcph.betbrain.com.pid
./mysqld_safe: line 353: /var/lib/mysql/devcph.betbrain.com.err: Permission denied
Please remove it manually and start ./mysqld_safe again
mysqld daemon not started
[lh@devcph bin]$--------------------------现在无法登陆到该2个mysql服务上
2 这2个mysql 是源码安装的还是2进制安装的 ,如何登陆
rm: cannot remove `/var/lib/mysql/devcph.betbrain.com.pid': Permission denied
Fatal error: Can't remove the pid file: /var/lib/mysql/devcph.betbrain.com.pid
./mysqld_safe: line 353: /var/lib/mysql/devcph.betbrain.com.err: Permission denied
Please remove it manually and start ./mysqld_safe again
mysqld daemon not startedps -ef | grep mysql 发现进程还在哪
[root@devcph bin]# mysql -uroot -p123-P3307
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql/mysql.sock' (2)
发现还是错误如何在命令指定socket = /var/lib/mysql2/mysql.sock2??
请看ps -ef | grep mysql 发现进程还在哪 。 我需要知道如何登录(mysql -uroot...)?
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql2/mysql.sock2' (2)制定还是错误 ps -ef | grep mysql 发现的mysql进程 难道是假进程????
tcp 0 0 10.0.1.155:53251 192.168.10.1:3306 ESTABLISHED
[r bin]# netstat -tuna | grep 3308
tcp 0 0 0.0.0.0:3308 0.0.0.0:* LISTEN
[r bin]#netstat -tuna | grep 3307
tcp 0 0 0.0.0.0:3307 0.0.0.0:* LISTEN请帮助分析下 3306 3307 3308 是否开着 ?
但是 mysql -uslave -p123 -P3307 -S /var/lib/mysql2/mysql.sock2
ERROR 2002 (HY000): Can't connect to local MySQL server through socket '/var/lib/mysql2/mysql.sock2' (2)制定还是错误