8.1 About Inbound Replication
Inbound replication enables asynchronous replication from a MySQL-based source (an on-premises or other cloud MySQL Instance, or another HeatWave on AWS DB System) to a HeatWave on AWS DB System. It uses a replication channel configured in HeatWave on AWS to copy transactions from the source to a HeatWave on AWS DB System (replica). The channel connects the source to the replica, and copies data from the source to the replica.
Asynchronous replication means that the replica does not need to be running and connected to the source all the time. It can pick up new updates whenever it is online and reconnects.
A replica DB System can connect to only one MySQL source. The source server does not control the DB System replica and does not need to have permission to write to it. The replica uses the configured replication channel to connect to the source using a set of replication user credentials. Over the connection formed by the channel, the replica retrieves committed transactions from the source. The replica then writes those transactions to its own copy of the databases.
Note:
Inbound replication is not a managed functionality. You are responsible for configuring and maintaining the channel, and for ensuring that the traffic between source and replica is properly configured.Impact of the DB System Operations on the Replication Channel
The DB System operations affect the replication channel:
- If you stop the replica DB System, it stops any enabled Channels and
changes its state to
Needs Attention
. - If you delete the replica DB System, it deletes any Channels attached to it.
- If a restart, upgrade, or update happens to a replica DB System, or
if the replica is a high availability DB System and a failover occurs to
it, the Channel is temporarily suspended and in the
Needs Attention
state while any of the aforementioned operations is taking place. When the operation is completed, replication is resumed automatically. The Channel state changes toResuming
while the channel is being resumed.
Parent topic: Inbound Replication