All Questions
Tagged with database-replication mariadb
76 questions
0
votes
1
answer
42
views
Commit delay for MariaDB Galera cluster and MaxScale
I'm working in a clustered MariaDB database with Galera and MaxScale in r/w routing.
My question is if the commit command successful return implies a completed replication or not.
This is the scenario:...
- 9,577
0
votes
0
answers
34
views
Cannot delete or update a parent row: a foreign key constraint fails with Galera and MaxScale
I'm working with two servers MariaDB with galera replication and MaxScale rw router.
One server takes write queryies only, the other one just selects.
I have this sequence of operations:
start ...
- 9,577
0
votes
2
answers
362
views
How to acquire exclusive lock in replicated mysql and clustered servers?
I have this scenario:
My php web application is deployed in a clustered environment, it uses a replicated mariadb database with galera.
It has to acquire an exclusive lock on database row resource and ...
- 9,577
0
votes
1
answer
499
views
DMS replication task fails due to a corrupt binlog event
I have a mariadb RDS database deployed as a multi-AZ in my AWS account, engine version 10.6.16. This DB serves as the main backend database serving ~100 connections per second. I also have a DMS ...
- 41
1
vote
0
answers
205
views
Changing binlog_format in MariaDB slave
I have mariadb 10.3 master and slave running in AWS EC2, whose binlog format is MIXED for both. I want to migrate this db to Aurora MySQL using DMS and understand DMS needs the format to be in ROW.
I ...
- 53
-1
votes
1
answer
3k
views
Can't import the dump: ERROR 1180 (HY000) at line XXXXX1268: Got error 1 "Operation not permitted" during COMMIT
I am trying to recover my slave cluster. I have followed the guide instructions from here:
How to re-sync the Mysql DB if Master and slave have different database incase of Mysql replication?
The dump ...
- 19
0
votes
1
answer
1k
views
How to synchronize replicationDB with masterDB in MariaDB
I created replicaDB and I've got a problem.
While I was creating it, I did some steps below
FLUSH TABLES WITH READ LOCK; on masterDB
mysqldump command as well to make a backup
import backup into ...
- 15
0
votes
1
answer
130
views
Is it possible to mysqldump mixed DB (MyISAM,InnoDB) separatelly for replication setup?
I want to dump and setup for replication 4 databases roughly each about 3gb of size. The problem is that my tables are mixed and I need database tables to be locked as short period as possible.(...
- 1
0
votes
1
answer
639
views
MariaDB clone running DB and setup master-master replication
I need to setup master-master replication MariaDB cluster. Now I got a single MariaDB server and database is too big to just stop first node, transfer a copy to second node and launch both in master-...
- 31
1
vote
0
answers
36
views
MariaDB10.4 - W10 machine, one slave + few regular standalone DBs - how to?
I'm running a simple home/small business php/db server with Windows 10 and xampp with MariaDB.
I'd like to expand it to being it a DB slave for a "failover" PHP application hosted on another ...
- 11
0
votes
2
answers
2k
views
Can't Grant SLAVE MONITOR to user on MariaDB 10.6 Primary
We recently replaced an old MariaDB 10.3 primary with one of it's replicas which is running 10.6.x. Hoping that this would resolve a weird Primary/replica issue that we have had since creating the ...
- 3
1
vote
1
answer
1k
views
Automatic MariaDB table replication between 2 databases on the same server
So a friend of mine asked me to help him configure an automatic replication of a table on his MariaDB database to another table that's supposed to be an exact copy of the source/primary table.
The ...
- 47
0
votes
1
answer
128
views
Are there *application*-driven reasons to prefer multi-primary topologies over clustering, or vice-versa?
I have an application that currently uses a single primary and I'm looking to do multi-primary by either setting up a reciprocal multi-primary (just two primaries with auto-increment-increment and ...
- 20.9k
6
votes
1
answer
2k
views
Master-Master replication broken with "Duplicate entry for key 'PRIMARY'" due to AUTOINCREMENT
We use Master-Master replication to avoid situations in which writing to replica will get it out of sync with the real master and in case we wish to switch masters. However, there's a seemingly known ...
- 2,094
1
vote
1
answer
889
views
MaxScale no Slave State set
We want to use MaxScale and two MariaDB databases with docker-compose.
We have the problem that we do not achieve replication of the database via maxscale.
Write permissions are available via MaxScale ...
- 13