wsrep_notify_cmd to use bash rather than sed

[Daniel Black]

Having a notify_cmd example that shows explicitly where the uuid, name, incoming_address are and how to extract them without sed is useful.

I've also added a timestamp as minor enhancement.

There was also an excess ";' in the BEGIN.

There are DELETE FROM tables where the tables are only just created.

To allow for future changes of extra parameters in the script lets just omit them for now.

[Nilnandan Joshi (nilnandan-joshi)]

Checked on PXC 5.5 and 5.6

{code}
BEGIN;
DELETE FROM $MEMB_TABLE;
DELETE FROM $STATUS_TABLE;
"
END="COMMIT;"

configuration_change()
{
    echo "$BEGIN;"

    local idx=0

    for NODE in $(echo $MEMBERS | sed s/,/\ /g)
    do
        echo "INSERT INTO $MEMB_TABLE VALUES ( $idx, "
        # Don't forget to properly quote string values
        echo "'$NODE'" | sed s/\\//\',\'/g
        echo ");"
        idx=$(( $idx + 1 ))
    done

    echo "INSERT INTO $STATUS_TABLE VALUES($idx, $INDEX, '$STATUS', '$CLUSTER_UUID', $PRIMARY);"

    echo "$END"
}
{code}

[Shahriyar Rzayev (rzayev-sehriyar)]

Percona now uses JIRA for bug reports so this bug report is migrated to: https://jira.percona.com/browse/PXC-1174