MariaDB, Galera, xtrabackup - do I need the binary log?

Posted by bernhardrusch on Server Fault See other posts from Server Fault or by bernhardrusch
Published on 2014-06-11T14:38:15Z Indexed on 2014/06/11 15:29 UTC
Read the original article Hit count: 231

Filed under:

mariadb

|

xtrabackup

|

galera

We are using a MariaDB Galera Cluster with 3 nodes. For the state transfer we are using xtrabackup.

We have some problems with the binary logs - they got too big and crashed the server. We can remove them manually with the purge binary logs command, another way would be to set the expire_logs_days so they would expire.

I now that we could use xtrabackup to backup the DB and use the binlog to get to some point in time. But do we really need it for Galera to work ?

© Server Fault or respective owner

Related posts about mariadb

Ubuntu 13.10 Installing MariaDB when Apt reports MariaDB has unmet dependencies or broken packages

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have tried everything to install MariaDB on this clean Ubuntu installation but I keep getting this error, Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been… >>> More
Uninstalling MySQL for MariaDB Replacement on cPanel

as seen on Server Fault - Search for 'Server Fault'
Well the first part of my day was spent researching how to remove MySQL to install MariaDB and the second part of my day was spent trying to reinstall MySQL cause something was messed up. So now I come to the masses for some help. I have a box with cPanel/WHM on it. CentOS 5.6 64 bit. I have upgraded… >>> More
how to uninstall mariadb and re-install mysql ? Mysql install turns into mariadb install

as seen on Server Fault - Search for 'Server Fault'
I recently upgraded my centos system via the desktop. mistake! I had mariadb, phpmyadmin working just fine before - but after the upgrade they stopped. I frantically googled and tried to follow some tutorials about mariadb * mysql reinstall untill I came to this one: http://centosforge.com/node/how-replace-mysql-mariadb-centos-6-including-mysql-uninstall-instructions-and-yum-install I… >>> More
How to install MariaDB rpms in CentOS 6.4 using rpm (not yum cmd) + handling mysql-libs conflicts

as seen on Server Fault - Search for 'Server Fault'
I need to script the install of MariaDB using the rpm command in CentOS 6.4. I can't use yum since it's going to be an offline install so there's no access to the repository. The only MySQL package installed is mysql-libs as various other packages in CentOS depend on it. When I did a test install… >>> More
Ubuntu 13.10 Installing MariaDB

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I have tried everything to install MariaDB on this clean Ubuntu installation but I keep getting this error, Some packages could not be installed. This may mean that you have requested an impossible situation or if you are using the unstable distribution that some required packages have not yet been… >>> More

Related posts about xtrabackup

Error while installing Xtrabackup

as seen on Server Fault - Search for 'Server Fault'
I'd like to install XtraBackup (rpm -i percona-xtrabackup-2.1.9-744.rhel6.x86_64.rpm). During the rpm install it told me that it misses a dependency. error: Failed dependencies: perl(DBD::mysql) is needed by percona-xtrabackup-2.1.9-744.rhel6.x86_64 perl(Time::HiRes) is needed by percona-xtrabackup-2… >>> More
Issue with percona-xtrabackup-2.0.0 hotbackup on MyIsam tables

as seen on Server Fault - Search for 'Server Fault'
I am trying to implement hot backup for MyIsam tables with "percona-xtrabackup-2.0.0" and getting the following error? As the all tables are MyIsam I doubt am I using the correct package ? Backup : ./innobackupex --user="root" --password=<pass> --defaults-file="<path>/my.cnf" --ibbackup="<path>/percona-xtrabackup-2… >>> More
MySQL Open Source Backup and Recovery Alternative: Xtrabackup

as seen on Internet.com - Search for 'Internet.com'
MySQL database administrators are always looking for a solid backup and recovery tool that will suit all their needs. Xtrabackup, created by Percona, is the open source alternative to the commercial Innodb Hot Backup tool. This article explains a good methodology for testing and verifying Xtrabackups… >>> More
MySQL Open Source Backup and Recovery Alternative: Xtrabackup

as seen on Internet.com - Search for 'Internet.com'
MySQL database administrators are always looking for a solid backup and recovery tool that will suit all their needs. Xtrabackup, created by Percona, is the open source alternative to the commercial Innodb Hot Backup tool. This article explains a good methodology for testing and verifying Xtrabackups… >>> More
How to install Percona Xtrabackup to Ubuntu 12.04LTS?

as seen on Ask Ubuntu - Search for 'Ask Ubuntu'
I am trying to install Percona Xtrabackup to my Ubuntu 12.04 LTS insatlled on Amazon EC2. I am trying to follow instruction on the Xtrabackup installation page here. The instruction follows as Add this to /etc/apt/sources.list, replacing squeeze with the name of your distribution: deb http://repo… >>> More