freebsd配置

内核编译

 

carp负载均衡

http://oskb.blogbus.com/logs/53252071.html

 

mysql同步问题

 

http://youshuai415.blog.163.com/blog/static/4231510201101152130444/

 

 

java依赖库问题

http://www.chunyv.com/myblog/?p=226

mysql my.cnf设置

replicate-same-server-id

server-id=1

binlog-do-db=cak

#master-host=192.168.1.155

#master-user=backup

#master-password=000000

#replicate-do-db=cak

#master-connect-retry=60

#master-port=3306

#binlog-ignore-db=mysql

#replicate-ignore-db=mysql

#sync-binlog=1

#skip-slave-start

replicate-wild-do-table=cak.CAK_ALARM_GPS

replicate-wild-do-table=cak.CAK_ALARM_USER

replicate-wild-do-table=cak.CAK_ALARM_SMS

replicate-wild-do-table=cak.CAK_DEVICE

replicate-wild-do-table=cak.CAK_DEVICE_CARD

replicate-wild-do-table=cak.CAK_DEVICE_LOST_RCPT

replicate-wild-do-table=cak.CAK_DEVICE_PUBLIC_ALARM

replicate-wild-do-table=cak.CAK_DEVICE_PUBLIC_ALARM_EN

#replicate-wild-do-table=cak.CAK_MESSAGE_POOL

replicate-wild-do-table=cak.CAK_USER

#replicate-wild-do-table=cak.CAK_USER_ALARM_POOL

replicate-wild-do-table=cak.CAK_USER_DEVICE

replicate-wild-do-table=cak.CAK_USER_INFO

replicate-wild-do-table=cak.CAK_USER_PHONE

mysql 同步设置

slave stop;

reset slave;

reset master;

flush logs;

GRANT REPLICATION SLAVE ON *.* TO 'master_slave'@'192.168.1%' IDENTIFIED BY '000000';

CHANGE MASTER TO MASTER_HOST='192.168.1.141',MASTER_USER='master_slave', MASTER_PASSWORD='000000';

FLUSH PRIVILEGES;

slave start;

show slave status\G;

退出控制台 重启mysql