Need to create a new database and load a lot of data with replication

MySQL & MariaDB Percona Server for MySQL 8.0
1

I have a source and replica that is up and running and replicating.
I have to create a new database and load about 200gb of data.
I tried loading on the source but it causes a huge lag in the replica side ( its across the country)
Can I use the following steps to do the loading:

  1. binlog-ignore-db = new_database
  2. create database on both the source and replica
  3. import data on both the source and the replica separately
  4. remove binlog-ignore-db = new_database

Will I run any issues after I remove the binlog-ignore-db? The replica will no longer look for the transactions I loaded previously, correct?

2

That is very much expected. Ensure on the replica you have replica_parallel_threads >= 4, and replica_parallel_type is set to LOGICAL_CLOCK

Your steps should work. The replica will not look for previous transactions.