WL#3657: INFORMATION SCHEMA table for SHOW MASTER STATUS

Affects: Server-7.0 — Status: Un-Assigned — Priority: Low

Implement an information schema for the information returned by SHOW MASTER STATUS.

(directly related to WL#3656)

Benefits:
- the information on master status can be searched with ad hoc queries;
- pieces of that info can be assigned to variables, and thus used in stored
procedures;

If both this WL and WL#3656 are implemented, it will be possible for a slave to
have complete control of its replication status, by means of a FEDERATED table
to the MASTER STATUS table of its master.

Implemented as plugin in this project:
https://launchpad.net/is-replication-status

You must be logged in to tag this worklog

On Aug 5, 2009 @ 10:35, Markweee said:

Result Set from a 'SELECT' in a variable, not a SELECT that's hard-coded in the DECLARE CURSOR statement. fire degree AND Bachelor degrees AND online Masters degree

On Aug 5, 2009 @ 10:35, Markweee said:

FETCH statements that bring in exactly the number of columns in the 'SELECT' result set, instead of the fixed number that MySQL has now with "FETCH c INTO v1,v2,v3;". online doctoral degree AND business degree

On Aug 5, 2009 @ 03:09, mwkme said:

Any Updates- Also I wonder if this is what Bob was talking about~ thanks I need to talk with him he understand it a lot more Jidoka definition

On Feb 10, 2009 @ 18:03, Pat Thomas said:

looking forward to an update on this project

On Feb 2, 2009 @ 11:19, Pat Thomas said:

This is one that I need to watch for progress. Look forward to reading an update on this topic.

Pat.

Votes

  • Rated 5.00 out of 5
Rated 5.00 out of 5 with 4 votes cast.
You must be logged in to vote.

Watches

5 members are watching this worklog
You must be logged in to track this worklog.

Provide Feedback

Please note:
HTML will be purified, but we allow for a number of HTML tags so that you have the flexibility to decorate your comment text to some extent. The comments allow the following HTML tags:

strong, b, em, blockquote, a, code, pre

To put code into your comment, simply encapsulate your code with
[code language="XXX"][/code], where XXX is any common language, for instance "PHP", "SQL", "C", etc.

You must be logged in to comment