NYCPHP Meetup

[David Mintz]

Hello

I'm trying to learn to set up MySQL database replication with two boxes on
which I have sufficient privileges to play, one that would be master is
Win2K running 3.23.51-max-nt-log; the would-be slave, a RH 7.2 box running
3.23.52

I follow the directions in Paul DuBois' MySQL [4] book verbatim. (He says,
match server versions, like use 3.23.x with 3.23.x but he doesn't say
anyting about not trying it cross-platform.) I set up the master and
restart and it seems ok. I set up the slave configuration thus

[mysqld]
# stuff snipped
# slave config
server-id=2
master-host=mintzd.nysd.circ2.dcn
master-user=slave
master-password=deep.secret

and I get a lot of this:


Number of processes running now: 2
mysqld process hanging, pid 23568 - killed
/usr/bin/safe_mysqld: line 262: kill: (23568) - No such process
030701 17:57:52  mysqld restarted
/usr/bin/safe_mysqld: line 273: 23593 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --
basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION
--pid-file=$pid_file --skip-locking >>$err_log 2>&1

Number of processes running now: 1
mysqld process hanging, pid 23596 - killed
030701 17:57:54  mysqld restarted
/usr/bin/safe_mysqld: line 273: 23617 Segmentation fault
$NOHUP_NICENESS $ledir/$MYSQLD $defaults --
basedir=$MY_BASEDIR_VERSION --datadir=$DATADIR $USER_OPTION
--pid-file=$pid_file --skip-locking >>$err_log 2>&1

This goes on and on until I kill it.

So I comment out the slave configuration lines and try again, and all is
well. I've repeated this several times, and hypothesize that it doesn't
like being enslaved, but I can't figure out why.

Any clues greatly appreciated. Thanks!


---
David Mintz
http://davidmintz.org/
Email: See http://dmintzweb.com/whitelist.php first!

     "You want me to pour the beer, Frank?"