Questions tagged [spider]

Spider : MariaDB's Sharding Storage Engine

Filter by
Sorted by
Tagged with
0
votes
0answers
19 views

Result rows duplicated by spider engine

I've two mysql server 'G0' and 'G1'. And there is a one row test table on them respectively. G0: mysql> select * from test.t1; +----+--------+ | id | node | +----+--------+ | 1 | DB-G0 | +----...
1
vote
0answers
21 views

What is the meaning of MariaDB `mysql`.`servers` table constraint?

I am using SPIDER engine to access a remote table from within my MariaDB database, which requires a server definition in mysql.servers table created via CREATE SERVER statement. I noticed that this ...
0
votes
0answers
87 views

MariaDB SPIDER engine

I am trying to include just one table from another MariaDB server (lets call it A) into the database on another (even physical) server (lets call it B). And I came up with the conclusion that SPIDER ...
1
vote
0answers
117 views

MariaDB Spider sharding: automatic XA commit?

I'm planning to use Spider to shard my huge table across multiple backend nodes. What I'd like to do, is inserting on the Spider node(s) on the virtual big table, and Spider have it distribute it for ...
0
votes
2answers
70 views

MariaDB Spider Engine UDF spider_bg_direct_sql can't find TEMPORARY table

I am testing the Spider engine in MariaDB. In version mariadb-10.1.12-linux-x86_64 the UDF works, but there are some issues so I want to upgrade to a newer version. However, mariadb-10.2.18-linux-...
2
votes
0answers
948 views

Expanding MariaDB cluster (sharding)

I have an expanding MariaDB 3 node cluster and need to expand the available storage. Each node has (to make the maths slightly easier) 120Gb of database storage. As this is replicated, the total DB ...
4
votes
1answer
668 views

MariaDB Spider Engine Out of Memory

I had almost standard MariaDB with InnoDB engine working fine but I wanted to test out the Spider Engine + Sharding/Partitioning. I had a query which was passing fine on the MariaDB InnoDB for 15-...