MySQL version - 8.0.23 on RDS I am replicating my local database to AWS RDS MySQL instance. But I am getting this error: 2021-11-11T22:43:09.091947Z 378 [ERROR] [MY-010584] [Repl] Slave I/O for cha...

I created a read-replica for an RDS instance, Does AWS handles the load-balancing automatically or it needs another configuration or implementation in the code ? and if so Is there a reference for ...

I've searched google thoroughly for a definitive solution or set of steps to resolve this issue, but there don't seem to be many high quality results, and I haven't found the question on stack over...

I'm doing a project that deals with structured document database. I have a tree of categories (~1000 categories, up to ~50 categories on each level), each category contains several thousands (up to...

Can someone suggest the steps to check pgsql replication status and how to identify if the replication is not happening properly? We use streaming replication with pgsql9.0 and pgsql9.4

I run a service that needs to be able to support about 4000+ IOPS and keep replica lag <=1 second to function properly. I am using AWS RDS MySQL instances and have 2 read replica's. My service...

I've been trying to set up two databases as master & slave. I followed the famous guide here: https://dev.mysql.com/doc/refman/5.1/en/replication-howto-existingdata.html But no luck on my sla...

I want to make my PostgreSQL master / slave streaming replication setup into a single master slave setup without replication and without HA. How is it possible to tell master that it no longer has ...

We use Master-Master replication to avoid situations in which writing to replica will get it out of sync with the real master and in case we wish to switch masters. However, there's a seemingly kno...

I have setup replication: master - slave. Slave server works as hot-standby, which means we can run read-only sql queries. How actually can I see that slave server is serving read-only queries?

As documentation said - restart_lsn is: The address (LSN) of oldest WAL which still might be required by the consumer of this slot and thus won't be automatically removed during checkpoints unless...

I used Postgres Database with replication. I have used temp table in postgres function. I unable to update Temp Table while updating it through join. Below is Postgres query(tempallergyupdates is ...

I have a table A_tbl in my database. I have created a trigger on A_tbl to capture inserted records. Trigger is inserting records in my queue table B_tbl. This table has an Identity column with prop...

I have setup a MongoDB replica set with 3 nodes(vm's running CentOS). One node became Primary other 2 stuck in Startup. When these 2 nodes will change their states from startup to secondary. aryab...

I use certain my.cnf settings like this. Does RDS instance allow such options? slave-skip-errors = 1062,1054 replicate-ignore-db=verv_raw replicate-ignore-table=verv.ox_session replicate-wild-...

To set up the replica set, I've run in 3 separate terminal tabs: $ sudo mongod --replSet rs0 --dbpath /data/mining --port 27017 $ sudo mongod --replSet rs0 --dbpath /data/mining2 --port 27018 $...

im trying to measure the replication time lag in my system. (postgresql 10.1) I use a combination of pg_last_xact_timestamp(), pg_last_receive_lsn() and pg_last_replay_lsn() functions in a query t...

I can't find it from documentation, but it seems Master-Master replication is not supported at this time. Is this correct?

I am trying to set up replication between databases. I followed this tutorials: https://learn.microsoft.com/en-us/sql/relational-databases/replication/tutorial-preparing-the-server-for-replication...

I'm trying to add a node to a replica set using rs.add("developer-ViratualBox:30103") and I'm getting the following error message: { "ok" : 0, "errmsg" : "Quorum check failed because not enough vo...

Here is a related question. Why do I get this error even when I have not installed SQL Server replication ? The strangest thing is, when I run the fix sp_configure 'max text repl size', 214748364...

I would like to know how replication works in a distributed database. It would be nice if this could be explained in a thorough, yet easy to understand way. It would also be nice if you could mak...

We have a insert only table for which we often get bad results due to query plan using nested loops instead of hash joins. To solve this we have to run ANALYZE manually (vacuum sometimes don't run ...

I have a mongodb replica set from which I want to read data from primary and secondary db. I have used this command to connect to the db: mongoose.connect('mongodb://user:[email protected],...

We have been using golang's database/sql and github.com/lib/pq with a PostgreSQL cluster, meaning that a certain database server that was a replication master might be a read-only replica after the...