tungsten-replicator 实现mysql 与mysql同步
来源:互联网 发布:java 调用linux shell 编辑:程序博客网 时间:2024/04/29 18:10
1,centos 5.3 安装tungsten 需要ruby ,java
- [root@localhost ~]# java -version
- java version "1.6.0_25"
- Java(TM) SE Runtime Environment (build 1.6.0_25-b06)
- Java HotSpot(TM) Client VM (build 20.0-b11, mixed mode, sharing)
2,还需要ssh 自动登录
配置方法:http://asuper.blog.51cto.com/1622151/1102050
3,下载http://code.google.com/p/tungsten-replicator/downloads/list
本人按装 tungsten-replicator-2.0.6-src.tar.gz
master上面创建mysql账号:
CREATE USER 'tungsten'@'%' IDENTIFIED BY '123456';
GRANT ALL ON *.* TO 'tungsten'@'%' WITH GRANT OPTION
解压后,再master或slave任意一台机器上,执行即可
- [root@localhost tungsten-replicator-2.0.6]# ./tools/tungsten-installer --master-slave \
- > --master-host=192.168.52.128 \
- > --datasource-user=tungsten \
- > --datasource-password=123456 \
- > --service-name=logos \
- > --home-directory=/data/tungsten-replicator-2.0.6 \
- > --cluster-hosts=192.168.52.128,192.168.52.133 \
- > --start-and-report
- WARN >> 192.168.52.128 >> 32-bit architecture not recommended for DBMS nodes
- WARN >> 192.168.52.128 >> THL schema tungsten_logos already exists at tungsten@192.168.52.128:3306 (WITH PASSWORD)
- WARN >> 192.168.52.128 >> The value of max_allowed_packet is too small for tungsten@192.168.52.128:3306 (WITH PASSWORD)
- WARN >> 192.168.52.133 >> 32-bit architecture not recommended for DBMS nodes
- WARN >> 192.168.52.133 >> THL schema tungsten_logos already exists at tungsten@192.168.52.133:3306 (WITH PASSWORD)
- WARN >> 192.168.52.133 >> The value of max_allowed_packet is too small for tungsten@192.168.52.133:3306 (WITH PASSWORD)
- INFO >> 192_168_52_128 >> Getting services list
- INFO >> 192_168_52_128 >> ....
- Processing services command...
- NAME VALUE
- ---- -----
- appliedLastSeqno: 3
- appliedLatency : 1.356590497686E9
- role : master
- serviceName : logos
- serviceType : local
- started : true
- state : ONLINE
- Finished services command...
- INFO >> 192_168_52_133 >> Getting services list
- INFO >> 192_168_52_133 >> ..
- Processing services command...
- NAME VALUE
- ---- -----
- appliedLastSeqno: 3
- appliedLatency : 1.356647435914E9
- role : slave
- serviceName : logos
- serviceType : local
- started : true
- state : ONLINE
- Finished services command...
0 0
- tungsten-replicator 实现mysql 与mysql同步
- 通过tungsten replicator实现mysql多主一从的备份架
- tungsten-replicator问题与解决方法
- 使用 tungsten-replicator4 实现 mysql -- > monogo 数据同步
- tungsten-replicator
- tungsten-replicator 源码
- Tungsten Replicator学习总结
- Tungsten Replicator学习总结
- tungsten replicator 代码的修改
- 使用tungsten-replicatior实现MySQL之间的主从复制
- MySQL binlog分析程序:Open Replicator
- MySQL binlog分析程序:Open Replicator
- 基于tungsten API 同步mysql binlog出现EOF packet received的问题解决
- Elasticserch与Mysql实现数据同步
- Activemq实现Mysql与SolrCloud同步策略
- tungsten安装mysql到oracle复制
- MySQL数据同步实现
- Elasticsearch实现与mysql的数据库的同步
- css 的绝对定位和相对定位
- Codevs 1004 四子连棋
- LINK:fatal error LNK1123: 转换到 COFF 期间失败: 文件无效或损坏
- 网络流入门--最大流算法Dicnic 算法
- 删除数据库里重复的记录
- tungsten-replicator 实现mysql 与mysql同步
- Codevs 1993 草地排水
- 《机器学习实战》——决策树
- jQuery 性能优化
- POJ 1459 Power Network
- Unity Shader 知识点总结(二)
- 计算机内存
- POJ 1062 昂贵的聘礼
- mock2easy环境搭建和gitbook文档自动生成