Topic: mydumper

Hi, I tried to build mydumper v0.5.1 but got this error:

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
CMakeFiles/mydumper.dir/binlog.c.o: In function `get_binlog_file':
/root/mydumper-0.5.1/binlog.c:160: undefined reference to `my_net_read'
collect2: ld returned 1 exit status
make[2]: *** [mydumper] Error 1
make[1]: *** [CMakeFiles/mydumper.dir/all] Error 2
make: *** [all] Error 2

It is a known bug listed as "won't fix" in their bugtracker (with reason explained)
https://bugs.launchpad.net/mydumper/+bug/803982

Do you have any interest to work around this issue in your repository?
I am already using your version of MySQL v5.5.22

Thanks,
Per Hansson

Re: mydumper

Try with version 5.5.23 which will be tomorrow in remi repo
I have exported my_net_read to be available.

mydumper build fine (haven't test it more)

Desktop: Fedora 29 x86_64 + rpmfusion + remi-test + remi-dev
Laptop:  Fedora 30 x86_64 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 6.10 x86_64 with EPEL, remi, remi-php72 and remi-php72-test

Re: mydumper

Thanks, I tested it and it's working fine on my CentOS x64 v6.2 testserver.
I did not check the consistency yet though, but here are performance numbers of a small 1.3GB database:

mydumper v0.5.1: 1m9s
mysqldump: 1m30s

Please note that this server I'm using is not excellent at showing the benefit of mydumper, it is a dual core Intel Paxville 2.8Ghz machine with a slow WDC WD800JD-75HKA1 harddrive (80GB 7200RPM SATA)

Do you have any interest in adding mydumper to the Remi repository?
Because it requires allot of dependencies to build it but I think most of those are not necceasry for running it?

Regards,
Per Hansson

Re: mydumper

Per Hansson wrote:

Do you have any interest in adding mydumper to the Remi repository?

Probably, but I have already a lot of stuff, so need to find some time...

Desktop: Fedora 29 x86_64 + rpmfusion + remi-test + remi-dev
Laptop:  Fedora 30 x86_64 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 6.10 x86_64 with EPEL, remi, remi-php72 and remi-php72-test

Re: mydumper

Probably you are lucky (or I'm extremely kind)
See mydumper-0.2.3

N.B. I cannot do this for all requests, but I want to test this tool.

Desktop: Fedora 29 x86_64 + rpmfusion + remi-test + remi-dev
Laptop:  Fedora 30 x86_64 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 6.10 x86_64 with EPEL, remi, remi-php72 and remi-php72-test

Re: mydumper

Very very nice, thank you!
Do you have any interest to include the development version 0.5.1 aswell?
The nice thing with it is that it has a daemon mode for example...

Regards,
Per Hansson

7 (edited by Per Hansson 2012-05-10 19:03:11)

Re: mydumper

We are running mydumper v0.2.3 from your repository live with a custom backup script on our website now.
Performance is great!
Just 27 seconds to dump a mixed Innodb/MyISAM database 2.4GB in size...

"mysqldump" does the same database in 45 seconds. (So "mydumper" it's 65% faster put another way...)
However since it's mixed Innodb & MyISAM mysqldump needs to lock it for the duration of the dump.
mydumper does not, it's only locked while dumping the MyISAM tables, then during the Innodb it is unlocked...
This behavior is possible to get in mysqldump with --single-transaction but then it DOES NOT guarantee database consistency which is kind of the reason to do a backup in the first case wink

Thank you again for including it!

Re: mydumper

I was try to built it with this 5.5.23.. But there is any error which can't resolved by me after a lots of efforts...

Re: mydumper

@alexemil5 : just use the provided rpm.

Desktop: Fedora 29 x86_64 + rpmfusion + remi-test + remi-dev
Laptop:  Fedora 30 x86_64 + rpmfusion + remi (SCL only)
Hosting Server: CentOS 6.10 x86_64 with EPEL, remi, remi-php72 and remi-php72-test

Re: mydumper

Yeah, It is done with support of 5.5.23 version. I have tried.