[root@localhost ~]# service mysqld5612 status
[root@localhost ~]# mysql -uroot -proot
mysql> select * from t1.test1;
+------+| id |
+------+
| 1 |
| 2 |
| 3 |
+------+
3 rows in set (0.00 sec)
mysql> select * from t5.test1;
+------+------+| id | name |
+------+------+
| 3 | c |
| 2 | b |
| 1 | a |
+------+------+
3 rows in set (0.00 sec)
备份
[root@localhost ~]# mkdir /backups/mysql/ex
[root@localhost ~]# innobackupex --defaults-file=/etc/my.cnf --user=root --password="root" /backups/mysql/ex/$(date +%Y%m%d)/ --no-timestamp --parallel=2
..........
.....
innobackupex: Backup created in directory '/backups/mysql/ex/20151026'
innobackupex: MySQL binlog position: filename 'mysql-bin.000053', position 12015102610:10:24 innobackupex: Connection to database server closed
15102610:10:24 innobackupex: completed OK!