kingshard 分表-主从复制 mariadb搭载

 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 %iAfter=syslog.targetAfter=network.target[Service]User=mysqlGroup=mysqlType=forkingExecStart=/usr/bin/mysqld_multi start %iExecStop=/usr/bin/mysqld_multi stop %iRestart=alwaysPrivateTmp=true[Install]WantedBy=multi-user.target

/etc/my.cnf

[mysqld_multi]mysqld = /usr/bin/mysqld_safe --basedir=/usr[mysqld1]port=63132datadir=/var/lib/mysql/1/socket=/var/lib/mysql/1/mysql.sockpid-file=/var/run/mysqld/mysqld1.pidlog-error=/var/log/mysqld1.log# Disabling symbolic-links is recommended to prevent assorted security# riskssymbolic-links=0[mysqld2]port=63133datadir=/var/lib/mysql/2/socket=/var/lib/mysql/2/mysql.sockpid-file=/var/run/mysqld/mysqld2.pidlog-error=/var/log/mysqld2.log# Disabling symbolic-links is recommended to prevent assorted security# riskssymbolic-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=1log-basename=masterlog-binbinlog-format=rowbinlog-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 = 2replicate-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;看清主statusslave start;show slave status\G;