txyoji's questions

I have a MySQL master-slave setup. One master; One slave; Lots of databases.

I'm moving an app into this setup from third party. They provided a mysqldump file of the data and database structure. It contains a single database with innodb tables.

The dump file loads just fine on the master. But while is replicating to the slave, the slave gets hung up on a foreign key error.

It seems like the slave is ignoring the 'set foreign key checks' in the mysqldump.

How do I load this thing without breaking replication?

Running "sudo serivce httpd status" shows only a single process id. The root process. However, if I use top or ps, I can see there are more process than that. Apache is in prefork mode.

Has anyone seen this behavior before from Apache2?

I'd like to understand why the status command can't find the other processes.