This is an automated email from the ASF dual-hosted git repository.
fanjia pushed a commit to branch dev
in repository https://gitbox.apache.org/repos/asf/incubator-seatunnel.git
The following commit(s) were added to refs/heads/dev by this push:
new e568bcf9e [DEV][DOC] Add some hints to the mysql documentation (#2855)
e568bcf9e is described below
commit e568bcf9e04fd7435907de420b8d102a0cd6ecf1
Author: ic4y <[email protected]>
AuthorDate: Fri Sep 23 18:04:51 2022 +0800
[DEV][DOC] Add some hints to the mysql documentation (#2855)
* add mysql connector doc
* add mysql connector doc
---
docs/en/connector-v2/sink/Jdbc.md | 5 +++--
1 file changed, 3 insertions(+), 2 deletions(-)
diff --git a/docs/en/connector-v2/sink/Jdbc.md
b/docs/en/connector-v2/sink/Jdbc.md
index ed6285eae..8393cc17d 100644
--- a/docs/en/connector-v2/sink/Jdbc.md
+++ b/docs/en/connector-v2/sink/Jdbc.md
@@ -73,8 +73,9 @@ The number of retries for transaction commit failures
The timeout after the transaction is opened, the default is -1 (never
timeout). Note that setting the timeout may affect exactly-once semantics
## tips
-In the case of is_exactly_once = "true", Xa transactions are used. This
requires database support, and some databases require some setup. For example,
postgres needs to set `max_prepared_transactions > 1`
-Such as `ALTER SYSTEM set max_prepared_transactions to 10`.
+In the case of is_exactly_once = "true", Xa transactions are used. This
requires database support, and some databases require some setup :
+ 1 postgres needs to set `max_prepared_transactions > 1` such as `ALTER
SYSTEM set max_prepared_transactions to 10`.
+ 2 mysql version need >= `8.0.29` and Non-root users need to grant
`XA_RECOVER_ADMIN` permissions. such as `grant XA_RECOVER_ADMIN on test_db.* to
'user1'@'%'`.
## appendix
there are some reference value for params above.
