Database Administrators Stack Exchange
Database Administrators Stack Exchange

Questions tagged [master-slave-replication]

294 questions
15
votes
3 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
  • 979
  • 3
  • 18
  • 25
6
votes
2 answers

How to free up hard drive space after deleting millions upon millions of records in mariadb

We have an application where we are receiving information seconds apart, we record this information in a table that we call events, which currently weighs 240 GB, this is the largest we have so far. Some time ago we deleted records to keep records…
Blanca Rodriguez
  • 61
  • 1
  • 2
6
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
  • 61
  • 1
  • 2
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
  • 8
5
votes
1 answer

Why does mysqldump stop the slave SQL thread for the entire backup?

I realized recently that I was using --master-data to dump a backup from a replication slave when what I really wanted was --dump-slave. After switching to --dump-slave, I see that mysqldump will stop the slave SQL thread during the backup (which…
Christopher Schultz
  • 327
  • 4
  • 14
4
votes
1 answer

Does a MySQL replication slave need to be as powerful as the master?

I want to back-up my MySQL server on another server in another location (for data safety). The problem is the other server is half as powerful as the main one. I don't need the server to be 100% replicated. Even one hour difference would be enough…
Cezar
  • 63
  • 6
4
votes
0 answers

MySQL replication - Follower stuck and behind

I understand there are lots of similar problems and threads but non of those solution helped me. Please read through the thread I will try to give as much information as possible: I have setup a replication process 3 days ago and after day 1 it is…
Sisir
  • 141
  • 4
4
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
  • 41
  • 2
4
votes
3 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
  • 353
  • 2
  • 6
  • 12
4
votes
1 answer

Service mongod fails after adding security.keyFile in config file

My mongo.conf: # where to write logging data. systemLog: destination: file logAppend: true path: /var/log/mongodb/mongod.log # Where and how to store data. storage: dbPath: /var/lib/mongo journal: enabled: true # engine: # mmapv1: #…
Abdul Moiz
  • 233
  • 3
  • 8
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
  • 451
  • 1
  • 5
  • 18
4
votes
2 answers

MySQL slave not able to execute long running update query

I am running a Master-slave replication servers of MySQL. As part of clean up of old data, i ran a delete query which deletes huge number of records from the database. It ran fine on Master server but on slave server, it is giving me following…
Ruchit Rami
  • 241
  • 2
  • 6
  • 10
3
votes
1 answer

Postgres max_wal_size and wal_keep_size parameter

I am setting up Postgres v14 database. I have a question related to the max_wal_size and wal_keep_size parameters. According to the documentation: max_wal_size ⇒ Maximum size to let the WAL grow during automatic checkpoints. This is a soft limit;…
dsingh
  • 131
  • 1
  • 1
  • 2
1
2 3
…
19 20