Oracle^® Solaris Cluster Data Replication Guide for MySQL

Debugging the MySQL Replication Configuration

This section describes how to set different debugging methods for the MySQL replication configuration.

• Debugging the replication status resource by obtaining extensive logging and a Korn shell trace.

  In the file /opt/SUNWscmys/geocontrol/etc/config, set the variable SET_DEBUG to ALL or set it to the replication component that you are debugging on the node that you want to debug. On this node, call the probe script that you want to debug.

  ksh -x /opt/SUNWscmys/geocontrol/bin/mysql_geo_replication 
  -R rep-rs -G rep-rg -r mysql-rs -g mysql-rg probe

• Debugging the script-based plug-ins control scripts by obtaining extensive logging and a Korn shell trace for a script.

  • In the file /opt/SUNWscmys/geocontrol/etc/config, set the variable SET_DEBUG to ALL or set it to the replication component that you are debugging on the node that you want to debug. On this node, call the SBP control script that you want to debug.

    ksh -x /opt/SUNWscmys/geocontrol/bin/mysql_geo_control 
    -O mysql-comp -r rep-rs -g rep-rg -R mysql-rs -G mysql-rg -t 10 -T 60 
    -o paris:mysqlex1,paris:mysqlre2,newyork:mysqlex2,newyork:mysqlre1 
    function=create_configuration pg=mysql-pg validate_parameters=true 
    currentRole=PRIMARY is Modify=false

  • To obtain all the SBP controls and its parameters, scan the common agent container log.

    /var/cacao/instances/default/logs