关于部署AliSQL的一些疑问

[changdy]

已经阅读了"快速部署 AliSQL DuckDB 节点" 一文.还是有些困惑 , 特来请教:

1. AliSQL作为从节点的时候,主节点必须是同版本的AliSQL吗 , 还是可以允许主节点是原生版本的MySQL?
2. AliSQL作为从节点的时候,用户数据表全部都是DuckDB 引擎吗? 即便主库默认的是InnoDB 引擎?

祝 AliSQL 越来越好..这样大部分程序员也就不用想着 如何优化sql了....

[p1p1bear]

@changdy
Thanks for your questions.

1. The primary can be community MySQL. In general, replication should work as long as the binlog format/protocol is compatible. For version compatibility, AliSQL 8.0 is typically compatible with upstream MySQL <= 8.0.44, and AliSQL 5.7 is typically compatible with upstream MySQL <= 5.7.44. However, we strongly recommend keeping the major version aligned between primary and replica (i.e., both on 5.7 or both on 8.0) for best compatibility and operational safety.

2. A mixed InnoDB + DuckDB setup is supported. Start AliSQL with duckdb_mode = ON, but do not enable duckdb_convert_all_at_startup. After startup, all tables will remain InnoDB by default. You can then manually convert only the tables you want to DuckDB with:

ALTER TABLE <my_table> ENGINE = duckdb;

This allows you to run an instance where only selected tables use DuckDB.

Finally, thanks for the kind words. AliSQL looks forward to working with the community to build a better MySQL ecosystem. Thank you! If you have any questions, please feel free to reach out anytime.