mysql排序时设置主次_一招搞定MySQL安装使用&主次设置

安装依赖

yum search libaio  # 检索相关信息

yum install libaio # 安装依赖包

mysql是否安装

yum list installed | grep mysql

mysql卸载

yum -y remove mysql-libs.x86_64

mysql yum下载

wget http://dev.mysql.com/get/mysql-community-release-el7-5.noarch.rpm

修改启动项目

yum-config-manager --disable mysql56-community

yum-config-manager --enable mysql57-community-dmr

安装 MySQL

yum install mysql-community-server

查看mysql安装位置

where is mysql

启动mysql

systemctl start  mysqld

关闭mysql

systemctl stop  mysqld

查看密码

grep 'temporary password' /var/log/mysqld.log

mysql修改密码远程连接

SET PASSWORD = PASSWORD('#20as3SElksds0ew98');

SET PASSWORD = PASSWORD('#20as3SElksds0ew98');GRANT ALL PRIVILEGES ON *.* TO 'root'@'%' IDENTIFIED BY '#20as3SElksds0ew98' WITH GRANT OPTION;

主从复制

打开端口

firewall-cmd –add-port=3306/tcp

firewall-cmd –permanent –add-port=3306/tcp

firewall-cmd –reload success

修改主服务器---vim /etc/my.cnf最后面加上   unb系统/etc/mysql/mysql.conf.d/mysqld.cnf

log-bin=mysql-bin #slave会基于此log-bin来做replication

server-id=1 #master的标示

innodb_flush_log_at_trx_commit=1

sync_binlog=1

修改从服务器---vim /etc/my.cnf最后面加上

server-id=2 #slave的标示

server-id=3 #slave的标示

有几个就在几个上面配置

主服务器增加账号

主服务查看信息

show master status;

+------------------+----------+--------------+------------------+-------------------+

| File             | Position | Binlog_Do_DB | Binlog_Ignore_DB | Executed_Gtid_Set |

+------------------+----------+-------------+------------------+-------------------+

| mysql-bin.000002 |      673 |              |                  |                   |

+------------------+----------+--------------+------------------+-------------------+

配置从服务器

stop slave;

stop slave;change master to master_user='root',master_password='#20as3SElksds0ew98',master_host='192.168.232.140',master_port=3306,master_log_file='mysql-bin.000002',master_log_pos=673start slave;

查看主从复制

SHOW SLAVE STATUS\G