dbeaver / dbeaver/dbeaver

Multi Master Replication

Open
#18,462 2 comments 0 reactions 0 assignees View on GitHub
x:maria
Dominant language
Java
Stars
51.8k
Forks
4.4k
Avg merge
3d 8h
Merged PRs (30d)
188

Description

### Description

I have 3 databases named 'wms_n' runting on 3 servers. Those databases are replicated to one server with database names rewrite. Database from server A is renames (by replication process) to be wms_A the same happens to to other databases.
Here example of the setup https://percona.community/blog/2018/09/10/multi-master-with-mariadb-10-tutorial/

The problem is that update statement has embedded database name and incorrect entry is written into bin log. Instead of
UPDATE wms_n.TABLE1 ...
we should have:
USE wms_n
UPDATE TABLE1

this way replication process can re-write the database name before the UPDATE statement.
Otherwise the replicated database reports error that wms_n database doesn't exists.

### DBeaver Version

Version 22.3.0.202212041619

### Operating System

macOS Ventura 13.0.1

### Database and driver

MariaDB 10.4.12

### Steps to reproduce

1. Setup Multi-Master replication as per (https://percona.community/blog/2018/09/10/multi-master-with-mariadb-10-tutorial/)
2. Update values in any of the tables on one of the master servers.

Expected behaviour value updated on replicated server (in renamed database)

Actual behaviour replication process reports that the database doesn't exists

### Additional context

_No response_

Contributor guide

Open the contributing guide

Assessment

This issue has not been assessed yet.

Get new issues in your inbox

A short digest of beginner-friendly GitHub issues.