# Need to create a new database and load a lot of data with replication **URL:** \ **Category:** Percona Server for MySQL 8.0\ **Created:** [June 9, 2025, 4:39pm UTC](https://forums.percona.com/t/need-to-create-a-new-database-and-load-a-lot-of-data-with-replication/38253 "2025-06-09T16:39:04Z")\ **Posts on this page:** 2\ **Page:** 1
**Author:** ![ipcmlr](https://avatars.discourse-cdn.com/v4/letter/i/df705f/32.png) [@ipcmlr](https://forums.percona.com/u/ipcmlr)\ **Post date:** [June 9, 2025, 4:39pm UTC](https://forums.percona.com/t/need-to-create-a-new-database-and-load-a-lot-of-data-with-replication/38253/1 "2025-06-09T16:39:04Z")
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? ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [June 9, 2025, 6:59pm UTC](https://forums.percona.com/t/need-to-create-a-new-database-and-load-a-lot-of-data-with-replication/38253/2 "2025-06-09T18:59:03Z")
> [@ipcmlr](#): > > 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 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.