Filed with Developers Support MyDumper (Faster MySQL dumping) [Case 59373]

[fkatzenb]

People! How about more support for this feature!

[sardelich]

+1 you have my vote

[cPanelDavidG]

I have discussed this with our Product Manager. Please read my call for comments below to ensure you are okay with our proposal before we move forward .

Call for Comments
Mydumper has demonstrated an ability to dump databases faster, and when used with myloader, can restore those dumps faster. This performance enhancement is the primary reason for moving to Mydumper wherever possible for MySQL dumping. Note that Mydumper is not a drop-in replacement, but rather a completely separate utility cPanel would distribute with its software to handle imports and exports of data triggered by cpsrvd and scripts wholly built and maintained by cPanel (e.g. not PhpMyAdmin).

Mydumper would be used with the following understandings:
- Such dumps would be natively incompatible with MySQL's native utilities. Therefore Myloader must be used to load dumps from Mydumper, especially onto prior versions of cPanel&WHM where this is not supported.
- Mydumper is currently incompatible with MySQL 5.5

These limitations are understood and accepted due to the resulting performance gain this would generate.

[eva2000]

Yeah mydumper doesn't seem to work with MySQL 5.5 right now with undefined reference to `my_net_read' error https://bugs.launchpad.net/mydumper/+bug/803982 which is a shame. But it's works fine with MariaDB 5.2.x which i used for the tests above. So another reason for MariaDB MySQL support in WHM/Cpanel http://forums.cpanel.net/f145/mariad...-a-190492.html

[Kent Brockman]

Yeah mydumper doesn't seem to work with MySQL 5.5 right now with undefined reference to `my_net_read' error https://bugs.launchpad.net/mydumper/+bug/803982 which is a shame. But it's works fine with MariaDB 5.2.x which i used for the tests above. So another reason for MariaDB MySQL support in WHM/Cpanel http://forums.cpanel.net/f145/mariad...-a-190492.html

Unfortunately, I see the bug status for this have been "won't fix": https://bugs.launchpad.net/mydumper/+bug/803982 Really a shame

[cPanelDavidG]

I have submitted the above call for comments to our developers. The case number for this appears in the title of this thread.

[eva2000]

Unfortunately, I see the bug status for this have been "won't fix": https://bugs.launchpad.net/mydumper/+bug/803982 Really a shame

Remi repository managed to fix this by exporting my_net_read back into their Remi MySQL 5.5 builds see thread at mydumper (Page 1)

but also one in MariaDB KB https://kb.askmonty.org/en/mariadb-5...-with-mydumper - onus is on Mydumper folks i think.

[eva2000]

Managed to build my own MariaDB 5.5.23 RPM for CentOS 6.2 64bit with working mydumper installation http://vbtechsupport.com/1966/. Testing it out now