If you have troubles with kernel-headers in CentOS 5.2 like:
Error: Missing Dependency: kernel-headers is needed by package glibc-headers
Error: Missing Dependency: kernel-headers >= 2.2.1 is needed by package glibc-headers
install kernel headers:
#uname -a
Linux myserver 2.6.18-92.1.18.el5 #1 SMP Wed Nov 12 09:19:49 EST 2008 x86_64
for x86_64
#wget http://vault.centos.org/5.2/os/x86_64/CentOS/kernel-headers-2.6.18-92.el5.x86_64.rpm
#rpm -i kernel-headers-2.6.18-92.el5.x86_64.rpm
for i386
#wget http://vault.centos.org/5.2/os/i386/CentOS/kernel-headers-2.6.18-92.el5.i386.rpm
#rpm -i kernel-headers-2.6.18-92.el5.i386.rpm
Thursday, September 10, 2009
Wednesday, September 2, 2009
Enable mysql replication on production server
How to add slave mysql server without stopping master?
Bin-logging must be enabled on master. Then just dump all data from master:
Copy gzipped dump to slave. Ungzip and apply (mysql < yourfile.sql). Execute "slave start;" (slave must be configured for replication before this step :)
Bin-logging must be enabled on master. Then just dump all data from master:
mysqldump --defaults-file=/etc/mysql/debian.cnf -BA --master-data | gzip > /pathtogzipfile/filenameThis command dump all data from master and store master "binlog filename" and log position.
Copy gzipped dump to slave. Ungzip and apply (mysql < yourfile.sql). Execute "slave start;" (slave must be configured for replication before this step :)
Subscribe to:
Posts (Atom)