All Questions
Tagged with restore replication
11 questions with no upvoted or accepted answers
1
vote
1
answer
106
views
MySQL to MariaDB migration - user view breaks compatibility with backup-restores and replication
I am trying to migrate an Ubuntu 18.04-Server with Oracle's MySQL to a Ubuntu 22.04-Server with MariaDB 10.6.12. I've established a replication between the databases, which worked. Alone, the User ...
- 11
0
votes
1
answer
19
views
How can I replicate transactions one by one in mysql?
I have one source server and one replica server. And I set source_delay 30mins, replication is gtid based, mysql version is 8.0.24
If I accidentally drop table A, Can I apply transactions just right ...
- 1
0
votes
0
answers
12
views
How to restore a backup and incremental backup of scyllaDB
I am working on incremental backup and restore. When I am trying to restore the incremental backup, after restoration, I am getting an error on cqlsh shell.
ReadFailure: Error from server: code=1300 [...
0
votes
0
answers
47
views
LSRestore job is taking more than 1 hr to complete. Threshold time is 45min
LSCopy and LSRestore job has been scheduled for every 10 mins. I got a trn file on my secondary server after every 6 min from Primary server. LSCopy is synced with LSBackup. The problem is that ...
0
votes
1
answer
229
views
How to make sure that all required wal files are availables before starting a standby server?
Im writing a script to restore a postgres standby server that was out of sync with the master node for a while.
I would like the following behavior
Check if i can go with pg_rewind
If pg_rewind fails,...
0
votes
0
answers
136
views
Mongodb setup replica set in parallel on same server
I would like to know how to proceed to deploy a mongodb replica set environment on my servers where, in turn, other mongodb instances are already running, the following happens:
I have a mongodb ...
- 169
0
votes
0
answers
176
views
How to specify a sync source when adding a new member to a MongoDB replicaset?
Recently we had a machine physically destroyed, so our replicaset is now: Primary - Secondary - Arbiter (250G on disk, 20G (70hrs) oplog).
So, I'm trying to add a new member (4.4.10) to the replicaset ...
- 1
0
votes
1
answer
23
views
restore table and populate new data from transaction log
I use mysqldump nightly to backup a database. I'm trying to find a way to do a partial restore on the data from one table. I use the --master-data flag so I know where in the transactions log my data ...
- 149
0
votes
1
answer
90
views
Mongodb restore “local” db
I need to restore a replica set. Unfortunately my lack of experience as administrator (I'm not) let me with the only solution of restore the replica using the data of the primary db (the only replica ...
0
votes
1
answer
232
views
recovery with binlogs?
I would like to know if there is a way that I can restore my databases, I don't have a replication and I would like to migrate my databases without downtime or losing data.
So with binlogs could I do ...
0
votes
2
answers
106
views
MySQL - replicate some tables between transaction and report database
I have two different database (on two different hosts). One database is transactional and another database is reporting. Let us say, it stores information about departments and their employees.
...
