All Questions
Tagged with database-replication java
38 questions
3
votes
1
answer
381
views
How to process the PGReplicationStream from physical replication JDBC API?
I am trying to read the data from physical replication slot using JDBC's ReplicationAPI
I am using Postgres 13
Here is the sample code
LogSequenceNumber lsn = getCurrentLSN(sqlConnection);
...
- 1,057
0
votes
2
answers
1k
views
Can I set readOnly false when I use findById with JPA
I have a problem with modifying data while setting database replication
Before DB replication, I get data that I want to modify using repository.findById() and then I modified the data.
But I realized ...
1
vote
0
answers
54
views
Asking for CMS & its website architecture design using the same MySQL database
CMS and its website use the same MySql database instance (e.g. CMS editor can create, edit website user which will be reflected on a user table, on the other hand, user can be created too when a user ...
- 41
0
votes
0
answers
179
views
How to fix OOM error encountered when performing logical replication through jdbc?
I am developing a java application that uses test_decoding + jdbc driver to do PG logical replication. The main code comes from the PG documentation.
PGReplicationStream stream =
...
- 29
0
votes
1
answer
195
views
Update data in two differents PostgreSQL database servers
I have 2 differents applications (Web app and Desktop app) with differents database servers but same structure.
I want to have the same data in all databases, no matter where the user insert/update/...
- 1
-2
votes
1
answer
326
views
Implementing a simple replication tool [closed]
Our team is working on a project that is intended to transfer data between oracle databases over a DMZ periodically , and for some reason we are not allowed to use DBMS solutions for data replication ...
2
votes
0
answers
224
views
Database Replication from firebird to postgres
I have 2 databases, Firebird and PostgreSQL. And I need to replicate the Firebird information to PostgreSQL when updating the Firebird database. What is the best way to do that? I'm using cron for ...
7
votes
2
answers
2k
views
Why Postgres Replication Stream doesn't work when used in separate function?
I am working on postgres replication stream API. While working on it came across unusual behavior.
When I use replication slot writing whole code inside main block, everything works fine.
public ...
- 305
9
votes
1
answer
2k
views
How could we make use of ClusterListener in Mongo?
I was trying to look for an example or usage of the ClusterListener to optimize and improve the debugging information of a service integrated with MongoDB Java client.
How could this be used by us ...
- 32.2k
2
votes
2
answers
760
views
Bidirectional Replication on Postgresql 9.3
I am using Postgres 9.3 on my production servers. I would like to achieve high availability of Postgres DB using Master-Master configuration where each master would run in an Active-Active mode with ...
- 1,644
-4
votes
1
answer
292
views
Mysql Replication two databases with diffrent table schemas
i am developing web-base distributed database system [ Java RMI with Mysql ]. How do i replicate data between two databases(@ diffrent locations) with different table schema. For example, DB at ...
- 1
1
vote
2
answers
4k
views
How to check if a PostgreSQL logical replication slot already exists with java?
I'm creating a logical replication slot with Java code using the PostgreSQL replication API and I want to add a test before the creation process to check if the slot exists already.
this is my code ...
- 707
0
votes
1
answer
5k
views
Spring+Hibernate: read/write different datasource and thousands mysql databases
I need to use separate reader/writer MySQL servers. One writer and one (or more) read replica.
What is the best way to do this?
I found a lot of examples:
http://www.dragishak.com/?p=307
Use special ...
- 1,787
1
vote
0
answers
84
views
How does mongo driver choose the node to connect?
In documentation MongoClient it is said mongo driver chooses the closest (ping) mongo node to work with. But write requests can only be processed by master node. Could you please explain on example ...
- 2,498
2
votes
1
answer
812
views
Facing Communication link failure to slave occasionally in Mysql master-slave replication configured with c3p0 connection pooling
I have a Master-Slave replication configured using Mysql replication driver along with c3p0 connection pooling. Facing the following connection failure issue in slave sometimes. In current setup ...
