Community Learn Tools Library Leisure
search
English
Home > Database > Mysql Tutorial > MySQL5.5主主复制配置方法及测试结果

MySQL5.5主主复制配置方法及测试结果

WBOY
Release： 2016-06-07 17:16:49
Original
1063 people have browsed it

1. 环境：CentOS5.5 x84，MySQL5.5.152. 两台机器：master1:192.168.5.143master2:192.168.0.1493. 单独编译安装MySQL，并测试连

10. 测试

实验1：启动两个服务，在任一mysql上进行操作，在另一mysql上均能体现出来。

实验2：启动两个服务，在master1上通过tpcc工具添加20个warehouse，数据占用硬盘约1.9G，，在两台机器上计算count(*)，数据一致。

实验3：启动master1，在master1上通过tpcc工具添加一个warehouse，启动master2，同步一段时间后，计算count(*)，结果一致。


ps，MySQL的主主复制实际上就是双向的主从复制。

Related labels：
MySQL主主复制 MySQL5.5主主复制配置方法及测试结
source：php.cn
Previous article：Oracle R12采购接收流程(PR-PO-RCV-AP-Payment) Next article：ora-01190 ora-01110的解决方法
Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn
Latest Articles by Author
Latest Issues
How to make floated elements stack vertically instead of horizontally in CSS? I'm trying to make a webpage with two columns, with main content on one side and additiona...
From 2024-04-06 20:45:26
0
2
386
Symfony Redis cannot connect to the host defined in the env file, which defaults to localhost We have a new Symfony setup with Redis as the caching mechanism. We want to connect to a s...
From 2024-04-06 10:53:02
0
1
375
Can PDF files run HTML5 and Javascript? I have a stupid idea to try and make a program that won't be blocked on any computer since...
From 2024-04-05 12:57:00
0
1
456
I want to send two different emails to two different addresses using php in the same function So when a product is ordered from a merchant registered on my website, I want my code to u...
From 2024-04-04 22:17:09
0
1
1481
SQL query not showing up in specific route in Node.js I'm new to javascript and nodejs and I have a question I have a code where I'm working on ...
From 2024-04-04 00:24:22
0
1
344
Related Topics
More>
Popular Recommendations
Popular Tutorials
More>
Related Tutorials
Popular Recommendations
Latest courses
Latest Downloads
More>
Web Effects
Website Source Code
Website Materials
Front End Template