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

LP #904287: pt-online-schema-change replication support idea

Details

    • Bug
    • Status: Done
    • Low
    • Resolution: Invalid
    • None
    • None
    • None

    Description

      **Reported in Launchpad by Michaƫl de Groot last update 16-12-2011 15:49:32

      Hi,

      I'm not too good at perl myself, but I have an idea to make pt-online-schema-change support row based replication; it's quite easy.

      There ar, as far as I have noticed, 2 problems when running pt-online-schema-change in replication:
      1. Master performance may differ from slave performance, therefor you cannot just replicate it
      2. osc cannot influence binlog state from within a trigger

      My idea is this:
      Instead of just locally creating the temp table, first create a BLACKHOLE table with sql_log_bin=1. Then, after setting sql_log_bin=0, alter the tmp table to the correct engine.

      1 problem arises: You still cannot alter table on both the slaves and the master at the same time. To fix this, you should put (for example) the MySQL server id of the current server in the generated tmp table name.

      If my perl skills were better I would have implemented it.

      Thanks

      Attachments

        Activity

          People

            Unassigned Unassigned
            lpjirasync lpjirasync (Inactive)
            Votes:
            0 Vote for this issue
            Watchers:
            1 Start watching this issue

            Dates

              Created:
              Updated:
              Resolved:

              Smart Checklist