Uploaded image for project: 'MariaDB Server'
  1. MariaDB Server
  2. MDEV-8235

Feature Request: Expose functionality of check_slave_start_position

        Details

        • Type: Task
        • Status: Open
        • Priority: Minor
        • Resolution: Unresolved
        • Fix Version/s: None
        • Component/s: Replication
        • Labels:
          None

          Description

          The following c file...

          https://github.com/MariaDB/server/blob/d4e3aa4c6f4fb467b7f1adacd8ea9f71339cffe0/sql/sql_repl.cc

          Contains a function called check_slave_start_position. It would be useful to expose this, perhaps as a SQL function, in order to see if failover will function, at least from a GTID perspective.

          i.e.

          SELECT CHECK_SLAVE_START_POS('1-1-55');

          1. Returns true if binlog contains gtid, otherwise false

            Gliffy Diagrams

              Attachments

                Activity

                Ascending order - Click to sort in descending order
                Hide
                Permalink
                serg Sergei Golubchik added a comment -

                Kristian Nielsen, what do you think about it?

                Show
                serg Sergei Golubchik added a comment - Kristian Nielsen , what do you think about it?
                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

                > what do you think about it?

                I think such discussions belong on the mailing list, not in random jira comment ...

                Show
                knielsen Kristian Nielsen added a comment - > what do you think about it? I think such discussions belong on the mailing list, not in random jira comment ...
                Hide
                Permalink
                knielsen Kristian Nielsen added a comment -

                Wrt. the suggestion. check_slave_start_position() is an internal
                function. It does not seem too useful to expose as SQL to me. Its semantics
                is quite complicated.

                Maybe someone else would find it useful. It would require properly
                documenting what exactly its semantics is. It is not something I plan to
                work on...

                Show
                knielsen Kristian Nielsen added a comment - Wrt. the suggestion. check_slave_start_position() is an internal function. It does not seem too useful to expose as SQL to me. Its semantics is quite complicated. Maybe someone else would find it useful. It would require properly documenting what exactly its semantics is. It is not something I plan to work on...
                Hide
                Permalink
                rhyscampbell Rhys Campbell added a comment -

                @Kristian It's wrong to create a feature requests for a feature request?

                Shame. I think a lot of DBAs would like this. MySQL has a sort of similar ability....

                https://www.percona.com/blog/2014/05/19/errant-transactions-major-hurdle-for-gtid-based-failover-in-mysql-5-6/

                Thanks anyway.

                Show
                rhyscampbell Rhys Campbell added a comment - @Kristian It's wrong to create a feature requests for a feature request? Shame. I think a lot of DBAs would like this. MySQL has a sort of similar ability.... https://www.percona.com/blog/2014/05/19/errant-transactions-major-hurdle-for-gtid-based-failover-in-mysql-5-6/ Thanks anyway.

                  People

                  • Assignee:
                    Unassigned
                    Reporter:
                    rhyscampbell Rhys Campbell
                  • Votes:
                    0 Vote for this issue
                    Watchers:
                    2 Start watching this issue

                    Dates

                    • Due:
                      Created:
                      Updated: