将clickhouse DB迁移到新服务器

Question

我在一个点击服务器上有一个数据库。我想把它迁移到一个新的点击服务器上。怎样做才是正确的呢？我尝试使用clickhouse-backup，但遇到错误

2021/05/31 15:21:45  warn can't create table 'Data.Calls': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.Fcst_1': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.Fcst_3': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.GAInfo': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.HistoryLogs': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.Info': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.Info1': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.Info15': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.Info548': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.Info60': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.InfoAXPNew': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.InfoAXPOld': <nil>, will try again
2021/05/31 15:21:45  warn can't create table 'Data.InfoPageView': <nil>, will try again

Answer 1

它依赖于新旧群集之间的连接。

如果它存在(而且很好)，你可以尝试remote函数，这是最灵活的迁移方式。

我进一步建议写一个脚本，它可以使用remote函数读取表，并在新集群上创建表，然后一次性插入数据，或者使用WHERE somedatecolumn BETWEEN {start_date} AND {end_date}进行daily、weekly或monthly迭代。

如果您不能在新旧集群之间建立直接连接，您将不得不退回到传统的数据提取和上传方式。