- 论坛徽章:
- 0
|
回复 #3 yueliangdao0608 的帖子
yueliangdao:
你好,
把我们得结构弄成图了,你看看吧。
现在主要得问题在于:
Master2 上的日志文件的增长不能和Master1 上完全同步增长,每次更新后就相差一个固定的数字。
配置信息,就是上面我贴的大概内容。
这里是 master 的详细全部配置:
这样的:replicate-ignore-table = MAIN.JHF_UNRE
就是 ndb 的表,不需要复制到 master2 中去的,因为那里有同样的表。
[root@mfx225 data]# cat /etc/my.cnf
[MYSQLD]
ndbcluster
ndb-connectstring=10.4.6.224
default-storage-engine=ndbcluster
max_connections=1024
default-character-set=cp932
ndb-log-update-as-write=0
memlock
#ndb-cluster-connection-pool=4
#added 2008 08 20 for ...
#BASE config.....
skip-name-resolve
back_log =350
log-slow-queries = slow.log
long_query_time = 1
table_cache =350
sort_buffer_size = 1M
query_cache_size=512M
query_cache_limit=2M
ndb_force_send=1
engine_condition_pushdown=1
ndb_use_exact_count=0
#1 -- means enable, 0 -- means disable
slave-allow-batching=1
#transaction-isolation = READ-COMMITTED
#add by wangxl ,for "converting HEAP to MyISAM "
max_heap_table_size=64M
tmp_table_size=64M
thread_cache_size=350
#add by liuyf for primary key repeat
auto_increment_increment=4
auto_increment_offset=4
delayed_queue_size=500
bulk_insert_buffer_size=16M
#MySQL slave config ...........
log-bin=mfx225-bin
binlog_format="STATEMENT"
#binlog_format="ROW"
#binlog_format="MIXED"
server-id = 25
master-host = 10.4.6.227
master-user = root
master-password = 123456
replicate-do-db = MAIN
replicate-ignore-table = MAIN.JHF_ALIVE
replicate-ignore-table = MAIN.JHF_UNRE
#replicate-ignore-table = mysql.%
#replicate-ignore-table = test.%
#replicate-rewrite-db="MAIN->MAIN"
relay-log=mfx225-relay-bin
skip-slave-start
log-slave-updates |
|