• unknown's avatar
    WL#3629 - Replication of Invocation and Invoked Features · 62b41b5f
    unknown authored
    This changeset adds replication of events and user-defined functions. 
    There are several bug reports involved in this change:
    
    BUG#16421, BUG#17857, BUG#20384:
    This patch modifies the mysql.events table to permit the addition of
    another enum value for the status column. The column now has values
    of ('DISABLED','SLAVESIDE_DISABLED','ENABLED'). A status of
    SLAVESIDE_DISABLED is set on the slave during replication of events.
    This enables users to determine which events werereplicated from the 
    master and to later enable them if they promote the slave to a master.
    The CREATE, ALTER, and DROP statements are binlogged.
    A new test was added for replication of events (rpl_events).
    
    BUG#17671:
    This patch modifies the code to permit logging of user-defined functions.
    Note: this is the CREATE FUNCTION ... SONAME variety. A more friendly error 
    message to be displayed should a replicated user-defined function not be
    found in the loadable library or if the library is missing from the
    slave.The CREATE andDROP statements are binlogged. A new test was added 
    for replication of user-defined functions (rpl_udf). 
    
    The patch also adds a new column to the mysql.event table named
    'originator' that is used to store the server_id of the server that
    the event originated on. This enables users to promote a slave to a 
    master and later return the promoted slave to a slave and disable the
    replicated events.
    
    
    mysql-test/lib/init_db.sql:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the SLAVESIDE_DISABLED to the list of enumerated 
      values for the mysql.event table.
      
      This patch adds the column 'originator' to the mysql.event table.
    mysql-test/r/events.result:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the 'originator' column to the events test results.
      This was necessary to ensure the manual insert into mysql.event table 
      succeeds because the originator column is set to NOT NULL.
    mysql-test/r/events_grant.result:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the 'originator' column to the events_grant test results.
      This was necessary to ensure the manual insert into mysql.event table 
      succeeds because the originator column is set to NOT NULL.
    mysql-test/r/events_restart_phase1.result:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the 'originator' column to the events_restart_phase1
      test results. This was necessary to ensure the manual insert into 
      mysql.event table succeeds because the originator column is set to 
      NOT NULL.
    mysql-test/r/system_mysql_db.result:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the SLAVESIDE_DISABLED to the list of enumerated 
      values for the mysql.event table.
      
      This patch adds the column 'originator' to the mysql.event table.
      
      These changes to the result file were necessary to ensure correct test
      results.
    mysql-test/t/events.test:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the 'originator' column to the events
      test. This was necessary to ensure the manual insert into 
      mysql.event table succeeds because the originator column is set to 
      NOT NULL.
    mysql-test/t/events_restart_phase1.test:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the 'originator' column to the events_restart_phase1
      test. This was necessary to ensure the manual insert into 
      mysql.event table succeeds because the originator column is set to 
      NOT NULL.
    scripts/mysql_create_system_tables.sh:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the SLAVESIDE_DISABLED to the list of enumerated 
      values for the mysql.event table.
      
      This patch adds the column 'originator' to the mysql.event table.
    scripts/mysql_fix_privilege_tables.sql:
      WL#3629 - Replication of Invocation and Invoked Feature
      This patch adds the SLAVESIDE_DISABLED to the list of enumerated 
      values for the mysql.event table.
      
      This patch adds the column 'originator' to the mysql.event table.
    sql/event_data_objects.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to permit processing of the new enum
      SLAVESIDE_DISABLED which is set on the slave during replication
      of events. 
      
      This patch uses the new Event_basic:: enumerated values.
    sql/event_data_objects.h:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch moves the duplicated enumeration values for ENABLED, 
      SLAVESIDE_DISABLED, and DISABLED to the Event_basic class removing
      them from the other Event_* classes.
    sql/event_db_repository.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to permit processing of the new enum
      SLAVESIDE_DISABLED which is set on the slave during replication
      of events. 
      
      The patch also adds a new column to the mysql.event table named
      'originator' that is used to store the server_id of the server that
      the event originated on. This enables users to promote a slave to a 
      master and later return the promoted slave to a slave and disable the
      replicated events.
    sql/event_db_repository.h:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to add a new field named 'originator' 
      to the enum_event_table_field and associated structure.
    sql/event_queue.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to permit processing of the new enum
      SLAVESIDE_DISABLED which is set on the slave during replication
      of events.
    sql/events.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to permit processing of the new enum
      SLAVESIDE_DISABLED which is set on the slave during replication
      of events.
    sql/lex.h:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to add the new SLAVESIDE_DISABLE symbol
      to the lexical parser.
    sql/slave.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to permit the capture of the error on
      the slave when a UDF from a loadable library is not loaded on the server
      when replicated from the master.
    sql/sql_parse.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch removes the comment because drop functions commands 
      are replicated.
    sql/sql_show.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to permit processing of the new enum
      SLAVESIDE_DISABLED which is set on the slave during replication
      of events. The code also adds changes the display width of the status
      column for the schema table for the show events command and also adds
      the new column 'originator' to the events_field_info structure.
    sql/sql_udf.cc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to add the binlogging of the create and
      drop function events.
    sql/sql_yacc.yy:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch modifies the code to change the enumeration of the status
      column for the events in the parser. The code uses the Event_basic::
      enumerations allowing the enums to be defined in one place.
    mysql-test/t/rpl_events.test:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch adds a new test for testing replication of events. The test
      uses include files so that the test can test under both RBR and SBR.
    mysql-test/r/rpl_events.result:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch adds a new result file for testing replication of events.
    mysql-test/r/rpl_udf.result:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch adds a new result file for testing replication of UDFs.
    mysql-test/t/rpl_udf.test:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch adds a new test for testing replication of UDFs. The test
      uses include files so that the test can test under both RBR and SBR.
    mysql-test/include/rpl_events.inc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch adds a new include file for testing replication of events.
      This file contains the core test procedures.
    mysql-test/include/rpl_udf.inc:
      WL#3629 - Replication of Invocation and Invoked Features
      This patch adds a new include file for testing replication of UDFs.
      This file contains the core test procedures.
    62b41b5f
events.test 15.6 KB