Database: November 2003 Archives

I was working on installing Bugzilla and ran into an error when installing DBD::MySQL module:
usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm line 97. Unsuccessful stat on filename containing newline at /usr/lib/perl5/5.8.0/ExtUtils/Liblist/Kid.pm

If you run into this error, run:
export LANG=C
and then do the following:
perl Makefile.PL
make
make install

(ignore all the warning messages, during make and make install).

Consider the following scenario:
Master's IP address has been changed and the slave needs to be reconfigured for the New IP address.

How do we go about doing it ? Two ways.
One of them a bit hackish but the most
simple:

- Shut down slave MySQL server.
- Find master.info file, store current one in the backup and edit it
replacing the host name with new host name.
- Start slave MySQL server.

Second one is more complex but using only SQL commands:

- Run SLAVE STOP to stop slave thread;
- Run SHOW SLAVE STATUS and record the position in the master binary log
slave is currently located
- use CHANGE MASTER TO to point slave to the same position on the
different hostname
- Use SLAVE START to start slave back again.

We cannot change the IP that easily. We need to do things so complex since MySQL assumes we are
replicating from new slave if you're changing host name and resets all
other parameters.