Server Fault Stack Exchange
Server Fault Stack Exchange

Questions tagged [database-replication]

104 questions
0
votes
1 answer

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 can read the master log position as well. I have…
Anand Shrestha
  • 41
  • 5
  • 12
0
votes
3 answers

My previous team member "replicated" a database on a server onto another server. But now it's not in sync anymore

Database 1 is a regular database server. He replicated it to Database 2...a direct clone. Master-Master. They are in "sync" all the time. They each have 40 million rows. Today, Database 2 is "broken" and seems to return different results than…
Alex
  • 8,471
  • 26
  • 75
  • 99
0
votes
0 answers

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 So I used 4x4GB EBS in a RAID 10 with the…
Cyril Duchon-Doris
  • 242
  • 3
  • 15
0
votes
1 answer

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 through the same way, deletes a register, it is…
user362986
  • 11
  • 2
0
votes
1 answer

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 amounts of measurements (time-series) from many…
vgru
  • 1,287
  • 2
  • 17
  • 25
0
votes
1 answer

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 replication done on s3 so that issue is solved. I…
Karl
  • 141
  • 1
  • 6
0
votes
0 answers

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 which is only reading information from the…
brainHax
  • 161
  • 1
  • 2
  • 7
0
votes
1 answer

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 it gets started. As I start 2nd slave, it does…
deepankardixit90
  • 153
  • 2
  • 7
0
votes
1 answer

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. I started mongo by using mongod --port 27017…
Dor
  • 43
  • 5
0
votes
1 answer

PostgreSQL 9.1 on CentOS 6.5 - recovery.conf causing process exit with error code

I did setup streaming replication on the Ubuntu 12.04 LTS with rsyncing of the WAL files in case of failure. Now I was trying to do the same on the CentOS 6.5. To do this I've added official RPM from postgresql.org and installed postgresql 9.1 using…
mickula
  • 342
  • 1
  • 2
  • 10
0
votes
1 answer

Postgresql replication lag EU/US

I've a Postgres 9.2.1 server master (geolocalized in EU) and 2 slave replica (one in EU and one in US). The EU slave is used also for read queries, the US only for failover. Is it possible to have a replication lag > in EU than the US replica due to…
ilmerovingio
  • 3
  • 2
0
votes
1 answer

Error in trying to delete a local publication for DB replication

I logged in in db ad sa (super admin). I want to remove a publication made using management studio wizard (right click on Replication/Local Publications/ New publication) After trying to delete I have error 15517. I feel that th subscription i made…
user193655
  • 253
  • 1
  • 5
  • 18
0
votes
1 answer

Database replication with old data

I am using MySQL to accomplish Database replication. The replication process is works very well. What my problem is, the old record is not copied from the master database. Is there is any way to keep the old data in slave database without using…
Bathakarai
  • 121
  • 3
0
votes
1 answer

Native Postgresql 9.2 Streaming Replication

I'm trying to build up native postgresql 9.2 streaming replication in the Amazon cloud. According to documentation, I've set up everything correctly - but at the slave I get these logs: 2013-02-04 13:18:01.315 GMT LOG: streaming replication…
Hoelli
  • 43
  • 2
  • 8
0
votes
1 answer

MySQL and MariaDB replication

Did anyone configure the replication from mysql to mariadb if yes can let me know how he did it thx in advance. My problem occurred after getting replication to start and the error is saying Error 'Cannot load from mysql.proc. The table is…
nonus25
  • 261
  • 1
  • 4
  • 9
1 2 3 4
5
6 7