Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [master-slave-replication]

250 questions
15
votes
2 answers

Trying to understand SHOW SLAVE STATUS in MySQL

I have a Master-Slave replication setup and it looks like that it is running fine. Below is a result of SHOW SLAVE STATUS command: show slave STATUS\G; *************************** 1. row *************************** Slave_IO_State:…
newbie14
  • 951
  • 3
  • 17
  • 25
5
votes
3 answers

MySQL Master/Slave replication on same VM instance?

I'm fairly new to databases so I hope this isn't a silly question! Is it possible to set up master/slave replication on the SAME server? I understand there are not any advantages to this in terms of hardware utilisation/recovery purposes, but a set…
Stephen91
  • 113
  • 2
  • 7
4
votes
1 answer

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 few users, we deployed using one EC2 instance and an…
Mahmud Al-Noor
  • 41
  • 2
4
votes
2 answers

PostgreSQL service start failed on CentOS 7

Installed PostgreSQL using: sudo yum install postgresql-server postgresql-contrib PostgreSQL version: 9.2.18 When start service: sudo service postgresql start Got error: Redirecting to /bin/systemctl start postgresql.service Job for…
cloud_cloud
  • 295
  • 2
  • 6
  • 12
4
votes
1 answer

Can PostgreSQL slave server act as master for a new database?

My question is somewhat related to: https://stackoverflow.com/questions/19331577/does-postgres-replication-native-support-per-database-level-replication We have master-slave replication set up on our Postgres server (1 master and 1 slave). We have…
arun
  • 145
  • 5
4
votes
3 answers

In replication A->B->C, can A be binlog_format=STATEMENT and B be binlog_format=ROW?

I have replication setup between an on-prem MySQL 5.6 server (A) to another on-prem MySQL 5.6 server (B). I was setting up an AWS DMS instance (C) that I wanted to migrate and then replicate. It told me that I had, then, to have my binlog_format…
Aaron R.
  • 143
  • 5
4
votes
0 answers

Slave is not configured or failed to initialize properly. You must at least set --server-id to enable either a master or a slave

I am trying to setup multi source replication. In my slave I have defined following two properties in its configuration file. master-info-repository=table relay-log-info-repository=table These entries are needed because I am defining channels in…
Frank Martin
  • 431
  • 1
  • 5
  • 17
3
votes
0 answers

Got fatal error 1236 from master when reading data from binary log

I am trying to do a MySQL failover, in some situations I endup with broken replication. Any idea what could be the cause of it ? Background Needed to perform a host updates on master host. Hence promoting one of the slave as new master and restore…
RobinHood
  • 39
  • 1
3
votes
2 answers

Change host IP of master in mysql replication

I have one master and one slave. Suppose IP of master is changed but the physical server is same. Now I want to update the new IP (of the master) at the slave server. At the slave server master_info_repository is set to TABLE. I want to resume the…
srvnk
  • 51
  • 4
3
votes
1 answer

MySQL 8.016 master with MariaDB 10.2 slave on AWS RDS, Character set '#255' is not a compiled character set

I have a MySQL 8.016 master and a MariaDB 10.2 slave, both running on AWS RDS. This was working perfectly until today, when I figured I wanted to do chain replication instead, like this MySQL 8.016 -> MySQL 8.016 -> MariaDB 10.2 However, after…
Magnus
  • 135
  • 5
3
votes
0 answers

RESET MASTER; does not reset GTID_EXECUTED

I'm trying to get replication up and running between two kubernetes pods, and am getting the dreaded @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL.GTID_EXECUTED is empty. error. root@central-vm:~# mysqldump -u root -h 10.151.0.36 …
RonJohn
  • 405
  • 1
  • 4
  • 17
3
votes
0 answers

How to get the Slave commit timestamp using MySql replication?

I've been looking for ways to collect information about the replication delays on MySql 8. I found an alternative solution, but I imagine there's a more straightforward way to do that. By reading its reference manual, I found out that I could get…
Wilson Neto
  • 31
  • 2
3
votes
1 answer

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 extra indexes (large machine which runs some analytics queries). So I have to maintain two sets of indexes. But this usually creates a problem when I want to…
chinmaygupta28
  • 31
  • 2
3
votes
1 answer

How does one scale out with master-slave replication?

To my understanding, a master-slave replication might be set up where clients can read from multiple databases. However, they can only write to the master. I believe this helps guarantee ACIDity. I also understand one-way replication seems generally…
dthree
  • 261
  • 1
  • 5
  • 15
3
votes
0 answers

Replication doesn't resume once it fails to connect

We have MySQL replication running for our application. Right now the slave fails to resume if it fails to connect to the server for some time. We get the error below: [ERROR] Slave I/O: error connecting to master 'replication-user@master-ip:3306' -…
Mritunjay
  • 89
  • 3
1
2 3
…
16 17