Xtrabackup是什么Xtrabackup是一个对MySQL InnoDB做数据备份的工具,支持在线热备份(备份时不影响数据读写),是商业备份工具InnoDB Hotbackup的一个很好的替代品。
Xtrabackup有两个主要的工具:xtrabackup、innobackupex1.xtrabackup只能备份InnoDB和XtraDB两种数据表,而不能备份MyISAM数据表2.innobackupex是参考了InnoDB Hotbackup的innoback脚本修改而来的.innobackupex是一个perl脚本封装,封装了xtrabackup。主要是为了方便的同时备份InnoDB和MyISAM引擎的表,但在处理myisam时需要加一个读锁。并且加入了一些使用的选项。如slave-info可以记录备份恢复后,作为slave需要的一些信息,根据这些信息,可以很方便的利用备份来重做slave。
Ubuntu 13.10_X64+MySQL-server-5.5.35+percona-xtrabackup-2.1.7
源码下载:http://www.percona.com/redir/downloads/XtraBackup/XtraBackup-2.1.7/binary/Linux/x86_64/percona-xtrabackup-2.1.7-721-Linux-x86_64.tar.gz
源码解压:tar -xzvf percona-xtrabackup-2.1.7-721-Linux-x86_64.tar.gz
cd percona-xtrabackup-2.1.7-Linux-x86_64/bin/
ll
drwxr-xr-x 2 master master 4096 Jan 23 22:12 ./
drwxr-xr-x 4 master master 4096 Jan 23 22:05 ../
-rwxr-xr-x 1 master master 169816 Jan 23 22:12 innobackupex*
lrwxrwxrwx 1 master master 12 Jan 23 22:12 innobackupex-1.5.1 -> innobackupex*
-rwxr-xr-x 1 master maste
MariaDB is a relational database management system (RDBMS) and MariaDB Galera Cluster is a synchronous multi-master cluster for MariaDB. It is available on Linux only, and only supports theXtraDB/InnoDB storage engines. This article explains how to setup MariaDB Galera Cluster 10.0 with 3 nodes running on CentOS 6.5 x86_64 resulting in a HA (high-availability) database cluster.
We using 3 freshly deployed VMs running a minimal install of CentOS 6.5 x86_64.
Cluster node 1 has hostname db1 and IP address 1.1.1.1 Cluster node 2 has hostname db2 and IP address 1.1.1.2 Cluster node 3 has hostname db3 and IP address 1.1.1.3
Create a mariadb repository /etc/yum.repos.d/mariadb.repo using following content in your system.
For CentOS 6 – 64bit:
[mariadb] name = MariaDB baseurl = http://yum.mariadb.org/10.0/c
by 刘迎光@萤火虫工作室
OpenBI交流群:495266201
MicroService 微服务交流群:217722918
mail: liuyg#liuyingguang.cn
博主首页(防止爬虫):http://blog.liuyingguang.cn
OpenBI问答社区:http://openbi.liuyingguang.cn/
然后输入两次密码
PermitRootLogin yes
PubkeyAuthentication no (也可用#号注释)
PasswordAuthentication yes
by 刘迎光@萤火虫工作室
OpenBI交流群:495266201
MicroService 微服务交流群:217722918
mail: liuyg#liuyingguang.cn
博主首页(==防止爬虫==):http://blog.liuyingguang.cn
官方Installation地址:https://freeswitch.org/confluence/display/FREESWITCH/FreeSWITCH+1.6+Video
rpm -ivh http://pkgs.repoforge.org/rpmforge-release/rpmforge-release-0.5.3-1.el6.rf.x86_64.rpm
或者
rpm -ivh http://mirror.cedia.org.ec/fedora-epel/6/x86_64/epel-release-6-8.noarch.rpm
yum install git gcc-c++ autoconf automake libtool wget python ncurses-devel zlib-devel libjpeg-devel openssl-devel e2fsprogs-devel sqlite-devel libcurl-devel pcre-devel speex-devel ldns-devel libedit-devel
cd /usr/src
git clone https://freeswitch.org/stash/scm/fs/freeswitch.git (##我用此版本,即1.6版本安装失败)或者git clone -b v1.4 https://freeswitch.org/stash/scm/fs/freeswitch.gitcd /usr/src/freeswitch./bootstrap.sh -j如果你想要添加或删除模块儿的话,可以修改modules.conf,在每行前面添加#来注释掉不需要的模块儿
如果不需要自定义模块儿,可以跳过此步骤./configure -Cmake && make install按照官方文档,做到此就完成安装了,可是我使用的1.6版本的,即以上git地址的第一个,可是按照网上的一些说法,解决了一部分错误以后,还是报错,于是根据另一篇文章(http://niyirangrujiu.blog.163.com/blog/static/9817337201581584910990/)所说,别人也是无法完成安装,于是我也换了1.4版本的,安装就成功了