觸發(fā)器見識(shí)數(shù)據(jù)操作insert/update/delete
觸發(fā)時(shí)間after/before
表關(guān)聯(lián)操作有哪些insert/update/delete
show trigger \G;
delimiter
declare 變量名 變量類型 default 默認(rèn)值
查看存儲(chǔ)過(guò)程
show procedure status
create procedure p1()
begin
select * from goods;
declare age int default 10;
select concat('年齡是',age);
end$
show procedure \G
call prodecure()
show master status
show slave status
主從配置
start slave
主id
server-id=1
log-bin=mysql-bin
binlog-format=mixed/row/statment
從id
server-id=2
log-bin=mysql-bin
binlog-format=mixed
relay-log=mysql-relay
mysqld-safe --user=mysql &
service iptables status
grant replication client,replation slave on . to repl@'192.168.1.%' identified by 'repl';
權(quán)限回收
grant all on ecshop.* to lisi@'192.168.1.%';
revoke all on ecshop.* to lisi@'192.168.1.%';
grant insert,update,select on gys.goods to
lisi@'192.168.0.%';
從服務(wù)器執(zhí)行
show master status
change master to master_host='192.168.1.1',master_user='repl',master_password='pass',master_log_file='mysql-bin.000001',master_log_pos=348;
從執(zhí)行 start slave
主開復(fù)制賬號(hào) 從使用賬號(hào)
reset slave
start slave
