mysqlserverclone&mysqluserclone&mysqlrpladmin

A、mysqlserverclone对已经存在instance clone一个

mysqlserverinfo 展示mysql server参数情况

$ ./mysqlserverinfo --server=root@localhost:3306 --format=vertical -d
# Source on localhost: ... connected.
*************************       1. row *************************
         server: localhost:3306
        version: 5.5.18-log
        datadir: /u01/mysql/data/
        basedir: /u01/mysql
     plugin_dir: /u01/mysql/lib/plugin
    config_file: /u01/mysql/my.cnf
     binary_log: mysql-bin.002592
 binary_log_pos: 360024544
      relay_log: None
  relay_log_pos: None
1 rows.
 
Defaults for server localhost:3306
#...done.

B、mysqluserclone 创建一个和已有帐户相同的帐户,在percona版本中跑不了

$ ./mysqluserclone --source=root@localhost --destination=root@localhost luoxuan@localhost aa:aa@localhost
# Source on localhost: ... connected.
# Destination on localhost: ... connected.
ERROR: Base user does not exist!

C、mysqlrpladmin工具主要功能类似mysqlfailover,这边不再展开

D、mysqluc集中控制台


Post a Comment