MySQL8 clone plugin - 数据库编程

TOP

MySQL8 clone plugin(二)

2019-09-17 16:20:13 【大中小】浏览:59次

le_recovery = 1 innodb_io_capacity = 2000 innodb_io_capacity_max = 3000 log_timestamps = system ###replication settings########### master_info_repository = table relay_log_info_repository = table binlog_format = row sync_binlog = 0 transaction_isolation = READ-COMMITTED log_slave_updates = on relay_log_recovery = 1 #for gtid gtid_mode = on enforce_gtid_consistency = on binlog_gtid_simple_recovery = 1 #####MyISAM setting########## key_buffer_size = 128M read_buffer_size = 8M read_rnd_buffer_size = 8M join_buffer_size = 8M bulk_insert_buffer_size = 64M sort_buffer_size = 8M myisam_sort_buffer_size = 1G myisam_max_sort_file_size = 10G myisam_repair_threads = 1 table_open_cache = 4096 [mysqldump] quick max_allowed_packet = 64M [myisamchk] key_buffer_size = 64M sort_buffer_size = 16M read_buffer_size = 64M write_buffer_size = 64M [mysqlhotcopy] interactive-timeout View Code

初始化

cd /usr/local/mysql8

./bin/mysqld --defaults-file=/data/mysql8017/etc/my.cnf --user=mysql --initialize

View Code

启动

/usr/local/mysql8/bin/mysqld --defaults-file=/data/mysql8017/etc/my.cnf --user=mysql &

View Code

安装clone plugin

命令行加载插件

INSTALL PLUGIN clone SONAME 'mysql_clone.so';

View Code

配置文件启动时加载

[mysqld]
plugin-load-add=mysql_clone.so

View Code

强制启动时，必须加载clone插件

[mysqld]
plugin-load-add=mysql_clone.so
clone=FORCE_PLUS_PERMANENT

View Code

本地 clone
clone 需要游clone_admin权限的用户才能clone，本地实验使用root

GRANT BACKUP_ADMIN ON *.* TO 'clone_user';

View Code

本地执行clone

clone local data directory ='clone_dir';

clone_dir MySQL 有写入权限

mysql> clone local data directory ='/data/mysql8/clone_data/mysql8017';
Query OK, 0 rows affected (5 min 13.88 sec)

远程 clone

set global clone_valid_donor_list='192.168.64.154:5432'

clone instance from gao@192.168.64.154:5432 identified by '213456' data directory = '/data/backup/clone/mysql8';

验证

mkdir -pv /data/mysql8/{etc,var,log,tmp}
mv /data/backup/clone/mysql8/* /data/mysql8/var/

/usr/local/mysql8/bin/mysqld --defaults-file=/data/mysql8/etc/my.cnf --user=mysql &

mysql> use performance_schema;
Reading table information for completion of table and column names
You can turn off this feature to get a quicker startup with -A

show Database changed
mysql> show tables like '%clone%';
+----------------------------------------+
| Tables_in_performance_schema (%clone%) |
+----------------------------------------+
| clone_progress |
| clone_status |
+----------------------------------------+
2 rows in set (0.01 sec)

mysql> select * from clone_status ;
+------+------+-----------+-------------------------+-------------------------+---------------------+----------------+----------+---------------+-----------------+-----------------+---------------+
| ID | PID | STATE | BEGIN_TIME | END_TIME | SOURCE | DESTINATION | ERROR_NO | ERROR_MESSAGE | BINLOG_FILE | BINLOG_POSITION | GTID_EXECUTED |
+------+------+-----------+-------------------------+-------------------------+---------------------+----------------+--

首页上一页 1 2 3 下一页尾页 2/3/3
【大中小】【打印】【繁体】【投稿】【收藏】【推荐】【举报】【评论】【关闭】【返回顶部】

上一篇：mysql学习之基础篇05	下一篇：数据库如何应对保障大促活动