PATH=$PATH:/usr/libexec/git-core
以上是github https 错误。
GRANT ALL PRIVILEGES ON . TO ‘root’@’%’ IDENTIFIED BY ” WITH GRANT OPTION;
FLUSH privileges;
安装Go语言环境(Go版本1.3以上)
git clone https://github.com/flike/kingshard.git src/github.com/flike/kingshard
cd src/github.com/flike/kingshard
source ./dev.sh
make
设置配置文件
./bin/kingshard -config=etc/ks.yaml
./bin/kingshard -config=etc/ks.yaml –fork 后台运行
开启多mysql实例
Create the file mysqld@.service in the /etc/systemd/system/
[Unit]
Description=MySQL Multi Server for instance %i
After=syslog.target
After=network.target
[Service]
User=mysql
Group=mysql
Type=forking
ExecStart=/usr/bin/mysqld_multi start %i
ExecStop=/usr/bin/mysqld_multi stop %i
Restart=always
PrivateTmp=true
[Install]
WantedBy=multi-user.target
/etc/my.cnf
[mysqld_multi]
mysqld = /usr/bin/mysqld_safe --basedir=/usr
[mysqld1]
port=63132
datadir=/var/lib/mysql/1/
socket=/var/lib/mysql/1/mysql.sock
pid-file=/var/run/mysqld/mysqld1.pid
log-error=/var/log/mysqld1.log
# Disabling symbolic-links is recommended to prevent assorted security
# risks
symbolic-links=0
[mysqld2]
port=63133
datadir=/var/lib/mysql/2/
socket=/var/lib/mysql/2/mysql.sock
pid-file=/var/run/mysqld/mysqld2.pid
log-error=/var/log/mysqld2.log
# Disabling symbolic-links is recommended to prevent assorted security
# risks
symbolic-links=0
Create data directories for each instance:
# mkdir /var/lib/mysql/{1,2}
# chcon --reference=/var/lib/mysql/ /target/directory
Create a log file for each instance and give it the correct permissions and security context:
# touch /var/log/mysqld{1,2}.log
# chmod o-r mysqld{1,2}.log 这个重要的,-R 777
# chcon --reference=/var/log/mysqld.log /var/log/mysqld{1,2}.log
Initialize mysql databases:
# mysql_install_db --user=mysql --datadir=/var/lib/mysql/1/
# mysql_install_db --user=mysql --datadir=/var/lib/mysql/2/
Start mysqld instances:
# systemctl start mysqld@1
# systemctl start mysqld@2
Check the logs to make sure everything is running okay:
# systemctl status mysqld@1
# systemctl status mysqld@2
# cat /var/log/mysqld.log
# cat /var/log/mysqld1.log
# cat /var/log/mysqld2.log
Enable services at startup.
# systemctl enable mysqld@1
# systemctl enable mysqld@2
kingshard没有主从复制
vim /etc/my.cnf
add:
[mysqld]
server_id=1
log-basename=master
log-bin
binlog-format=row
binlog-do-db=unixmen
systemctl restart mysqld@1
mysql -h 127.0.0.1 -P 63132 -u root 主配置
STOP SLAVE;
GRANT REPLICATION SLAVE ON *.* TO 'root'@'%' IDENTIFIED BY '';
FLUSH PRIVILEGES;
FLUSH TABLES WITH READ LOCK;
SHOW MASTER STATUS;
QUIT;
mysql -h 127.0.0.1 -P 63133 -u root 从配置
备份主数据
以下这部 不是在 mysql 里面的
mysqldump --host=127.0.0.1 --port=63132 --all-databases --user=root --password --master-data > masterdatabase.sql
vim /etc/my.cnf
[mysqld]
server-id = 2
replicate-do-db=unixmen
MariaDB [(none)]>
UNLOCK TABLES;
SLAVE STOP;
quit;
mysql -h 127.0.0.1 -P 63133 -u root -p < /root/masterdatabase.sql
//mysql -u root -p < /home/masterdatabase.sql
restart
slave stop;
change master to master_host='127.0.0.1',master_port=63132,master_user='root',master_password='',master_log_file='master-bin.000002',master_log_pos=245;看清主status
slave start;
show slave status\G;