Friday, July 16, 2010

Creating ISO image of Installed OS

When you want to create the ISO image of Installed OS use the following command.

mkisofs -force-rr -m /proc -m /sys -o file.iso / [proc and sys are excluded intentionally]


To test this use the following

mount -o loop file.iso /mnt

Friday, July 9, 2010

log-slave-updates

Normally, a slave does not log to its own binary log any updates that are received from a master server. This option tells the slave to log the updates performed by its SQL thread to its own binary log. For this option to have any effect, the slave must also be started with the --log-bin option to enable binary logging. --log-slave-updates is used when you want to chain replication servers.

For example, you might want to set up replication servers using this arrangement:

A -> B -> C
Here, A serves as the master for the slave B, and B serves as the master for the slave C. For this to work, B must be both a master and a slave. You must start both A and B with --log-bin to enable binary logging, and B with the --log-slave-updates option so that updates received from A are logged by B to its binary log.

[ref: http://dev.mysql.com/doc/refman/5.1/en/replication-options-slave.html]