mysql

yum install php-mysql
yum install mysql-server
chkconfig mysqld on
service mysqld start
mysqladmin -u root password '**********'
select host,user,password from mysql.user;
delete from mysql.user where user=""; 
set password for root@'127.0.0.1' = PASSWORD('**********');
set password for root@'host.zenno.net' = PASSWORD('**********');

レプリケーション †

参考 　現場指向のレプリケーション詳説　・ 　KAWANO's PukiWiki - MySQLでのレプリケーションの設定

マスター

cat /etc/my.cnf
[mysqld]
log-bin=/var/lib/mysql/mysqld-bin
server-id=10
binlog_do_db=sqlgrey

スレーブ

cat /etc/my.cnf
[mysqld]
server-id=11
# master-host=192.168.0.143
# master-user=USERNAME
# master-password=PASS
replicate_do_db=sqlgrey
relay-log=/var/lib/mysql/mysqld-relay-bin
relay-log-index=/var/lib/mysql/mysqld-relay-bin

REPLICATION SLAVE 権限の設定を忘れず

==MASTER===========
mysql> RESET MASTER; #再構築の場合 

cd /var/lib/mysql
tar cpf /var/tmp/mysql-snapshot.tar ./sqlgrey

mysql> FLUSH TABLES WITH READ LOCK;

tar cpf /var/tmp/mysql-snapshot.tar ./sqlgrey

mysql> SHOW MASTER STATUS;  **** 743690 ****
mysql> UNLOCK TABLES;


==SLAVE============

service mysqld stop
cd /var/lib/mysql
rm -fr sqlgrey
tar xpf mysql-snapshot.tar

service mysqld start

mysql> CHANGE MASTER TO
mysql> MASTER_HOST = '192.168.0.142',
mysql> MASTER_USER = 'USERNAME',
mysql> MASTER_PASSWORD = 'PASS',
mysql> MASTER_LOG_FILE = 'mysqld-bin.000001',
mysql> MASTER_LOG_POS = 743690;   #******

mysql> START SLAVE;

mysql> SHOW MASTER STATUS\G
mysql> SHOW SLAVE STATUS\G

マスターログの削除

PURGE MASTER LOGS TO 'mymaster-bin.003';