帳號權限修改
mysql> SHOW GRANTS FOR 'master_user'; mysql> CREATE USER 'new_master_user'@'%' IDENTIFIED BY 'password'; mysql> GRANT SELECT, INSERT, UPDATE, DELETE, CREATE, DROP, RELOAD, PROCESS, REFERENCES, INDEX, ALTER, SHOW DATABASES, CREATE TEMPORARY TABLES, LOCK TABLES, EXECUTE, REPLICATION SLAVE, REPLICATION CLIENT, CREATE VIEW, SHOW VIEW, CREATE ROUTINE, ALTER ROUTINE, CREATE USER, EVENT, TRIGGER ON *.* TO 'new_master_user'@'%' WITH GRANT OPTION;
查詢binlog保留時間
RDS啟用LOG
開啟AWS RDS LOG設定
PG內修改，套用之後重開RDS
general_log 1
slow_query_log 1
因LOG務設是存放在TABLE中
有會吃掉RDS預設的空間
如果需手動清除，需在MySQL內執行以下指令2次
PROMPT> CALL mysql.rds_rotate_slow_log; PROMPT> CALL mysql.rds_rotate_general_log;
RDS永久修改時區
實際套用需要在Parpmeter Groups內
修改 time_zone 選擇 Asia/Taipei
修改 time_zone 選擇 Asia/Taipei
選擇要改的rds右鍵Modify
選擇改好的Parpmeter Groups
套用後rds需要Reboot才會生效
進rds查詢及套用
select now()
RDS mysqldump語法
mysqldump -h xxxxxxxxxxxxxx.ap-northeast-1.rds.amazonaws.com -u king -p --master-data=2 --single-transaction --order-by-primary --databases TEST > TEST.sql
mysql資料回復,進mysql命令列後倒回去
source backup.sql;