This release fixes a few bugs, adds minor features, and adds some debugging support to shared code. I’m working on the Nibble sync algorithm for mk-table-sync, and someone has found a few more bugs with mk-parallel-dump, but those might take me a while to complete.
Changelog for mk-archiver: 2007-12-16: version 1.0.5 * Updated common code. Changelog for mk-deadlock-logger: 2007-12-16: version 1.0.7 * Updated common code. Changelog for mk-duplicate-key-checker: 2007-12-16: version 1.1.4 * --tables and --ignoretables now accept names in the form db.tbl. Changelog for mk-find: 2007-12-16: version 0.9.9 * Updated common code. Changelog for mk-heartbeat: 2007-12-16: version 1.0.4 * Updated common code, added debugging. Changelog for mk-parallel-dump: 2007-12-16: version 1.0.2 * Added debugging. * Updated common code. * --tables and --ignoretables now accept names in the form db.tbl. Changelog for mk-parallel-restore: 2007-12-16: version 1.0.2 * Updated common code. Changelog for mk-query-profiler: 2007-12-16: version 1.1.8 * Updated common code, added debugging. Changelog for mk-show-grants: 2007-12-16: version 1.0.7 * Updated common code, added debugging. Changelog for mk-slave-delay: 2007-12-16: version 1.0.4 * Updated common code, added debugging. Changelog for mk-slave-restart: 2007-12-16: version 1.0.4 * Updated common code, added debugging. Changelog for mk-table-checksum: 2007-12-16: version 1.1.22 * --replicate did not store chunk boundaries correctly (bug #1850243). * --tables and --ignoretables now accept names in the form db.tbl. Changelog for mk-table-sync: 2007-12-16: version 1.0.1 * Empty strings were not quoted (bug #1848431). * --tables and --ignoretables now accept names in the form db.tbl. Changelog for mk-visual-explain: 2007-12-16: version 1.0.6 * Updated common code, added debugging.Technorati Tags:No Tags
Have you considered writing a “schema diff” tool? ie Compare the schemas of two tables and output the SQL alter table commands needed to convert one into the other.
The company I work for has tried a few commercial solutions and they all tend to fail badly in even trivial cases.
No promises, but I might be able to get something contributed to one of your bounties if you were interested in taking this on…
That one is on the list for one of these days when I have too much time on my hands, yes :-)
I would like to integrate your tools in my project : http://support.intellisoftsystems.com/projects/show/5
My original plan was to build an administrative/monitoring tool only for MySQL but I think it is better to start more generic.Anyway MySQL will be an important aspect of this administration tool :)
Even if I would like to see tools like these written directly in Java, it will be better to integrate your tools, at least at the beginning ;)
The only problem I see here is the output of your scripts. Since the output will target the user, it will be dificult to “tail” you output and build a progress report, or even a final report.
Do you think it will be possible to have a switch to output a “machine readable format”? :)
Right now there is no road map, but probably in version 0.2 I will add a task to integrate your tools. I’m planning to have some API to build agents which collects informations about servers/services.
Any opinions are welcomed.
I mentioned your tools here :)
http://support.intellisoftsystems.com/wiki/5/SimilarApplications
My goal has always been that output should be usable in traditional Unix-style scripting, so you can use awk, sed, grep etc to build more complex scripts. If you’re asking for XML output, that is very unlikely :-)
I was afraid of that :)
I presume the output format will not change very offen, right? So we will not need to change the parser for every release.
I will post a comment here when I will have a first stable version.
Thanks.
Hi Baron,
the debian package should include a “Replaces : mysqltoolkit” line in the control file so for those who update from the older pre-renamed package don’t end with two different installed versions of maatkit (there’s no real conflict though due to the change of names, but it would be more elegant).
Hi Tanj, that sounds like a good idea. Would you mind submitting a patch via the Sourceforge bug tracker?
Thanks
Baron
This tool is great….recently though I ran into an issue with version 1508.
When i run the command below
mk-table-sync \ u=root,p=password,h=localhost,S=/tmp/mysql_sandbox3310.sock,D=4_4_dev_latin1,t=address \
u=root,p=password,h=localhost,S=/tmp/mysql_sandbox3310.sock,D=4_4_utf8,t=address \ -p
It returns “Commands out of sync; you can’t run this command now at line 974 while doing 4_4_utf8.address”.
What does this mean?
Troy
It’s a bug. Please report it in the Tracker at http://sourceforge.net/projects/maatkit/
Thanks for the bug report. I posted a reply but since you weren’t logged in when you added the bug report, you probably won’t notice. I’m going to need some more information. At least the output of SHOW CREATE TABLE, and possibly the output from running it with MKDEBUG=1.
Cheers
Baron