The tag has no wiki summary.

learn more… | top users | synonyms

0
votes
0answers
8 views

Why would a MySQL 5.6 slave's AUTO_INCREMENT value be different from the 5.1 master's?

I have a MySQL 5.6.21 slave that is replicating from a MySQL 5.1.73 master, and I noticed that for two of the tables, the 5.6.21 has slightly ahead AUTO_INCREMENT values than the 5.1.73. I have ...
0
votes
1answer
27 views

I noticed that my MySQL slave's DB size is smaller than the Master's DB

I have a very simple setup of a master MySQL DB with one slave MySQL DB replicating from it. Initially, when setting up the slave, I used mysqldump to get an initial DB dump from the master like ...
0
votes
0answers
33 views

How to Synchronize the centralized SQL Server database with a local desktop SQL Server database, mobile device database(SQLITE) in bidirectional way? [closed]

There are number of devices i.e mobile, tablets and computer, laptops with same application. and one centralize database on the cloud. But local and devices database have the data with identity ...
0
votes
1answer
36 views

How to implement Master Slave Replication using mysql [closed]

Before moving on with question i would like to first tell you about my web project deployment architecture. Basically this website show details and values of various device connected on remote pcs. ...
0
votes
2answers
36 views

SQL Server 2005 to 2012 Replication, cannot access replicated data

I have created publication (snapshot, small table with 10 rows) on MS SQL Server 2005. Then, I created push subscription on MS SQL Server 2012. When I try to select data form table, process takes ...
1
vote
0answers
19 views

How can I correct MySQL replication while using federated tables?

This is an overview of what I have going I have 2 server A (10.0.4.22) AND B (10.0.4.29) A is a replication of B and B is a replication of A (yes it is a ring replication) ON A I have 2 table uat and ...
3
votes
1answer
56 views

SQL Server Replication w/o network connection

Is there a way to use SQL Server Replication without a network connection? My would-be publisher is an SQL Server 2005. It is on the "outside" as it is connected to my company's primary LAN, which is ...
1
vote
1answer
22 views

Mysql Server version: 5.0.77-log Source distribution

I have a master(M)-slave(S) replication on MySQL. During a failover test, the master was brought down and the slave was made the master by doing STOP SLAVE; RESET MASTER;. Since there are only 2 ...
0
votes
0answers
24 views

replication error Error Duplicate entry… for unique key

I have two database that one of them is replicated of another one,my tables have unique key on some column ( NOT primary key ),so if in replication process an Error Duplicate entry..... occur,these ...
1
vote
1answer
86 views

PostgreSQL Slave has more files in pg_xlog than /wal_archive

Background: for various reasons I am switching PostgreSQL Slave from a Streaming replication to a warm standby replication. The streaming replication was setup using this guide: ...
0
votes
0answers
10 views

Distribute data from a temporal database

I'd like to know whether there are some best practices for distributing data contained in a temporal data base. My application will make some changes to a master data, which are then stored in a ...
0
votes
1answer
38 views

MySQL replication issue when master gets restarted

I have the following environment: NodeA and NodeB in NDB cluster. NodeC InnoDB outside cluster. NodeB is replication master and NodeC is slave. I have set up replication and it works fine. The ...
0
votes
2answers
39 views

Mysql replication with c

I have huge database on MySql and It's become more and more huge. So, Now I am facing performance issues with my database. Some of tables has millions of records in it. like my login detail table ...
0
votes
0answers
29 views

Mysql 5.5+ replication heartbeat feature

I am writing scripts to monitor replication, and while analyzing effect of MASTER_HEARTBEAT_PERIOD keeping in mind about 3 TCP parameters viz : tcp_keepalive_time, tcp_keepalive_intvl, ...
0
votes
1answer
210 views

Move Oracle database to new server

I have a Oracle 11g R1 Standard Edition database on production server working on Windows 2008 R2 SE. Unfortunately server it not working properly (os/hardware failure) and I need to move it to ...
3
votes
1answer
132 views

Replicating 3000+ SQL Server databases

I'm currently investigating the different options there are setting up a DR site for our main data centre. In an ideal world, we would have fewer, larger databases, however due to architectural ...
1
vote
0answers
200 views

Best design of mongo replica set for DB read/write speed

I'm building a Node app that uses MongoDB. Whilst it would probably be fine to have node and mongo sitting on the same VPS, I want to ensure that the MongoDB is backed up and maintain high ...
1
vote
1answer
253 views

How to Configure PostgreSQL Hotstandby Automatic Failover

So I have configured two postgeSQL servers to have hotstand by streaming, now my question is, how can I configure it so that when the master server goes down, the slave server will become the new ...
0
votes
0answers
135 views

SQL Server 2012 Transactional Replication Issue — Table Data not updating at subscriber

In my projects we configured Transactional Replication for my Database - one publisher, one distributor and two subscribers For 2nd subscriber every table data is updating properly But for 1st ...
0
votes
0answers
145 views

mysqldump hung indefinitely - locked tables - replication

I'm new to database programming. I had never written a simple SQL query before but recently I was asked to perform MySql DB replication for our redundant servers. It is a Linux server running as ...
0
votes
0answers
161 views

SQL Server Replication do not replicate DELETE statement

We have two servers A and B. Both of them have SQL Server 2005 on them. A is for data collection, just a "lightweight server". B is for archiving, data manipulation etc. From A to B we have ...
1
vote
0answers
73 views

MySQL SSL Master-Slave replication not syncing

I have originally posted this thread on stackoverflow and after a comment I moved it here. The original post can be found here. I have setup a typical Master-Slave replication scheme for my MySQL ...
6
votes
1answer
669 views

Migrate heroku database to Amazon RDS with minimum downtime

I have a heroku postgres database and want to migrate it to Amazon RDS to save cost. What's a way to do so with minimum downtime? Usually this involves replicating database in real time and then ...
0
votes
1answer
470 views

MySQl master - master replication not working [closed]

I'm trying to setup a master - master setup and I see both masters connect to each other in workbench: server 1: -- Thread Id: 112 -- User: slave -- Host: 207.244.73.38:55164 -- DB: None -- ...
0
votes
0answers
25 views

Alternative for Replication plan

I have a Windows host and some databases on it, but I don't have permission to create Replication Publications and Subscriptions for my databases. I want use replication to sync this database with ...
0
votes
1answer
71 views

Identity Column Behaviour After Replication

Say we have two Servers: Server A and Server B. Data is being replicated (vanilla Transactional Replication) from A to B. For one of the Tables, we have data as follows: Server A - Server B ...