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…
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…
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)…
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…
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…
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…
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.
1 2 3 4 5 6
7