The Ultimate Guide to High Availability with MariaDB

Comments - Spider FAQ

1 year, 1 month ago 2 mu
FAQ: Can I use MySQL 8.0.25 as the backend partition?

I created a spider partition table in 11.0.1-MariaDB-debug-log (Compiled by source code); The backend mysql version is 8.0.25; I encountered an error when I queried the table at that time:

insert into t1(id) values(0);
ERROR 1231 (42000): Variable 'sql_mode' can't be set to the value of 'no_auto_create_user'

The create table statement is as follows:

create table t1(
     id int auto_increment,
     data mediumblob, primary key(id)
)engine=spider comment='wrapper "mysql", table "t1"'
partition by list (id % 2)
( partition pt1 values in (0) comment = 'srv "backend1"',
partition pt2 values in (1) comment = 'srv "backend2"'
);
 
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.