Uploaded image for project: 'Percona Toolkit'
  1. Percona Toolkit
  2. PT-1417

LP #1673399: Inconsistent creation of toolkit tables

    XMLWordPrintable

    Details

    • Type: Epic
    • Status: On Hold
    • Priority: Low
    • Resolution: Unresolved
    • Affects Version/s: None
    • Fix Version/s: None
    • Component/s: None

      Description

      **Reported in Launchpad by Ceri WIlliams last update 04-09-2017 13:46:54

      A number of the tools will write to a table, which in a replication scenario would require the slaves to contain the same table to avoid replication breakage (assuming no filters).

      pt-table-checksum for example will use CREATE DATABASE IF NOT EXISTS and checks the slaves.

      Please ensure that any of the tools that can write to a table also check that the schema exists and either completely fail to run (acceptable as safe) and give an error, or ensure that the schema and tables are created in a replication-safe manner.

      The following shows those scripts that contain a CREATE TABLE compared against those that contain a CREATE DATABASE:

       @@ -1,16 +1,4 @@
       -/usr/bin/pt-archiver
       -/usr/bin/pt-deadlock-logger
       -/usr/bin/pt-duplicate-key-checker
       -/usr/bin/pt-find
       -/usr/bin/pt-fingerprint
       -/usr/bin/pt-fk-error-logger
       -/usr/bin/pt-heartbeat
       /usr/bin/pt-index-usage
       -/usr/bin/pt-kill
       -/usr/bin/pt-mysql-summary
       -/usr/bin/pt-online-schema-change
       /usr/bin/pt-query-digest
       /usr/bin/pt-table-checksum
       -/usr/bin/pt-table-sync
       -/usr/bin/pt-table-usage
       /usr/bin/pt-upgrade

        Smart Checklist

          Attachments

            Issue Links

              Activity

                People

                • Assignee:
                  carlos.salguero Carlos Salguero
                  Reporter:
                  lpjirasync lpjirasync (Inactive)
                • Votes:
                  0 Vote for this issue
                  Watchers:
                  6 Start watching this issue

                  Dates

                  • Created:
                    Updated:

                    Time Tracking

                    Estimated:
                    Original Estimate - Not Specified
                    Not Specified
                    Remaining:
                    Remaining Estimate - Not Specified
                    Not Specified
                    Logged:
                    Time Spent - 3 days
                    3d