Zhong Weicheng Study Notes

MySQL 5.1 installation MySQL 5.5 installation One 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

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

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

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

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

先看下slave_exec_mod官方描述 Command-Line Format --slave-exec-mode=mode Option-File Format slave_exec_mode System Variable Name slave_exec_mode Variable S

确认master和slave上是否开启have_dynamic_loading master MASTER@root@(none) 10:54:58>show variables like 'have_dynamic_loading'; +----------------------+-------+ | Variable_name | Value | +------------