Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [galera]

Galera Cluster for MySQL is a true Multimaster Cluster based on synchronous replication.

124 questions
0
votes
1 answer

Different InnoDB data file sizes on Galera

We have a cluster of 3 Galera-MariaDB boxes, using InnoDB as an engine. Cluster's in sync, and reporting all good as far as I can see. Much to my surprise, the size of the InnoDB data files differ quite a lot between the 3 boxes; some tables even…
user4867444
  • 445
  • 4
  • 5
0
votes
1 answer

Initial Xtradb Cluster setup -- each node comes up isolated

I'm setting up a percona-xtradb-cluster-57 (3 nodes) on Ubuntu 16.04. They are to communicate using a private network, 10.254.10.101 through 10.254.10.103. When I follow the instructions on Percona's site just as written, after bootstrapping the…
user396356
  • 1
  • 2
0
votes
2 answers

how mariadb galera can help me scale writes?

if I have 1 server that's getting 30 writes per seconds and then I am moving to 3 galera nodes so now each server is getting 10 writes per seconds but due to how galera works every server in the cluster getting every other servers writes so in the…
Amir Bar
  • 213
  • 2
  • 7
0
votes
1 answer

LXD + Galera Cluster + Max Scale : Shutting down server != Stopping containers

I have a galera cluster with 4 nodes. 2 in one server (server-master) and 2 in another server (server-slave). The clusters are controlled through "Max Scale". All the setup seems correct as replication is working fine, SHOW STATUS LIKE…
lepe
  • 469
  • 2
  • 6
  • 25
0
votes
1 answer

setting up MariaDB Galera cluster Ubuntu Zesty

I can't figure out how to initialize a MariaDB Galera cluster on Ubuntu Zesty. I've followed the documentation, but something seems to be missing. I cannot get the first node to come up. I installed using standard package: apt install…
Rich Remer
  • 205
  • 1
  • 7
0
votes
1 answer

Do slow nodes bottleneck a Galera Cluster?

Let's say I have a 5 node cluster, with 3 SSD RAID 10 nodes and a 2 SSD RAID 1 nodes. Will the RAID 1 nodes slow down the entire network? How do the Galera cluster writes work? Does it have to wait until the slowest node (RAID 1) finish writing the…
Kevin
  • 1
  • 2
0
votes
1 answer

2-host MariaDB Galera cluster with keepalived only, no HAproxy?

We're about to replace a legacy MySQL database using master-slave replication (only 2 hosts total - one master, one slave) with a MariaDB Galera master-master replication cluster to ensure more hassle-free failovers. The tutorials I've read through…
user408931
  • 3
  • 1
  • 2
0
votes
0 answers

Monitoring UUIDs of MariaDB servers in Galera cluster

I want to be able to monitor the UUIDS of several MariaDB servers on a regular basis to make sure that they haven't somehow been removed from the cluster. I have a command that I run to retrieve it locally: mysql -umaria -e "SHOW GLOBAL STATUS LIKE…
PixelArtDragon
  • 101
  • 2
0
votes
1 answer

Cant add more servers to Galera Cluster --> [ERROR] /usr/sbin/mysqld: unknown option '--.'

Ive tried to setup a MariaDB cluster with Galera on my Debian 8 server. When I try to add servers to the one that already exist in the cluster with: systemctl start mysql I get this error: Job for mariadb.service failed. See 'systemctl status…
Henrik Cordsen
  • 1
  • 3
0
votes
1 answer

mariadb galera cluster don't intialize on debian wheezy

I meet some troubles with initiliazing a Galera cluster, the start of 2nd node always failed, without error message in log. I have two nodes for the moment, i will install the third later. Here are my configuration node1 : 192.168.0.21 db01 node2 :…
Kristy
  • 1
  • 1
0
votes
1 answer

Couldn't join MariaDB Galera Cluster node back to cluster after software update. wsrep_* options in my.cnf seem to be ignored

I've had run a Galera Cluster for a while, MariaDB version 10.0.20, Galera version 25.3.10, everything over Gentoo. That cluster worked fine, nodes restarted several times for maintenance and so on. When I started mysql on any node, it loaded…
Nikita Kipriyanov
  • 10,947
  • 2
  • 24
  • 45
0
votes
1 answer

MariaDB galera cluster fail when dumping or optimizing database

It seems that a Galera cluster deadlocks every time when I run a mysqldump or table optimize. I've ran a "mysqlcheck" and a "mysqldump" on my MariaDB 10.1 database server several times. (which runs in a Galera cluster with two other servers) I've…
gijs007
  • 117
  • 1
  • 4
  • 18
0
votes
1 answer

Secure galera cluster MariaDB

I'm using a Galera cluster between a few web servers over the WAN. I have the traffic encrypted with ipsec between the servers, but it just struck me that anyone can connect to my Galera cluster and start downloading the database. What would be the…
gijs007
  • 117
  • 1
  • 4
  • 18
0
votes
1 answer

Why does XtraBackup tell me my MySQL database is corrupt?

I am trying to backup data on a MySQL Galera node with XtraBackup. Unfortunatelly the tool tells me, that ibdata1 is corrupt. After double checking I indeed found some myisam tables I have importet by error. Droped those and replaced them by innodb…
merlin
  • 2,093
  • 11
  • 39
  • 78
0
votes
1 answer

How to migrate MySQL Master/Master replication to MySQL Galera Cluster?

Currently our setup consists of two MySQL 5.6 servers on seperate Ubuntu 14.04 bare mettal machines. I am looking into migrating the system to a MySQL Galera Cluster on 3 nodes. Can I "patch" the current MySQL instance with the Galera 3 wsrep…
merlin
  • 2,093
  • 11
  • 39
  • 78
1 2 3
…
8 9