Questions tagged [database-replication]
The database-replication tag has no usage guidance.
105
questions
0
votes
0
answers
27
views
Live database migration MariaDB 10.5 to MySQL 8.0
I need to move a busy OLTP database from self hosted MariaDB 10.5 to Google Cloud SQL for MySQL 8.0 with minimal downtime.
The source is a self managed VM instance in Googles Cloud with replicas, ...
1
vote
0
answers
149
views
Replicating foreign keys with AWS DMS Full load Ongoing replication - MySQL
I am using AWS DMS Full Load Ongoing Replication (CDC) to replicate data from a MySQL RDS to an on-prem MySQL server (both of them running MySQL 8). Before starting the replication process I'm dumping ...
1
vote
0
answers
308
views
Using MySQL/MariaDB replication, how to know when the Replica is in a consistent state?
This is a question about MariaDB (mostly) and a replication that I am considering.
For this replication, the Primary database is updated every minute by a process which can take about 15 seconds to ...
2
votes
1
answer
612
views
Is it possible to have MySQL/MariaDB bidirectional replication?
I am trying to install replication on several MariaDB servers.
With no experience at all on this.
I am wondering something.
Would it be possible to have both servers acting simultaneously as master ...
0
votes
0
answers
215
views
What is the efficient way to copy large database from one server to another?
I have a SQL server's full database backup job that runs daily at night.
Currently, I need to stay up late every night to copy that backup file (around 300GB in size) to 5 servers in different ...
0
votes
1
answer
36
views
Real time synchronization of databases with different data structure
I'm rewriting a legacy web application. At some point in time, I want old and new app, to work in parallel, on databases with different structure (both mysql). The troublesome part is that the ...
0
votes
1
answer
373
views
Can Oracle GoldenGate work between different version of Oracle
Can we use Oracle GoldenGate to sync data between different versions of Oracle ?
Our source database is 11.2.0.4 and target is 19.0.0.0
0
votes
0
answers
23
views
What are my options for a distributed, row-oriented database?
(Sorry if this isn't the right forum. StackOverflow doesn't seem right, either. I thought there used to be a description on the home page saying what kind of questions were relevant but I can't find ...
0
votes
0
answers
53
views
MySQL not saving to separate data directories
Lately I've been struggling with MySQL and it's data directory a lot.
At first, I've tried docker for multiple instances but our company doesn't prefer docker no one knows why.
So I come up with a ...
0
votes
1
answer
251
views
MYSQL: Many slave servers with smaller resources or less with larger resources
I want to create High availability with Master Slave replication (for Select query).
I am wondering which one is better:
Having smaller resources slaves but more servers or
Having larger resources ...
0
votes
1
answer
95
views
Add own host to replicaSet hosted with cloud provider with limited access?
So I have this mongoDB (3.0.x) replicaSet hosted with a cloud provider called "NodeChef".
To my knowledge, and scouring the documentation, I have no access at all to the underlying host(s).
...
0
votes
1
answer
66
views
Best practices for database with direct user input
I’m currently working on a dynamic project, in which the users feed the database with new objects/data. Other users can later access the data other users provided.
Because the data’s coming directly ...
0
votes
1
answer
5k
views
Error 'Character set '#255' is not a compiled character set and is not specified mySQL
Okay, I've hit a brick wall and have run out of ideas.
Master: 8.0.25-0ubuntu0.20.04.1
Slave: 5.7.33-0ubuntu0.16.04.1-log
Getting error with show slave status\G:
Last_SQL_Errno: 22
Last_SQL_Error:...
0
votes
2
answers
286
views
Mysql Server, with Mariadb Slaves, disk usage high and many binlog files
I have a Mysql Master server and a few MariaDB slaves connected to it. I have an issue in that my disk usage on the slaves have gone a bit mad.
My master server is 163GB with bin log files of 100Mb ...
0
votes
1
answer
380
views
Can't restore master/slave replication from Percona backup (slave server)
A slave is restored from a master backup created with Percona xtrabackup
On the master binlog is set to expire in 14 days and this backup is less than 24 hours old
my.cnf (master)
expire_logs_days = ...
0
votes
0
answers
254
views
How does one go about using master to master replication along with something like rsync to keep two identical copies of an application identical?
I have servers that do things for me at home, for instance they keep copies of my bookmarks in the way that del.icio.us used to (nextCloud) and keep copies of my code (gitea).
Initially I thought that ...
1
vote
1
answer
4k
views
How to change hot_standby_feedback parameter for an existing database replica in RDS
I have a primary database instance and its read replica, both running on Amazon RDS for PostgreSQL. Recently the replica started to get a lot of canceling statement due to conflict with recovery ...
2
votes
1
answer
391
views
Add 3rd server with pglogical replication to a 2 server cluster with stream sync replication and failsafe with patroni
I have 3 servers with Ubuntu 19.10, PostgreSQL 12.2 and Patroni 1.6.4 and I would like to have the following setup:
I want to have two servers with synchronised replication
and I want to add a 3rd ...
1
vote
1
answer
387
views
Databases "Synchronized / In Recovery" after adding server to SQL Avaylability Group
I have an SQL AlwaysOn Availabilty Group configured with 2 nodes. The AG works without any problem with this 2 nodes and I can do a failover to/from any of them (this servers are on the same network).
...
2
votes
2
answers
2k
views
Automaticaly restoring SQL replication after power outage
I have two Sql databases, "MASTER" and "SLAVE", and I use Sql replication to get them synchronized. I'm using MariaDB 10 on both databases.
The MASTER database is installed on a linux PLC using Docker....
1
vote
0
answers
35
views
MS SQL 2008R2 Peer-to-Peer replication Zombie data
We have two SQL 2008R2 boxes - each in a geographically separate data center - that stay sync'd using peer to peer replication (with a pair of smaller boxes acting as replication providers). This ...
0
votes
1
answer
285
views
MongoDB - Database Profiler does not capture queries sent to secondaries replicas
I'm new to MongoDB and need some help to understand how profiler works with replication in Mongo.
I have a replica set with three instances and the secondaries are used for read only by the ...
0
votes
0
answers
497
views
Master Master replication between RDS and database instance on EC2 Errno: 1032
I face this error many times with my replication
Last_SQL_Error: Could not execute Delete_rows event on table
db_name.event; Can't find record in 'event', Error_code: 1032; handler
error ...
0
votes
1
answer
1k
views
Mysql Master-Slave replication database duplication issue
I have done master-slave replication for performing web-server mirroring. Web contents are getting replicated properly. But I am facing issue in database replication. Database is replicated and slave ...
0
votes
0
answers
975
views
MongoDB secondary crashes on initial sync because of too many journal files on RAID 10
My secondary DB server went down, so I'm booting up a replacement secondary and trying to perform the initial sync.
I've been following the tutorials and advice out there to use RAIS 10 on Amazon EBS
...
-2
votes
1
answer
339
views
how to initiate and maintain mongo shard replica set from mongos server? [closed]
I am trying to initiate a mongo shards replica set from mongos server, I want my mongos to maintain replica set and able to add new server to replication if needed.
1
vote
0
answers
328
views
Moving entire database server to Galera cluster
We currently have more or less the following setup:
Three individual MySQL database servers (individual Linux machines) with 15 to 50 logical databases and 20 to 50 GB of data
Galera cluster (MariaDB)...
6
votes
2
answers
693
views
SQL Server Failover strategies
In my infrastructure I have a SQL Server 2014 Standard standalone server.
As databases and applications which are using SQL Server are growing up, I want to upgrade to SQL Server 2016 Standard and ...
1
vote
1
answer
69
views
Local PC to Cloud - Network Connectivity Issue
What I'm trying to do:
I trying to setup SQL Server log shipping between my desktop and Oracle Cloud. I have a developer edition of MSSQL installed in both my desktop and Oracle Cloud instance.
...
5
votes
2
answers
1k
views
Using Amazon EC2 for postgres_fdw or BDR replication
I've been tasked to do two proofs of concept with Postgres on Amazon RDS, one with postgres_fdw and another one with BDR (bi-directional replication extension). After many searches on the internet, it ...
0
votes
1
answer
204
views
mysql replication fail (no error)
I'm doing a replication on a mysql 5.6 server (master) to a slave in mixed mode.
The thing is, i connect to mysql trought workbench, i execute querys and are replicated.
But if another user connected ...
1
vote
1
answer
330
views
Is it possible to replicate _users in CouchDB with a non-admin user, but "users_db_public = true"?
Via a non-admin user, I am able to GET any user with users_db_public = true and public_fields set to something valid without authorization problems, as expected.
However I am getting 401 (Unauthorized)...
0
votes
1
answer
5k
views
Database server vs NAS for data files
Regarding costs and maintenance speed/simplicity in case of hardwar failures, does it make any sense to keep SQL data files on a NAS server, separate from the SQL Server instance? Our app stores large ...
0
votes
1
answer
313
views
Is it possible to do database replication on aws s3
I have 4TB database in company. As many different analytics require that full data the current database is not able to handle concurrent session from 100s of users.
Is it possible to have databse ...
0
votes
0
answers
260
views
SYNC MYSQL database instantly from one Digital ocean server to another
I have a site (data entry site ) on a Digital Ocean server and its database ( MYSQL ) is being updated with new records every second.
I am hosting the public site on another Digital ocean server ...
-1
votes
1
answer
322
views
Error when I run "bucardo add database mybd"
This is the message error:
install_driver(Pg) failed: Can't locate DBD/Pg.pm in @INC (@INC contains: /usr/local/lib/perl5 /usr/local/share/perl5 /usr/lib/perl5/vendor_perl /usr/share/perl5/...
2
votes
0
answers
722
views
How to automate failover of master in PostgreSQL 9.5 on Windows?
I have 4 nodes (version - PostgreSQL 9.5 Beta) in a slot replication set up. Recently the master node, due to less disk space available, PostgreSQL started throwing errors and crashed in the end. As I ...
0
votes
1
answer
3k
views
Postgres 9.5 server not starting due to already active replication slot
I have a Postgres (version - 9.5 Beta) server replication set up where there are 3 slaves and a primary server. After all required configuration is done, I start 1st slave after taking base backup and ...
3
votes
1
answer
5k
views
Slot replication not working in Postgres 9.4
I am using Postgres 9.4 on Windows 2008 server. There are three such instances that I am using. One as master and the rest of the two are slave/standby. The version of Postgres is 9.4 in all the three ...
1
vote
1
answer
113
views
How to handle replication post SQL Server 2000/2008 migration?
I have two servers; server A host SQL Server 2000 and server B ( a remote server) host SQL Server 2005. I replicate data between these two servers using transactional replication. I recently migrated (...
2
votes
2
answers
12k
views
repmgr - after a failover switch, both nodes act as a master
I have a two node PostgreSQL cluster configured through repmgr.
The database topology looks like this:
db1 - 10.10.10.50 ( master )
db2 - 10.10.10.60 ( standby )
wit - 10.10.10.70 ( witness )
The ...
5
votes
2
answers
4k
views
CouchDB replicate ALL databases?
I have a CouchDB I'd like to replicate to another server in order to do backup dumps without taxing the production server. The production CouchDB has a varying number of databases and I'd like to sync ...
1
vote
0
answers
511
views
How can I efficiently create daily write replicas of an RDS instance?
We're looking to create a replica of a postgres RDS instance that our developers can write to (not just a simple read replica that AWS can easily provide). Currently we run a script nightly that ...
6
votes
3
answers
8k
views
Mongo secondaries stuck at startup state
I have a MongoDB replica set with secondaries that won't make it past the STARTUP state. The database is large but they should have moved to STARTUP2 by now. The correct ports are open as I can ...
3
votes
0
answers
664
views
combine two mysql replication log files
So I use a master-master replication of a mysql database and load balance traffic between the two.
This results in server A with a binlog of all it's transactions
and Server B with a binlog of only ...
1
vote
2
answers
2k
views
Ubuntu 2 Node Cluster Postgresql 9.3 with pacemaker and Streaming Replication
I'm trying to setup a 2 Node Cluster with Postresql 9.3 and Streaming Replication.
Streaming Replication is successfully configured. Master is listen up and is sending to slave. I can do failover ...
3
votes
1
answer
2k
views
Postgresql 9.3 Log Shipping on a Hot Standby
My setup
I've just set up streaming replication in postgres for the first time (9.3.5), and while the streaming is working as I expect, I'm struggling to get my standby to run the archive_command so ...
3
votes
1
answer
2k
views
mongodb keep looping while trying to sync data
I'm converting my my standalone mongodb into a replica set. I've added one more member (and I want to add two more members later, and to shutdown the primary server).
My primary mongodb is running 2....
0
votes
1
answer
2k
views
Communication errors while trying to replicate mongodb
I'm trying to replicate my mongodb database, I've crated 2 VM on my windows azure account.
both of them are Ubuntu 14.04.
I've opened 27017 port on both of them, and installed mongodb latest version.
...
5
votes
1
answer
2k
views
Multiple Postgres Servers (one writer, multiple reader) with Shared Disk
Here's the scenario:
One shard disk (Gluster)
Multiple Postgres servers
Requirements:
Use the shared disk to store the database files
Use a configuration which provide maximum efficiency
Findings ...