MariaDB 5.5.24 Release working mydumper !
MariaDB 5.5.24 MySQL server was released last month and they finally released RPM packages for MariaDB 5.5 – including an official MariaDB YUM repository.
I decided to test and found out if the multi-threaded MySQL backup and restore tool, mydumper worked with MariaDB 5.5.24 or if it suffered the same incompatibility problem with official MySQL.com Community released MySQL 5.5.
I upgraded one of my local CentOS 6.2 test servers which currently runs Centmin Mod installed stack consisting of Nginx, PHP-FPM and MariaDB 5.2.12 to MariaDB 5.5.24 and besides a few incompatible my.cnf MySQL variables, it was a success.
I’m happy to report that mydumper v0.5.1 installed fine on MariaDB 5.5.24 official YUM install same as when I tested with my own custom RPM built MariaDB 5.5.23.
mydumper source installed
-- ------------------------------------------------ -- MYSQL_CONFIG = /usr/bin/mysql_config -- CMAKE_INSTALL_PREFIX = /usr/local -- BUILD_DOCS = ON -- RUN_CPPCHECK = OFF -- Change a values with: cmake -D<Variable>=<Value> -- ------------------------------------------------ -- -- Configuring done -- Generating done -- Build files have been written to: /usr/local/src/mydumper-0.5.1 Scanning dependencies of target mydumper [ 20%] Building C object CMakeFiles/mydumper.dir/mydumper.c.o [ 40%] Building C object CMakeFiles/mydumper.dir/binlog.c.o [ 60%] Building C object CMakeFiles/mydumper.dir/server_detect.c.o [ 80%] Building C object CMakeFiles/mydumper.dir/g_unix_signal.c.o Linking C executable mydumper [ 80%] Built target mydumper Scanning dependencies of target myloader [100%] Building C object CMakeFiles/myloader.dir/myloader.c.o Linking C executable myloader [100%] Built target myloader [ 80%] Built target mydumper [100%] Built target myloader Install the project... -- Install configuration: "" -- Installing: /usr/local/bin/mydumper -- Installing: /usr/local/bin/myloader |
MariaDB 5.5.24 version info
[root@centos62uek tools]# mysqladmin ver mysqladmin Ver 9.0 Distrib 5.5.24-MariaDB, for Linux on x86_64 Copyright 2000-2008 MySQL AB, 2008 Sun Microsystems, Inc, 2009 Monty Program Ab This software comes with ABSOLUTELY NO WARRANTY. This is free software, and you are welcome to modify and redistribute it under the GPL license Server version 5.5.24-MariaDB Protocol version 10 Connection Localhost via UNIX socket UNIX socket /var/lib/mysql/mysql.sock Uptime: 57 min 47 sec Threads: 1 Questions: 34 Slow queries: 0 Opens: 41 Flush tables: 1 Open tables: 34 Queries per second avg: 0.009 |
MariaDB 5.5.24 YUM installed RPM packages
[root@centos62uek tools]# rpm -qa | grep MariaDB MariaDB-test-5.5.24-1.x86_64 MariaDB-compat-5.5.24-1.x86_64 MariaDB-shared-5.5.24-1.x86_64 MariaDB-server-5.5.24-1.x86_64 MariaDB-client-5.5.24-1.x86_64 MariaDB-common-5.5.24-1.x86_64 MariaDB-devel-5.5.24-1.x86_64 |
CentOS 6.2 with Oracle Unbreakable Enterprise Kernel based on 3.0.16 Linux kernel
[root@centos62uek tools]# uname -r 2.6.39-100.7.1.el6uek.x86_64 |
mydumper help output
[root@centos62uek tools]# mydumper --help Usage: mydumper [OPTION...] multi-threaded MySQL dumping Help Options: -?, --help Show help options Application Options: -B, --database Database to dump -T, --tables-list Comma delimited table list to dump (does not exclude regex option) -o, --outputdir Directory to output files to -s, --statement-size Attempted size of INSERT statement in bytes, default 1000000 -r, --rows Try to split tables into chunks of this many rows -c, --compress Compress output files -e, --build-empty-files Build dump files even if no data available from table -x, --regex Regular expression for 'db.table' matching -i, --ignore-engines Comma delimited list of storage engines to ignore -m, --no-schemas Do not dump table schemas with the data -k, --no-locks Do not execute the temporary shared read lock. WARNING: This will cause inconsistent backups -l, --long-query-guard Set long query timer in seconds, default 60 --kill-long-queries Kill long running queries (instead of aborting) -b, --binlogs Get a snapshot of the binary logs as well as dump data -D, --daemon Enable daemon mode -I, --snapshot-interval Interval between each dump snapshot (in minutes), requires --daemon, default 60 -L, --logfile Log file name to use, by default stdout is used -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads Number of threads to use, default 4 -C, --compress-protocol Use compression on the MySQL connection -V, --version Show the program version and exit -v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 |
myloader help output
[root@centos62uek tools]# myloader --help Usage: myloader [OPTION...] multi-threaded MySQL loader Help Options: -?, --help Show help options Application Options: -d, --directory Directory of the dump to import -q, --queries-per-transaction Number of queries per transaction, default 1000 -o, --overwrite-tables Drop tables if they already exist -B, --database An alternative database to restore into -e, --enable-binlog Enable binary logging of the restore data -h, --host The host to connect to -u, --user Username with privileges to run the dump -p, --password User password -P, --port TCP/IP port to connect to -S, --socket UNIX domain socket file to use for connection -t, --threads Number of threads to use, default 4 -C, --compress-protocol Use compression on the MySQL connection -V, --version Show the program version and exit -v, --verbose Verbosity of output, 0 = silent, 1 = errors, 2 = warnings, 3 = info, default 2 |
mydumper and myloader version info
[root@centos62uek tools]# mydumper --version mydumper 0.5.1, built against MySQL 5.5.24-MariaDB |
[root@centos62uek tools]# myloader --version myloader 0.5.1, built against MySQL 5.5.24-MariaDB |
vBulletin 4.2.0 PL1 test install with MariaDB 5.5.24