Comments (5)
agapple
commented on May 14, 2024
mysqlbinlog工具解析一半的binlog数据文件，目前暂不支持直接做source导入
需要先用binlog to sql的工具，先转成完整的sql语句后导入polardb-x
from polardbx-sql.
lulu2panpan
commented on May 14, 2024
mysqlbinlog解析出的内容，需要单独进行协议和语法层面的适配，暂时不支持类似原生mysql的直接导入能力，参见https://dev.mysql.com/doc/refman/8.0/en/binlog.html
from polardbx-sql.
lulu2panpan
commented on May 14, 2024
分析了一下，--base64-output=decode-rows参数还是不能加的，通过这个参数decode出来的sql都是带注释的，进行导入的时候会被忽略掉，相当于啥都没做。原生导入能力正在规划中，暂时只能靠工具进行sql转换，再导入了
from polardbx-sql.
wuxuguang2022
commented on May 14, 2024
那如果不加--base64-output=decode-rows参数呢
…------------------ 原始邮件 ------------------
发件人: "ApsaraDB/galaxysql" ***@***.***>;
发送时间: 2022年6月21日(星期二) 中午12:57
***@***.***>;
***@***.******@***.***>;
主题: Re: [ApsaraDB/galaxysql] mysqlbinlog基于cdc全局binlog恢复报Not supported variable for now 'pseudo_thread_id' (Issue #64)
分析了一下，--base64-output=decode-rows参数还是不能加的，通过这个参数decode出来的sql都是带注释的，进行导入的时候会被忽略掉，相当于啥都没做。原生导入能力正在规划中，暂时只能靠工具进行sql转换，再导入了
—
Reply to this email directly, view it on GitHub, or unsubscribe.
You are receiving this because you authored the thread.Message ID: ***@***.***>
from polardbx-sql.
lulu2panpan
commented on May 14, 2024
见上面回复内容，不加的话，解析出来的内容，需要内核尽心独立识别和适配，暂时还不支持
from polardbx-sql.
Related Issues (20)
- [WeeklyReport] Weekly report for polardbx-sql 10/23/2023 to 10/30/2023
- [WeeklyReport] Weekly report for polardbx-sql 10/30/2023 to 11/6/2023
- 分表的笛卡尔积SQL改写 HOT 1
- [WeeklyReport] Weekly report for polardbx-sql 11/6/2023 to 11/13/2023
- [WeeklyReport] Weekly report for polardbx-sql 11/13/2023 to 11/20/2023
- K8S operator webhook error x509: certificate is not valid for any names HOT 5
- [WeeklyReport] Weekly report for polardbx-sql 11/20/2023 to 11/27/2023
- [WeeklyReport] Weekly report for polardbx-sql 11/27/2023 to 12/4/2023
- [WeeklyReport] Weekly report for polardbx-sql 12/4/2023 to 12/11/2023
- [WeeklyReport] Weekly report for polardbx-sql 12/11/2023 to 12/18/2023
- [WeeklyReport] Weekly report for polardbx-sql 12/18/2023 to 12/25/2023
- [WeeklyReport] Weekly report for polardbx-sql 12/25/2023 to 1/1/2024
- [WeeklyReport] Weekly report for polardbx-sql 1/1/2024 to 1/8/2024
- Error from server (InternalError): error when creating "polardb-x.yaml": Internal error occurred: failed calling webhook "polardbxcluster-mutate.polardbx.aliyun.com": failed to call webhook: the server is currently unable to handle the request
- [WeeklyReport] Weekly report for polardbx-sql 1/8/2024 to 1/15/2024
- [WeeklyReport] Weekly report for polardbx-sql 1/15/2024 to 1/22/2024
- [WeeklyReport] Weekly report for polardbx-sql 1/22/2024 to 1/29/2024
- [WeeklyReport] Weekly report for polardbx-sql 1/29/2024 to 2/5/2024
- Windows 使用PXD安装PolarDB-X报 '--initialize-insecure']' returned non-zero exit status 1. HOT 14
- 银河麒麟v10启动报错
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from polardbx-sql.