Mysql Innodbcluster using mysql-operator
Posted by: Ales Verbic
Date: April 20, 2022 09:12AM

Hi,

I am trying to move data from Mysql5.7 to MySql8.0.28 InnoDB cluster.

The first attempt was to use load data through router instance expecting to write to a single master. But I was hitting into a group_replication_transaction_size_limit=214748364 when I increased the group_transaction limit to the max. I got another error only packets smaller than 2135850104 can be compressed.

side note
mysqldump I didn't use --extended-insert=true --single-transaction=true.

I don't know what I was doing wrong.

On the second attempt I thought I could use clone but I figure it out that won't work as I need the same MySQL version.

What is the recommended way to load 50GB of data to InnoDB cluster?

Thank you,
Ales

Options: ReplyQuote


Subject
Written By
Posted
Mysql Innodbcluster using mysql-operator
April 20, 2022 09:12AM


Sorry, only registered users may post in this forum.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.