Questions tagged [database-replication]
104 questions
0
votes
0 answers
PostgreSQL Subscribers and Publishers (Multi-Master Scenario)
I'm currently trying to develop a solution that would be trying to focus on Multi-Master Databases
So here is how it's supposed to operate
I want so that whenever an Agent makes a change to a database, changes are stored in the agent DB, and then…

RedNet
- 101
0
votes
0 answers
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 it today.)
I have multiple servers that will…

Chris Nelson
- 119
- 4
0
votes
0 answers
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 solution.
Some information;
Multiple servers (6)…

emir ko
- 1
0
votes
1 answer
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 slaves but less servers
I only use One Master for…

yodann
- 101
- 1
0
votes
1 answer
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).
I want to add a host which I fully manage on my own to said…
0
votes
1 answer
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 from the user, I will sanitize the…

thisismoooo
- 1
- 1
0
votes
1 answer
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: Error 'Character set '#255' is not a compiled…

Aninemity
- 73
- 2
- 9
0
votes
1 answer
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 = 14
restore script (slave)
service mysql…

clarkk
- 2,035
- 8
- 24
- 36
0
votes
2 answers
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 each ranging from bin.001260 to bin.001357.
On my…

WallyKaye
- 13
- 5
0
votes
0 answers
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 connecting back to them at my house was the…

leeand00
- 4,869
- 15
- 69
- 110
0
votes
3 answers
MSSQL Database Replication to MySQL
I have MSSQL 2005 server and I have MySQL database in intranet.
I want to replicate some tables from MSSQL database to MySQL database.
I have created ODBC licnked server and have successfully created transactional publication and I have manually…

THEn
- 137
- 2
- 8
-1
votes
1 answer
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/vendor_perl /usr/lib/perl5 /usr/share/perl5 .) at (eval 9)…
-1
votes
2 answers
SQL 2012 Server Database Transaction Replication performance issue
We have configured SQL 2012 Server Database Transaction Replication for our client's .NET Web application to distribute SQL transaction and reporting on different SQL servers.
We had implemented transaction replication on to SQL-Node1 is working as…
-2
votes
1 answer
how to initiate and maintain mongo shard replica set from mongos server?
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.

siva nagi reddy
- 3
- 2