Warning of MySQL Replication

The basic idea of MySQL replication is both master and slave execute the same SQL.

When master and slave located in different timezones, please do not use Date and Time function.

For instance, update table set aa=bbb where date>CURRENT_DATE;

CURRENT_DATE will return different value in different timezone.


make .my_history more readable:

$sed  's/\\040/ /g' .mysql_history  > myhist
$sed -i 's/\\134/\\/g' myhist

"-i" here means replace in place!