All Questions

Tagged with
Filter by
Sorted by
Tagged with
1
vote
1answer
29 views

MariaDB Parallel Replication Drifting at random times

I have recently been thrown in the deep-end to manage our Database servers since our DBA left. The current set-up is Mariadb (mariadb Ver 15.1 Distrib 10.1.38-MariaDB, for debian-linux-gnu), InnoDB (...
0
votes
1answer
37 views

MySql Galera Multi site high availability

We have a datacenter with 3 percona glera nodes We have a store that wants to be in sync with our datacenter(multi master) our store's internet connection is not reliable ( may be down for 30 min), ...
0
votes
0answers
37 views

MariaDB Galera + Replication (GTID error)

Using MariaDB 10.2.25 + Galera with 3 masters All Masters have binlogs active Want to switch the Master_Host of an external salve (also running MariaDB 10.2.25) to a different Master. Replication is ...
1
vote
0answers
46 views

MariaDB Galera slave thinks it's replicating, but it isn't

I have a MariaDB 10.3 Galera slave node with general logging turned on. It's consuming binlogs generated by a MySQL 5.5 NDB cluster. The binlog format is row-based in both databases. SHOW ALL ...
0
votes
2answers
140 views

Safe backup of PXC / Galera cluster

I have 3 nodes 'master master' cluster and using PXC 5.6 But I am only using a single node for both read and write. Before using pxc, i was using standalone Mariadb 5.5 and I was taking backup using ...
0
votes
1answer
37 views

Convert MyISAM to InnoDB in PXC master master

I have 3 nodes PXC 5.6 master master cluster. I have few tables that are using MyISAM. Total MyISAM table = 120 Total MyISAM table size = 80MB I have also read few recommendations where it suggests ...
0
votes
1answer
21 views

Character set warning in PXC logs

I am using PXC 5.6 (Percona-XtraDB-Cluster-56-5.6.41-28.28.1.el7.x86_64) and my log file is flooded with this warning: [Warning] Client failed to provide its character set. 'latin1' will be used ...
2
votes
0answers
97 views

Percona Xtradb Cluster not accepting options on command line

I am using Percona Xtradb Cluster 5.6 and trying to start my cluster through a donor node via command line and I am getting this error: CentOS 7: systemctl start mysql --wsrep-sst-donor=srv1 ...
1
vote
0answers
151 views

galera wsrep_cluster_address value

I am trying to deploy galera multimaster replication but faced some problems, google does not solve it it seems, but I see some people had the same problems in the past. Say, I have 3 servers 192....
0
votes
0answers
94 views

MariaDB galera cluster with Mroonga in wrapper mode doesn't synch

MariaDB Galera Cluster states that the storage engine needs to be InnoDB. I am using Mroonga on some tables in wrapper mode {which uses InnoDB under the hood as storage engine}. The problem I am ...
2
votes
2answers
1k views

MySQL Galera Cluster mass update delay

I have migrated my single MariaDB setup to a 3 node Galera cluster. I am currently in staging and most of normal operations run fine. I have one issue though: if I do a mass update of one column of ...
3
votes
1answer
639 views

Galera not working with Replication

I am using MariaDB 10.2 I have node2 (2.2.2.2) running as a slave to some external database. I bootstrapped node2 as the first member of a Galera cluster "my_cluster". Node1 (1.1.1.1) joined with ...
0
votes
0answers
99 views

Move a node from cluster to be a slave of the cluster in Galera

I have 5 Node in Galera cluster. MariaDB Server 10.1.21-MariaDB-1~trusty. I will remove 2 nodes from it but one of them will be a slave. So from 5 nodes 5th one will be completely removed, 4th one ...
0
votes
1answer
63 views

Questions for 'Tips on Converting to Galera' on MariaDB KB [closed]

Some questions about the excellent writing Tips on Converting to Galera. Is "cross-colo writing" cross connect datacenters write? Also, you should use "START TRANSACTION READONLY" wherever ...
1
vote
1answer
955 views

Galera multi-nodes Master-Master issue with READ right after INSERT

I have a multi-nodes Galera setup which is master-master. An API call to a web server A could write data to either database 1, 2, 3 or 4 (we are not using HaProxy). Another API call right after that ...
1
vote
1answer
235 views

mysqldbcompare object definitions differ

I am using a Galera cluster to replicate MySQL 5.7 databases on Ubuntu 16.04 Server. I am using mysqldbcompare to verify the consistency of the replication. I think my data is consistent because the ...
0
votes
1answer
379 views

Galera cluster replication stalls when using wsrep_provider_options repl.commit_order=2

we are currently testing if moving from mariaDB master/slave replication to a 3-node-galera-cluster is an option for us. General replication in the cluster works fine like expected. Load test shows ...
0
votes
1answer
333 views

Install galera cluster without remove existing mariadb

I have to setup Galera cluster in one of my production servers. OS: Ubuntu 14.04 Existing mysql: maridb 10.1 While installing this cluster, its asking to remove the existing mariadb-server-10.1 How ...
0
votes
2answers
4k views

MariaDB Galera Cluster initial rsync replication failing

I'm trying to install a new galera cluster. The primary host started fine, but the secondaries are failing during the state transfer with rsync, and are not starting. I haven't been able to fix the ...
0
votes
1answer
3k views

Should I increase my key_buffer_size?

I have 4 node and database has InnoDB tables. my key_buffer_size is 128M. Should i increase it in my system? My innodb_buffer_pool_size is 75G and innodb_log_buffer_size = 256M. Mem: 96688 ...
0
votes
1answer
102 views

mysql replication using galera

I want to learn how to use Galera cluster replication (MariaDB). Can anyone give an advice that I can start from specific point? Is it compatible with vsphere?
0
votes
2answers
843 views

wsrep_sst_xtrabackup socat starts and stops right away

What I have done: I have restarted mysql on the JOINERNODE to apply some database settings including increasing the back_log and query_cache_size settings. What I am seeing: When I start mysql on the ...
0
votes
2answers
520 views

Galera backup failing with error “mysqldump: Error 1213: Deadlock found when trying to get lock; try restarting transaction when dumping table”

We face the same issue like this posting on dba.stackexchange.com Deadlock from mysqldump --single-transaction, is it possible?. We offer DBaaS and can't control the DDL statements of our customers. ...
3
votes
2answers
1k views

Keepalived vIP as Galera wsrep_cluster_address

I have a MariaDB Galera cluster. If some nodes fail, I cannot blindly restart them, I have to determine a good wsrep_cluster_address first. If I can keep a keepalived virtual IP on one of the healthy ...
2
votes
2answers
639 views

Galera: any drawback of enabling wsrep_log_conflicts and cert.log_conflicts?

We have a HAProxy which balances reads and writes to only one (of three) Galera nodes. If this balancing works fine, the parameters wsrep_log_conflicts and cert.log_conflicts should never log any ...
2
votes
1answer
7k views

How to verify galera is synced

I have been using mysql master:master replication and was always able to check the status of replication using this command: mysql > show slave status\G I was able to see this in the show slave ...
1
vote
1answer
449 views

Galera Replication error: log block numbers mismatch

I am attempting to get Galera replication working between two nodes. I am finding these errors in my innobackup.backup.log file: xtrabackup: error: log block numbers mismatch: xtrabackup: ...
0
votes
2answers
1k views

MariaDB/Galera Cluster with 3 nodes - Change ENGINE from MyISAM to InnoDB without crash

We have tables with MyISAM. The are out of sync, the number of records is different on each cluster node > select table_schema, table_name from tables where ENGINE = 'MyISAM' and table_schema != '...
0
votes
1answer
81 views

MariaDB Galera Cluster Replication

Does the replication between an async slave connected to a master withing the cluster affect the performance of the master in the cluster?
0
votes
1answer
784 views

What's the best setup for a MySQL multi master replication for a POS in a restaurant?

We're in the process of implementing a point of sale (POS) solution where we have heavily modified an existing open source POS. The original POS was never created with replication/synchronization ...
2
votes
1answer
4k views

Replicate only some tables of MariaDB database

I currently have a ready-made structure cluster with MariaDB Galera with two servers that keeps both updated database. However I now have the need to create a new similar structure but with one ...
0
votes
1answer
92 views

Using Galera Cluster(Percona XtraDB Cluster, MariaDB Cluster) for setting up multi master

Before i gotta use one I want to know if it is working in windows OS cause I saw a lot using it in linux OS. Does using galera (Percona XtraDB Cluster, MariaDB Cluster) cluster works in windows?
4
votes
1answer
443 views

How (if at all) does Galera enforce authentication for SST via rsync when adding a node?

I have to be missing something here. It just hit me as added a new node to my cluster in order to prepare for the removal of a different node: "How does the cluster know that it is okay to send the ...
3
votes
1answer
15k views

InnoDB: Error: Table “mysql”.“innodb_table_stats” not found

I've got the same error, although I'm running galera cluster with 3 nodes. I tried following the instructions from InnoDB: Error: Table "mysql"."innodb_table_stats" not found after ...
1
vote
1answer
48 views

MariaDB cluster and external data feed

I've just finished setting up the 3 nodes mariadb (galera) cluster (let's call the nodes node1, node2 and node3). In order to have the cluster up to date with currently working mariadb database (let's ...
1
vote
1answer
921 views

percona cluster 5.6 - handshake with remote endpoint failed, but endpoint is not part of config

I set up a cluster of 3 database nodes using a percona 5.6 cluster. Everything works, all nodes are replicated. I configured SSL for state transfer. The cluster recently changed its topography, ...
1
vote
1answer
2k views

MySQL 5.5 Replication to Galera/Percona XtraDB Cluster

We are currently investigating moving our current MySQL 5.5 Master > 5 x Slaves (with Statement Based Replication, apx 250GB data and growing) to a HA clustering option. Mainly to provide greater ...
3
votes
1answer
337 views

Why does most Galera cluster documentation recommend having at least 3 nodes as the typical set up?

The Galera documentation and most experts implementing this type of setup, recommend having at least 3 nodes in the Galera cluster. What is the reasoning behind this? Is a cluster setup with only two ...
2
votes
1answer
167 views

How to transition from a statement based log to row based log for Galera replication?

I'm new to clustering and I'm trying to implement a Galera cluster. I'm transitioning from a standalone MySQL instance to a MariaDB Galera Cluster consisting of (at the moment) 2 nodes. I have ...
0
votes
1answer
371 views

Does Galera Cluster rsync only updated files or all files

We're currently setting up a galera cluster using rsync for sst. The datadir is currently 20Gig and right now we're only updating about 4 (very large) tables. I know that rsync normally only ...
1
vote
1answer
1k views

MariaDB Galera Cluster - nodes fail to start

This is a new installation (fresh VM and MariaDB install). For some reason, the nodes are having trouble joining the master server. The master server would pause at Preparing binlog files for ...
2
votes
1answer
4k views

Galera Cluster with MariaDB 10 and asynchronous slave

As it's easier to understand what I'm trying to accomplish with a picture, here's a picture: I'm really not an expert in database administration, so please be patient. I am working on a setup where ...
1
vote
1answer
5k views

Using Galera for simple master-master replication

I was reading the documentation and it specifically mentions that a Galera DB cluster must have at least three nodes to achieve quorum, although our current setup is working with two. I am tasked ...
0
votes
2answers
586 views

Percona XtraDB Cluster/MariaDB Galera Cluster - replication suddenly stops working, cluster thinks it is in “Synced” state

We are trying to populate an empty Galera cluster using myloader. We use the latest version of myloader from repo trunk, the command is as follows: /root/mydumper/myloader -d /root/dump/export-...
13
votes
2answers
6k views

What are the drawbacks of using Galera Cluster instead of Master/Slave Replication?

What are the drawbacks of using Galera Cluster instead of regular Master/Slave Replication? Galera's 0 slave lag time, Synchronous replication and no Single point of failure seem very appealing then ...