It’s another new year by Jewish calendar. And what do I wish for in the following year?
- World peace
- Good health to all
- Have some way to turn SHOW commands into SELECT statements, server side. I’m fervently trying to hack around this. Stored routines, export/import from file, text manipulation, I don’t care! I want to SELECT seconds_behind_master somehow. Without plugins.
PS, none of my last year’s wishes came true. I’ll settle for two out of three.
Dear Shlomi, I finally did a Perl solution that is quite an awful hack, but it works… Interested?
@Jim,
Thanks, however I’m looking for a server side solution: from within the mysql server itself. Or have you managed to somehow invoke perl from the server?
I don’t mind the least about ugly solutions. Anything can be wrapped to present well.
Happy New Year !
שנה טובה !
Hope this will be a great new year for all dba 🙂
You mean you want https://launchpad.net/is-replication-status included in mainline.
Yes, but automatically, and for ANY “show” command.
I’m aware of this why-didn’t-they-think-of-this plugin, have wondered why this was not imported into the baseline…