ig
?
# Set mysql replication
# master db
cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
sed -i "s@server-id\t= 1@server-id? ? ? = 101@g" /etc/my.cnf
sed -i "s@#log-bin=mysql-bin@log-bin=mysql-bin@g" /etc/my.cnf
sed -i "s@#binlog_format=mixed@binlog_format=mixed@g" /etc/my.cnf
# slave db
cp /usr/local/mysql/support-files/my-small.cnf /etc/my.cnf
sed -i "s@server-id\t= 1@server-id? ? ? = 103@g" /etc/my.cnf
?
# read errors from logs
cat /usr/local/mysql/data/`hostname`.err
?
# Some reference
# server-id = 101
# log-bin=/usr/local/mysql/data/bin-log
# max_binlog_size = 1500M
# binlog_cache_size = 128K
# binlog-do-db = devdbops
# binlog-ignore-db = mysql
# log-slave-updates
# expire_logs_day=2
# binlog_format=mixed
?
# end mysql temporarily
kill -TERM `ps -ef | awk '/mysqld_safe/ && ! /awk/ {print $2}'` || kill -KILL `ps -ef | awk '/mysqld_safe/ && ! /awk/ {print $2}'`
ps -ef | awk '/mysqld_safe/ && ! /awk/ {print $2}'
kill -TERM `ps -ef | awk '/mysqld/ && ! /awk/ {print $2}'` || kill -KILL `ps -ef | awk '/mysqld/ && ! /awk/ {print $2}'`
ps -ef | awk '/mysqld/ && ! /awk/ {print $2}'
?
# Setting sysvinit
cp /usr/local/mysql/support-files/mysql.server /etc/init.d/mysql
chmod +x /etc/init.d/mysql
?
# Start mysql database
service mysql start
service mysql status
?
# some operation about replicaion
# master db
GRANT ALL PRIVILEGES ON *.* TO root@"%" IDENTIFIED BY "root";
FLUSH PRIVILEGES;
CREATE USER 'dev'@'%' IDENTIFIED BY 'dev';
CREATE DATABASE IF NOT EXISTS devdbops;
GRANT ALTER,ALTER ROUTINE,CREATE,CREATE ROUTINE,CREATE TEMPORARY TABLES,CREATE VIEW,DELETE,DROP,EXECUTE,INDEX,INSERT,LOCK TABLES,SELECT,UPDATE,SHOW VIEW ON devdbops.* TO 'dev'@"%";
USE devdbops;
CREATE TABLE `testtable` (
`id`? int NOT NULL ,
`name`? varchar(255) NULL ,
`value`? varchar(255) CHARACTER SET utf8 COLLATE utf8_general_ci NULL ,
PRIMARY KEY (`id`)
)
;
INSERT INTO `testtable` (`id`, `name`, `value`) VALUES ('0', 'a', 'b');
# CREATE USER 'repl'@'%.mydomain.com' IDENTIFIED BY 'slavepass';
# GRANT REPLICATION SLAVE ON *.* TO 'repl'@'%.mydomain.com';
# CREATE USER 'repl'@'%' IDENTIFIED BY 'slavepass';
# GRANT REPLICATION SLAVE ON devdbops.* to 'replication'@'%';
SHOW MASTER STATUS;
SHOW PROCESSLIST \G;
SHOW SLAVE HOSTS;
QUIT;
?
# slave db
STOP SLAVE;
CHANGE MASTER TO MASTER_HOST='192.168.1.101',MASTER_USER='root',MASTER_PASSWORD='root',MASTER_LOG_FILE='mysql-bin.000002',MASTER_LOG_POS=107;
START SLAVE;
SHOW SLAVE STATUS \G;
?
# Read for test
tag:mysql主从配置,mysql添加从库,mysql备份视图函数,mysql备份脚本,Linux安装mysql
--end--
|