I need to adjust the innodb_buffer_pool_size of my master and slave mysql database servers, both are running on independent boxes. On the slave if I issue "stop slave" i'm still not able to /etc/init.d/mysql stop to make the my.cnf change (Debian Lenny).
/etc/init.d/mysql stop
Stopping MySQL database server: mysqld failed!
and
/etc/init.d/mysql reload
Reloading MySQL database server: mysqld/usr/bin/mysqladmin: connect to server at 'localhost' failed
error: 'Access denied for user 'debian-sys-maint'@'localhost' (using password: YES)'
How can you properly lock the replication state to make the changes on both then bring them back up? Do I need to reset slave then tell it the master's log position again?