资源由 www.eimhe.com 美河学习在线收集分享
no-auto-rehash
[myisamchk]
key_buffer_size = 8M
sort_buffer_size = 8M
[mysqlhotcopy]
interactive-timeout
HH
顺序启动数据库
Node2 和 node3 上（node1 不需要）
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysqld
Node1: /usr/local/mysql/bin/mysqld --defaults-file=/usr/local/mysql/my1.cnf --wsrep-new-cluster
Node2:service mysqld restart
Node3:serivce mysqld restart
测试在任意一台创建删除数据均会同步
6.mysql5.6.24 与 mariadb mariadb10.0.17 单实例压力测试
注意 mariadb10.0.17 相当于 mysql 的 5.5 版本
sysbench-0.5-2.el6_.x86_64.rpm
CREATE TABLE test.`sbtest` (
`id` int(10) unsigned NOT NULL AUTO_INCREMENT,
`k` int(10) unsigned NOT NULL DEFAULT '0',
`c` char(120) NOT NULL DEFAULT '',
`pad` char(60) NOT NULL DEFAULT '',
PRIMARY KEY (`id`),
KEY `k` (`k`)
) ENGINE=InnoDB;
create table test.sbtest1 select * from test.sbtest; create table test.sbtest2 select * from
test.sbtest;create table test.sbtest3 select * from test.sbtest;create table test.sbtest4 select *
from test.sbtest;create table test.sbtest5 select * from test.sbtest;create table test.sbtest6
select * from test.sbtest;create table test.sbtest7 select * from test.sbtest;create table
test.sbtest8 select * from test.sbtest;create table test.sbtest9 select * from test.sbtest;create
table test.sbtest10 select * from test.sbtest;
create database sbtest;create table sbtest.sbtest select * from test.sbtest;create table
sbtest.sbtest1 select * from test.sbtest;create table sbtest.sbtest2 select * from
test.sbtest;create table sbtest.sbtest3 select * from test.sbtest;create table sbtest.sbtest4 select
剩余39页未读，继续阅读
