Issue :
    =======
      By default in MTR, currently all the test runs with show_compatibility_56=ON. In this work-log,
      we have aimed to test all the non- replication testcases with show_compatibility_56=OFF. By
      turning this feature OFF, we are no more using IS for accessing global and session variables
      and instead PS tables are used.

    Fix :
    =====

     The fix involves making changes in the default_mysqld.cnf file to run all the MTR suites (except replication)
     with show_compatibility_56=OFF. Replication tests are explicitly run with show_compatibility_56=ON either from
     within the test or through opt file. No changes are made to ndb suite and it still runs with IS.

Reviewed-by: Anitha Gopi <anitha.gopi@oracle.com>
Reviewed-by: Christopher Powers <chris.powers@oracle.com>
    RB: 11095