MySQL
-
编辑 删除
安装配置PXC（Percona XtraDB Cluster）集群
1、安装percona-release包下面操作在三台服务器上都执行：创建用户：# groupadd mysql# useradd -g mysql mysql# passwd mysql安装数据源：# rpm -ivh percona-release-0.0-1.x86_64.rpm# rpm -ivh epel-release-6-8.noarch.rpm装软件：# yum install Percona-XtraDB-Cluster-562、pxc01配置：# vi /etc/my.c...
-
编辑 删除
使用xtrabackup对mysql进行备份和恢复
使用xtrabackup对mysql进行备份：安装xtrabackup：# rpm -ivh percona-release-0.0-1.x86_64.rpm# yum install percona-xtrabackup1、创建备份用户及赋予相关权限mysql -u root -pcreate user 'bkpuser'@'localhost' identified by 'bkpuser';grant reload,lock tables,replication client on *.* to 'bkpuser'@'l...
