Get my Server_name
select @@aurora_server_id;
Replication status
select server_id,session_id,replica_lag_in_milliseconds from information_schema.replica_host_status;
Intra region replication individual cluster
- Snapshot from main cluster
- Create slave cluster from 1. snapshot
- Get log name/position from slave cluster's Log
- set remote master @ slave cluster
- start slave
set remote master on RDS/Aurora
syntax
CALL mysql.rds_set_external_master (
host_name
, host_port
, replication_user_name
, replication_user_password
, mysql_binary_log_file_name
, mysql_binary_log_file_location
, ssl_encryption
);
Replication for mysql-DB? (user or schema..)
GRANT ...
propergated to slave normary.
TODO: how to replicate only specific dbs or tables.