Comments - Knowledge Base Questions

7 years, 7 months ago Samuel Liang

Install : MariaDB-Galera-5.5.29-centos6 galera-23.2.6-1.rhel6.x86_64 MariaDB-5.5.32-centos6-x86_64-client MariaDB-5.5.32-centos6-x86_64-common MariaDB-5.5.32-centos6-x86_64-compat MariaDB-5.5.32-centos6-x86_64-shared MariaDB-5.5.32-centos6-x86_64-test

I have two galera nodes, my java application via load data infile upload data. Why galera data synchronize not work? But I use general sql insert statement is OK!

7 years, 7 months ago Samuel Liang

I had set wsrep_debug=1, than output below log: [Note] WSREP: empty rbr buffer, query: LOAD DATA LOCAL INFILE ... FIELDS TERMINATED BY '\|' OPTIONALLY ENCLOSED BY '\'' LINES TERMINATED BY '\r\n', affected rows: 1, changed tables: 1, sql_log_bin: 1, wsrep status (3 2 0)

Could you help me?

7 years, 7 months ago Samuel Liang


My steps : First, I try open wsrep log via wsrep_debug = 1 on server.cnf Then, from log find "empty rbr buffer" message. Second, I search what is rbr? Its mean is "Row based replication". Next, I find binlog_format have three modes : STATEMENT/ROW/MIXED. Our environment is "STATEMENT", but this mode not support LOAD FILE replication. Must setting to "ROW". So, after testing OK!

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.