MySQL Replication
ZhongWeicheng
这个作者很懒,什么都没留下…
展开
-
MySQL master-master replication configuration
MySQL 5.1 installationMySQL 5.5 installationOne may say that there are a lot of MySQL replication manuals, but latest versions of MySQL server have changed the way how configuration should b原创 2013-01-10 17:22:17 · 1022 阅读 · 0 评论 -
MySQL Utilities Example
You obviously need Python on your server (python-2.6.6-37.el6_4.x86_64 in mycase) and the Python MySQL library (mysql-connector-python-1.0.8-1.el6.noarch)[root@db01 software]# rpm -ivh mysql-conne原创 2013-11-06 16:39:46 · 2246 阅读 · 0 评论 -
MySQL配置Master-Slave
master库打开log-bin参数,保证master和slave的server-id参数不同在master上创建允许slave访问的rep用户MASTER@root@(none) 12:34:34>grant replication slave on *.* to 'rep'@'192.168.1.12' identified by 'rep';Query OK, 0 rows aff原创 2014-01-30 00:54:52 · 1046 阅读 · 0 评论 -
MySQL禁用binlog中的语句
MySQL复制是异步的,也就是说是非同步的过程,它不会校验数据库中数据的一致性,只要SQL语法正确并且没有错误就能成功执行MASTER@root@test 12:20:40>create table tab01 -> (id int(10) primary key , -> name varchar(20));Query OK, 0 rows affected (0.03 s原创 2014-01-30 12:29:29 · 3375 阅读 · 0 评论 -
统计MySQL binlog中的DML语句
MASTER@root@test 07:44:52>create table tab02(id int(10) primary key,name varchar(20));Query OK, 0 rows affected (0.10 sec)MASTER@root@test 08:34:54>MASTER@root@test 08:34:54>MASTER@root@test 08:3原创 2014-01-31 20:38:15 · 1451 阅读 · 0 评论 -
MySQL复制环境中使用slave_exec_mod参数
先看下slave_exec_mod官方描述Command-Line Format--slave-exec-mode=modeOption-File Formatslave_exec_modeSystem Variable Nameslave_exec_modeVariable S原创 2014-01-31 19:23:40 · 2893 阅读 · 0 评论 -
MySQL5.5配置安装半同步复制
确认master和slave上是否开启have_dynamic_loadingmasterMASTER@root@(none) 10:54:58>show variables like 'have_dynamic_loading';+----------------------+-------+| Variable_name | Value |+------------原创 2014-02-03 23:10:47 · 2330 阅读 · 0 评论