xtrabckup备份报错：Failed to connect to MySQL server: Can't connect to local MySQL server through socket ...

1.做软连接

[root@xxxxxx:/data/backup/log]# ln -s /var/lib/mysql/mysql.sock /tmp/mysql.sock
[root@xxxxxxxxx:/data/backup/log]# ln -s /var/lib/mysql/mysql.sock /data/mysql/mysql.sock

 

2.mysql> show variables like '%slave_parallel_workers%';
+------------------------+-------+
| Variable_name          | Value |
+------------------------+-------+
| slave_parallel_workers | 0     |
+------------------------+-------+
1 row in set (0.00 sec)

设置成0

转载于:https://www.cnblogs.com/leochenliang/p/8548091.html