MySQL Forums
Forum List  »  MySQL & Kubernetes

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


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,

Options: ReplyQuote

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

Sorry, you can't reply to this topic. It has been closed.

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.