Stack Exchange Network

Stack Exchange network consists of 174 Q&A communities including Stack Overflow, the largest, most trusted online community for developers to learn, share their knowledge, and build their careers.

Visit Stack Exchange

The tag has no usage guidance.

0
votes
0answers
5 views

percona slave ERROR 1872 (HY000)

I have setup PXC on CentOS 7.5 and replication between PXC nodes is working just fine. However, when I try to set up a slave on one of the PXC nodes, I get this error when I run "START SLAVE". root@...
0
votes
1answer
15 views

Does the row locking on slave database also apply to master database?

In a transaction, for example, START TRANSACTION; SELECT count(*) as count FROM `order` WHERE user_id = 25286 LOCK IN SHARE MODE; INSERT INTO `order` (`id`, `user_id`, `product_id`) VALUES (NULL, '...
0
votes
0answers
22 views

Cascading binary replication to logical postgres

Im using Postgres 10, and I was wondering if its possible to cascade a logical replication from a binary slave replica? I am looking to have databases with the same data but indexed in a different way ...
0
votes
1answer
20 views

Create a mysql replication from multiple master and single slave server? [closed]

How to create mysql replication with multiple master server and with single slave server? how to edit the "CHANGE MASTER TO MASTER_HOST='12.34.56.789',MASTER_USER='slave_user', MASTER_PASSWORD='...
0
votes
0answers
16 views

pglogical - Table Replication with pglogical, locks on sync_init status

I've successfully installed and got working a pglogical replication between 2 servers: Provider: Postgresql 9.4 Subscriber: Postgresql 9.6 From time to time, I need to add some tables (or entire ...
0
votes
0answers
17 views

MYSQL 5.6 Replication broken in mixed base binlog format

I am using MySQL replication with binlog_format=mixed on master, but still Im getting error 1032 many times. Last_SQL_Error: Could not execute Update_rows event on table mydb.mytable; Can't find ...
0
votes
1answer
17 views

Mariadb 10.1.13 - log positions similar but “seconds behind master” is behind

The setup I have is a master/slave replication, both running Mariadb 10.1.13. On the slave I noticed that the Seconds_Behind_Master parameter is showing a delay due to some form of lagging, but the ...
0
votes
1answer
27 views

Mysql Slave Claims to be Running but New Records Not Appearing and No Delay

I've created a new mysql master and a slave. My master is also a slave of another running instance. The replication between those two works fine so I don't believe my issue is there. I created a dump ...
0
votes
1answer
15 views

MySQL how to migrate to new server without data lost?

I'm using AWS RDS, with 1 master & 1 slave. Just now I alter 1 of the table and hangup halfway, so I force stop the process. Now the database got some problem. Let say I wanted to instantiate a ...
2
votes
1answer
21 views

Can I stop replication of create/drop index statement on one slave of Mysql 5.6?

I have this cluster where master and slave uses same indexes but one of the slaves has some some extra indexes (large machine which runs some analytics queries). So I have to maintain two sets of ...
1
vote
1answer
40 views

Master-slave replication doesn't work on PostgreSQL 9.6

I tried to create a master/slave configuration with two servers and Postgres 9.6 I modified master and slave postgresql.conf in /etc/postgresql/9.6/main Same for master and slave: data_directory = '...
0
votes
1answer
22 views

Some dates replicated with a +4 offset

I've set up replication between an EC2 instance as master and a MySQL 5.5 RDS instance as slave. Everything is (mostly) fine except for one odd thing: the dates in a transaction table are either ...
1
vote
1answer
24 views

Replication of databases with specific prefix on master

There are options to dynamically set variables on replication slaves, like replicate_wild_do_table and replicate_wild_ignore_table. But, are there any options for replication master to dynamically set ...
0
votes
0answers
47 views

Postgresql Replication stopped unexpectedly Slave server's service is not starting. How can I Resume replication?

Postgres Replication was working fine with Postgresql version 9.5. when the template of a DB with 10gb of data was created and then the slave server stopped. Its Postgres service is not starting now. ...
0
votes
1answer
49 views

Master DB Ran Out Of Space

My master server ran out of space today (at 20:22). My transactions logs ended up broken into multiple files: -rw-rw---- 1 mysql mysql 228M Jul 31 20:22 mysql-bin.000914 -rw-rw---- 1 mysql mysql ...
2
votes
1answer
79 views

MySQL Replication binary relay logs transfer too slowly

Master server MySQL 5.6.28 Ubuntu 14.04 8 core CPU Slave server Slave: MySQL 5.7.22 Ubuntu 18.04 16 core CPU Both of them have 64GB of RAM and plenty of disk space. What I did up to this ...
0
votes
1answer
125 views

MariaDB master-slave replication failover and failback

I'm trying to configure a DR instance of MariaDB (10.1.13) using master-slave replication. I was able to establish the master-slave relationship with GTID by locking the tables on master, backing up ...
0
votes
0answers
41 views

Add new slave in MariaDB Replication

I have a Master server (A) and a Slave server (B). B is getting replicated from A [all the dbs (db1,db2,db3) except few tables]. Now, I need to add one more Slave but It has to replicate only db1 and ...
0
votes
1answer
56 views

PostgreSQL Slave keeps xlog files with replication slot

I setup one master and two PostgreSQL servers (v9.6). In the master (and slaves) I set max_replication_slots = 2 and archive_mode is commented out everywhere. The replication works fine: There are no ...
1
vote
0answers
410 views

Slave is running behind master on some slaves [closed]

I have set up of master and 300 slaves. Into this many Slaves are bare metals which are having more slaves as tail end nodes. All mysql versions are 5.6.22 Binlog format is MIXED based. sync_binlog = ...
0
votes
0answers
20 views

percona mysql key_buffer_size value on replication slave

I noticed way odd behavior of replication slave due to altering key_buffer_size parameter. I have 5.6.39 version of percona mysql and RAM 257671MB, according to the articles in the Internet i ...
1
vote
1answer
86 views

Why is MDB 10.2.14 not handling deadlocks properly when it did prior to upgrade from 10.1.22

Since upgrading MariaDB 10.1.22 to 10.2.14 our MariaDB slaves are encountering deadlocks that are not handled in less than 600 seconds thus the classic semaphore decision to crash the server. The ...
0
votes
0answers
128 views

Master-slave replication in MariaDB

I worked around with Master-slave replication in Mariadb 5.5.52 on RHEL 7.3 environment. Master: [mysqld] log-bin server_id=1 binlog-do-db=nagios binlog-do-db=nagiosql binlog-do-db=nagiosxi bind-...
1
vote
0answers
396 views

Queries running very slowly in Amazon RDS PostgreSQL read-replica

We have been maintaining a project which has both web and mobile application platform. The backend of the project is developed in Django 1.10 and deployed in AWS. At the beginning, when there were ...
0
votes
1answer
44 views

Row-row based logging in a blackhole replication filter setup?

I am using two MySQL server instances on the same server to filter replication to a third external server. My filter slave is using the blackhole engine as described here: https://dev.mysql.com/doc/...
0
votes
1answer
41 views

Row based replication on slave where as statement based on Master

We have a master slave setup of MYSQL 5.6. Master and slave runs SBR replication where as slave is not writing binlogs. We need to enable binlogs on the Slave server but we want the binlogs to be in ...
0
votes
1answer
42 views

Restore server instance using logical backup and wal files

Is it possible to restore a database instance using logical backup and wal files? A senior SQL Server DBA asked me to implement below scenario in PostgreSQL took the logical backup using pg_dumpall ...
1
vote
1answer
180 views

Load balancing between 2 servers using MySQL Router

I want to setup a simple master-slave MySQL replication. I also want to balance the load between the 2 servers. Can I use MySQL Router 2.1 for that purpose? As I read the official documentation, it ...
0
votes
2answers
43 views

slave mysql configuration is not stored

EDIT It seems that the problem is with my SSH connection, so I created a different question on serverfault. From what I understand so far, it that this problem is caused from the fact that the port ...
1
vote
1answer
713 views

Mysql replication broken due to 'Duplicate entry' with error code 1062 on slave server

Mysql Slave replication was working fine, but suddenly it has crashed due to duplicate entries error The slave SQL thread stops due to duplicate entries in MySQL DB, which I have kept in ...
0
votes
0answers
122 views

Postgresql - Unable to connect slave after replication starts, but able to connect from remotely

I have a PostgreSQL master/slave setup. Today I created a new slave from the existing slave (cascading replication). Master: 10.0.0.1 Slave1: 10.0.0.2 Slave2: 10.0.0.3 (this is the new one I have ...
1
vote
1answer
50 views

Cross-Continent SQL High-Latency Data Synchronization

How would one go about synchronizing a MySQL database cross-continent, while keeping the distributed application using the DB running fast (<0.2s page loads) ? My database contains about 2.5GB of ...
0
votes
1answer
296 views

mariadb Unknown system variable 'server_uuid'

Im trying to setup replication between mariadb(10.1.31-MariaDB - MASTER) and mysql(5.7.12-log - SLAVE). After executed the start slave, I got the below error. Fatal error: The slave I/O thread ...
1
vote
1answer
30 views

Howto reliably ship WAL log files between master and slave

I have a replication master and a slave on two different computers. Actually both databases are running in docker containers, and their WAL archive directories are exposed to the host machine using ...
0
votes
1answer
30 views

Single slave for multiple masters in AWS AuroraDB

We are planning to use AWS Aurora(MySQL version) as our relational database. There will be three masters in different regions. We need the data from these masters replicated in a single slave. I think ...
0
votes
0answers
17 views

Not getting relay logs in slave(MySQL 5.6.34)

Not getting relay logs as Master_Log_File and Relay_Master_Log_File are not moving and SBM is 0 even there is 24hrs sql_delay. log-bin is enabled in master and it is the final master. Plz suggest
1
vote
1answer
36 views

PostgreSQL Master server act as a slave for 2nd DB on new server

I have a strange situation I'm are trying to resolve. I've googled around but I haven't found a clear answer so I thought I'd pose it to the good people at DBA on StackEx to get a second opinion. We ...
1
vote
0answers
61 views

When the master db fails, the slave db will enable the write mode. How do I synchronize the master db with the information written to the slave db?

have two database. They are db1 and db2. db1 master, slave at db2. d1 have write/read mode. d2 have read mode. I have a problem like this: When the master db fails, The slave db will enable the ...
0
votes
0answers
17 views

MySQL Slave fails to flush privileges as Master gets flushed

0 down vote favorite I run into the issue with my slave mysql databases. When I flush the master server it fails to flush slave databases. What should be considering when adding a new user to MySQL.
0
votes
0answers
114 views

PostgreSQL: How to throttle writes when replicas lag?

I've recently started working with database read replicas. One of the projects I'm working on has an AWS RDS PostgreSQL setup where there's one write-database and multiple read-replicas. Sometimes, ...
-1
votes
1answer
58 views

MySQL Replication Relay for Peer-to-peer replication for Multi-master replications [closed]

Any one knows about MySQL Replication Relay for Peer-to-Peer Replication for Multi-master replications? Please share if you know anything with example and syntax for multiple clients with as masters ...
1
vote
0answers
48 views

MySQL Lagging Slave Across Data Centers

We seem to have a strange issue from time to time during heavy write workload , a slave in a different data center starts to lag behind the master but when we STOP and START the slave the it starts to ...
0
votes
1answer
130 views

commit or rollback on a statement based replication, effect on auto increment id

How commit or rollback is safe on statement based replication in terms of auto_increment column? If I execute below queries, shoudn't there be discrepancy between master and slave in auto_increment ...
0
votes
1answer
126 views

Stored procedure in master slave replication

I have a master-slave replication for a schema products which is being replicated with binlog_do_db = products. one of the the tables in the master schema is being archived by calling a stored ...
0
votes
0answers
95 views

postgresql10 master can't create/dropdb when wal_level=replica and slave fails

I'm new to the postgresql. Come across this issue and has been scratching my head for couple of days now. Can someoen explain below behavior. I have 2 postgresql-10 servers, one master one slave. ...
0
votes
0answers
81 views

Maxscale binlog router doesnt read from backend

I am just configuring a maxscale 2.1.13 server as proxy and i found a problem with the binlog router. It doesnt recognice the backend servers hence it cannot connect to them and retry the users and ...
3
votes
1answer
780 views

Can I use MariaDB as a replication slave for MySQL?

I've been a MySQL user/administrator for many years and I've been considering a switch to MariaDB. We have a statement-replicated setup with a MySQL slave and I've been thinking that one way to ease-...
0
votes
1answer
42 views

Do i need streaming replication slots as many of replicas in postgres?

Correct me if I am wrong but I’m thinking that if I have 4 different read only replica servers I need 4 streaming replication slots, one for each of them? Or all of them can you use one?
1
vote
0answers
72 views

MongoDB not performing well when set Read from secondary

I have a mongoDB database, with 1 primary and 1 secondary in replicaset(and 1 arbiter). Both the servers are hosted on aws on c4.2xlarge instances(with 1.5 TB of SSD on each). Mongo version of primary ...
0
votes
1answer
98 views

Mongo replicaSet dispersed over all continents

I have problem in operating mongo replicaSet which works on all continents. The primary data is located in Europe and want to replicate it distant locations in US, Brasil, Tokyo, Sydney and Dublin. ...