All Questions
Tagged with restore replication
30 questions
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
1
answer
106
views
SQL Server - moving databases to an earlier version - options
I have inherited a vendor product. It’s currently very old, having been installed in 2013 and never updated in the 11 years since. The database server it’s using for its 3 database is SQL Server 2008 ...
- 21
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,...
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
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
1
answer
40
views
What is the correct value (GB) to shrink a DB?
My database has an MDF file of 56 GB and an LDF file of 263 GB, recovery model is setting to Full.
So, I would like to shrink the LDF file because we are out of space. What specific size should I ...
0
votes
1
answer
164
views
Would MySQL Replication (master-slave) have prevented this problem?
I'm new to the idea of MySQL Replication (mainly because I've never really had data important enough to have redundancy until recently). Today I had a random crash of my MySQL 8 database with the ...
- 105
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
1
vote
2
answers
508
views
How to replicate from Standby mode database
I have set up a pipeline which brings transactional logs each hour from a FTP site, and this newly created database is in Standby mode all the time because I need to read data during an office hour.
...
- 251
0
votes
2
answers
68
views
Spinning multiple environments from single backup file
I am having a unique situation where my production database size 5TB (SQLSrv) which needs to be replicated across 4 servers daily. I am looking for an option where all 4 environments can use a single ...
- 1
0
votes
1
answer
476
views
Is there a better way to add failed node back to postgres cluster?
There are 2 nodes in the cluster: node1(primary) and node2(replica).
I will shutdown node1 and promote node2 as primary.
I'll add the node1 back to the cluster (as a replica this time), so I am using ...
- 123
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
5
votes
2
answers
2k
views
how to remove all permissions in a database?
every time I need to either restore a database or reinitialize a replication publication I first (on the restored to be or subscription database) I script all the permissions, triggers, indexes, ...
- 16.6k
0
votes
1
answer
144
views
how to upgrade postgresql 9.0.4 to latest with minimum downtime
I have master-slave-slave setup for postgresql 9.0.4 in our production setup.
We need to upgrade it to latest (11.X), so my question is what would be the procedure to do so with as little downtime as ...
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 ...
3
votes
1
answer
7k
views
unable to start the standby postgres database
Situation
I have 2 separate instances. Both running on Ubuntu 14.04 server.
Both have installed postgres 9.5 the following way:
sudo apt-get install software-properties-common python-software-...
- 215
4
votes
3
answers
8k
views
Migrating 300 GB mysql database from one server to another cleanly with minimum downtime
I have a 300 GB mysql database which i want to migrate to another server in order to setup Master-Master replication between the two and my main aim is to achieve this with least possible downtime.
...
- 151
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 ...
2
votes
1
answer
8k
views
Error 468 MS SQL Server : Couldn't resolve collation conflict between Arabic_CI_AI and Arabic_CI_AS when enumerating publications
When I try to expand the list of local publications under Replication element in SQ Server Management Studio, I get the following error :
Here is the detailed error log :
=============================...
- 659
5
votes
1
answer
663
views
What is Data Virtualization?
I've just been asked whether our company should consider Data Virtualization for our test environments. The benefits are given as:
Screening of sensitive data
Fast data refreshes in our test ...
- 449
2
votes
1
answer
2k
views
Restoring a replicated SQL Server database in a non-replicated testing enviroment
We have a SQL Server 2008R2 database in production. Originally, the database didn't have replication. Every time there was some problem with our software, we'd just create a backup from the production ...
- 21
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.
...
3
votes
1
answer
2k
views
MongoDB: dbclient_rs replSetGetStatus failed{ ok: 0.0, errmsg: "unauthorized" }
When I'm using mongodump or mongorestore on a replica set these messages appear in the verbose output:
dbclient_rs replSetGetStatus failed{ ok: 0.0, errmsg: "unauthorized" }
The replica set is ...
- 63
0
votes
1
answer
93
views
Restore databases from prod to test server with data over X days
We've got a list from app owners to restore say 20 databases from a total of 100 available production server databases onto a test server on weekly basis.
Moreover, they require it in a way that ...
- 7,177
16
votes
2
answers
33k
views
Mongo DB Replica set Stuck at RECOVERING state
We have created a replica set and now the problem is 2 members of replica set [3 members set] are in recovering mode from 48 hours. Initially the size of recovering nodes was increasing and now even ...
- 161
3
votes
2
answers
2k
views
After Restore Log_reuse_wait_desc of Replication
I'm wondering if anybody has ran into this issue before and has any suggestions on what's causing it/how to fix it. We are restoring a database into lower Dev environments and after the restore the ...
- 709
4
votes
1
answer
5k
views
Invalid object name 'master.dbo.MSreplication_options' when restoring DB
I've tried Googling for an answer to this but have got nowhere.
I have one SQL Server instance whose replication is set up to be a publisher and a distributor of FooDatabase. I have a second ...
- 697
7
votes
1
answer
2k
views
SQL Server considerations when backing up / restoring a database that uses replication
In the event that I need to restore a database involved in replication, what considerations do I need to keep in mind?
Do I need to keep backups of both the publisher and the subscriber?
Can I ...
- 785