LoginSignup
0

More than 5 years have passed since last update.

Aurora Note

Last updated at Posted at 2017-04-06

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

  1. Snapshot from main cluster
  2. Create slave cluster from 1. snapshot
  3. Get log name/position from slave cluster's Log
  4. set remote master @ slave cluster
  5. 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.

Register as a new user and use Qiita more conveniently

  1. You get articles that match your needs
  2. You can efficiently read back useful information
  3. You can use dark theme
What you can do with signing up
0