Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [spider]

Spider : MariaDB's Sharding Storage Engine

The Spider Storage Engine features built-in sharding and partitioning. Although multiple MariaDB instances have individual shards, queries against a spider table looks like any other SELECT query.

For more information, please see Spider Storage Engine Overview

8 questions
4
votes
1 answer

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-20min. With Spider engine no matter what I do it…
user3526540
  • 61
  • 1
  • 4
2
votes
1 answer

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 storage is also therefore 120Gb. If I add a 4th…
user3566845
  • 113
  • 8
1
vote
0 answers

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 table has a column named Db of type char(64) with a…
beddu
  • 11
  • 1
1
vote
0 answers

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 me to the right backend node (shard), while…
gertvdijk
  • 227
  • 1
  • 4
  • 14
0
votes
0 answers

MariaDB Spider Tuning

if I have a Spider database which has only Spider tables, what are important configuration keys for tuning the Spider ? For example, i heard about Spider and how it works with MEMORY table so should i increase key_buffer_size in a Spider-only…
user216085
  • 13
  • 2
0
votes
0 answers

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 rows in set (0.00 sec) G1: mysql>…
ASBai
  • 103
  • 3
0
votes
0 answers

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 engine might be a good option. But I can't make it…
Martin Dimitrov
  • 169
  • 1
  • 7
0
votes
2 answers

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,…
Toby Chen
  • 1
  • 1