master服务器的mysql 4.0.26
slave服务器的mysql 5.0.45
master服务器未改动 在slave 重装系统之前可以正常同步,
slave服务器重装过系统 换成centos 5.2
slave服务器 未设置同步之前mysql可以正常启动使用
设置同步后无法启动 我先service mysqld stop slave服务器的mysql
然后设置如下 加入#####replication 之后的内容
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#####replication
master-host =192.168.0.1
master-user =kkuser
master-password =kk123
master-port =3306
replicate-do-db =kkB1
binlog-ignore-db =kkB1
master-connect-retry=60
server-id =B3
replicate-wild-do-table =kkB1.plu
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
master 服务器的my.cnf 如下 未改动
master 的mysql 安装在独立分区/kk下
[client]
port = 3306
socket = /kk/mysql/var/mysql.sock
[mysqld]
port = 3306
socket = /kk/mysql/var/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 4M
max_connections = 10000
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
### replication
log-bin = /kk/mysql/logbin/log
relay-log = /kk/mysql/logbin/relog
binlog-ignore-db = replication
binlog-ignore-db = mysql
max_binlog_size = 300M
server-id = K1
skip-slave-start
tmpdir = /kk/mysql/tmp
datadir = /kk/mysql/var
default-character-set = gbk[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
请教我的slave my.cnf要怎么设置 才可以启动mysql 并正常同步
slave服务器的mysql 5.0.45
master服务器未改动 在slave 重装系统之前可以正常同步,
slave服务器重装过系统 换成centos 5.2
slave服务器 未设置同步之前mysql可以正常启动使用
设置同步后无法启动 我先service mysqld stop slave服务器的mysql
然后设置如下 加入#####replication 之后的内容
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Default to using old password format for compatibility with mysql 3.x
# clients (those using the mysqlclient10 compatibility package).
old_passwords=1
#####replication
master-host =192.168.0.1
master-user =kkuser
master-password =kk123
master-port =3306
replicate-do-db =kkB1
binlog-ignore-db =kkB1
master-connect-retry=60
server-id =B3
replicate-wild-do-table =kkB1.plu
[mysqld_safe]
log-error=/var/log/mysqld.log
pid-file=/var/run/mysqld/mysqld.pid
master 服务器的my.cnf 如下 未改动
master 的mysql 安装在独立分区/kk下
[client]
port = 3306
socket = /kk/mysql/var/mysql.sock
[mysqld]
port = 3306
socket = /kk/mysql/var/mysql.sock
skip-locking
key_buffer = 384M
max_allowed_packet = 4M
max_connections = 10000
table_cache = 512
sort_buffer_size = 2M
read_buffer_size = 2M
myisam_sort_buffer_size = 64M
thread_cache = 8
query_cache_size = 32M
# Try number of CPU's*2 for thread_concurrency
thread_concurrency = 2
### replication
log-bin = /kk/mysql/logbin/log
relay-log = /kk/mysql/logbin/relog
binlog-ignore-db = replication
binlog-ignore-db = mysql
max_binlog_size = 300M
server-id = K1
skip-slave-start
tmpdir = /kk/mysql/tmp
datadir = /kk/mysql/var
default-character-set = gbk[myisamchk]
key_buffer = 256M
sort_buffer_size = 256M
read_buffer = 2M
write_buffer = 2M
[mysqlhotcopy]
interactive-timeout
请教我的slave my.cnf要怎么设置 才可以启动mysql 并正常同步
http://imysql.cn/docs/MySQL_51_zh/mysql_51.htmlMySQL 5.1 在线中文手册 这里你看一下:第5章:数据库管理5.1.4. mysql.server:MySQL服务器启动脚本
5.1.5. mysqld_multi:管理多个MySQL服务器的程序
我这里是B3 mysql无法理解
改成数字就OK了