0
votes
1answer
28 views

MySQL Replication fix after server shutdown/start

Server1 is Master Server2 is Slave Both are in our AWS testing env and we stop them once done with our work. When start again, Master rotates/creates new binary log file but slave keep looking for ...
0
votes
1answer
35 views

Mysql Db replication

I have the following setup: 3 servers, B1, B2, B3. A database from B1 is being replicated to B2. B1 is master and B2 is slave. Now, I want an another database from B2 to be replicated to B3. I need ...
1
vote
1answer
295 views

Large lag on mysql replication (Relay_Log_Pos and Exec_Master_Log_Pos does not increase)

Today my two slave's (one mysql 5.1 and second MariaDB 5.5, master is mysql 5.1) started lagging. Similar situation are quite often with lags rises to even 10000 seconds, because slaves have worse ...
0
votes
1answer
66 views

How to arrange a replication in mysql?

Here is my problem. I have a busy Drupal site struggling under high load. After applying all caches I see that, no surprisingly, database is the bottleneck. I have two servers to handle the site: A ...
1
vote
1answer
354 views

postgreSQL replication and failover with repmgr on Ubuntu

I'm new to Linux and have been tasked with setting up a redundant Linux DB server with PostgreSQL. preferably the fail-over needs to be automatic, but a manual process will be fine for now. What I ...
1
vote
1answer
148 views

SQL Server 2008 Snapshot Replication Trigger Start

I have setup a production server and a staging server. Whenever we are at the point in our release cycle where we want to begin testing on staging I want to copy the production DB over to our staging ...
1
vote
2answers
470 views

Possible to regularly export MS-SQL tables to another DB format on Linux without complete dumps?

We have a production server running SQL-Server, which holds our backend data, e.g., customer information, sales invoices etc. The nature of this data is that "old" data can change, e.g., a customer ...
2
votes
1answer
120 views

raid with replication

We are planning to buy two servers which will going to host an SQL database(PostgreSQL). The second server will work as a live replication of the first database server (hot standby). The question I'm ...
1
vote
3answers
39 views

database replication for new user signup

I have a database that stores the users of my application. When a new user signs up, a record is inserted into the database for that user. I have a replicated version (slave) of this database (using ...
0
votes
1answer
60 views

how mysql replication

I'm doing mysql replication (master - slave). There are a few questions Can I assign replication for some databases and not all databases that are on master (for example, ON master server there are ...
4
votes
2answers
4k views

datetime format changed between mysql 5.0 and 5.1?

I've upgraded a mysql slave from mysql 5.0 to mysql 5.1. during the catch up, the replication failed on a query with incorrect datetime value: 110919 13:56:18 [ERROR] Slave SQL: Error 'Incorrect ...
0
votes
1answer
111 views

Syncing with Master DB after slave record is modified

I've set up a MySQL replication scheme between 2 remote databases. I've realized that if I change data on the slave DB, the changed data does not get updated again. For example, I have a table User ...
0
votes
1answer
38 views

Replicating Two Server

I was given the task of replacing two servers not just RAID but everything. Also in the event of a failure of one the ip address would automatically handle request for the active one. Can someone ...
0
votes
1answer
159 views

What IP does my web server connect to after I set up replica set in Mongo?

Install Mongo on A. Start the server: $ mongod --rest --replSet myset rs.initiate() on A. Install Mongo on B. Start the server: $ mongod --rest --replSet myset Connect to A and add B to the set: ...
4
votes
2answers
6k views

MySQL simple replication problem: 'show master status' produces 'Empty set'?

I've been setting up MySQL master replication (on Debian 6.0.1) following these instructions faithfully: http://www.neocodesoftware.com/replication/ I've got as far as: mysql > show master ...
0
votes
2answers
291 views

Any problems with my mysql replication setup command?

I wrote myself a small script that produces the following shell command. echo "CHANGE MASTER TO MASTER_USER='slave_user';" | mysql -uroot -pXXX --host=SLAVE && echo "CHANGE MASTER TO ...
0
votes
1answer
159 views

Selective replication in sql server

I wanted to replicate my database across 2 servers both using sql server 2005. The problem is that the main server have both 'User' and 'Admin' data in a table. At the other end , I want to replicate ...
1
vote
1answer
2k views

Which binlog format to use for MySQL Replication?

Just about to start using MySQL replication and I'm wondering what kind of binlog format is the best to use? There's Row, Statement and Mixed. I'm going to be using 5.1.49. Row is winning at the ...
0
votes
1answer
33 views

prevent unique constraint violations in clustered architecture

im working with four app servers and two database instances (3DNS and BigIP determine what app server a user is directed to based on usage etc). Two app servers per database node. The database ...
1
vote
3answers
1k views

Scalable database architecture for heavy read and heavy write?

I am developing a web application which will require scaling to multiple servers. I'll need multiple web servers running my application code, and there will be heavy reads and heavy writes to the ...
2
votes
4answers
826 views

Mysql replications: slave is not readonly

After setting up mysql replications with master/slave db scheme, I noticed that the slave db server is not read-only. Of cause, after that I configured it manually in /etc/my.cnf file. I just can't ...
4
votes
2answers
510 views

MySQL replication: Getting the master in sync with the slave again

I have two computers on the same network, in a master-slave replication setup. Simply to test failover, I inserted some data straight into the slave database. So now the slave database contains more ...
0
votes
2answers
285 views

Database cluster… without Master/Slave?

I'm wondering if it is possible to have a set of SQLdb servers to which data is written and have them replicate, avoiding conflicting information. I imagine that a Master/Slave structure would be ...
0
votes
2answers
313 views

Ideas for scaling out database architecture

We're looking to scale out our existing database architecture and need some advice on which way to go. We currently have 2 web servers behind a load balancer that both read & write to a single ...
2
votes
2answers
376 views

Replicate MySQL database with “non-permanent” write

I'm working with a production MySQL database and I would like to: Create a read-only slave copy of the database that gets updates from the master. The master is the only one that can be written ...
2
votes
0answers
91 views

How to do Merge Replication?

I tried to do synchronization of database between servers to synchronize a database using merge replication. Simply I've added publication in server A and subscription in Server B by declaring ...
0
votes
1answer
97 views

Why is it that during my replication (master-slave), it keeps inserting data, then deleting data, then inserting data?

I followed this tutorial for master-slave replication: http://www.howtoforge.com/mysql%5Fmaster%5Fmaster%5Freplication Basically, this is what I did. Uninstalled mysql on both servers. Installed ...
0
votes
4answers
88 views

What is the best way to set up a master-master rig?

Because everyone says master-master is not recommended. But if you think about it...1 write server is hardly enough! So, how would you set it up (high-level, not tutorial-level) so that it works out ...
1
vote
5answers
464 views

Can master-master replications be stable?

Why does everyone tell me that master-master always ends in tears and should be avoided?
0
votes
1answer
779 views

MySQL auto-increment problem on master-master replication , and the logic to solve it

I had a auto-increment duplication issue for master-master replication. Then, I set: SET GLOBAL SQL_SLAVE_SKIP_COUNTER = 99999; This skips 9999 queries. Then I did: SHOW SLAVE STATUS\G ...
0
votes
2answers
242 views

How do I show grants for a username on Mysql?

More specifically, how do I show what replication grants is attached to a username?
1
vote
6answers
1k views

MySQL replication out of sync

I have a master-master replication system. However, due to an auto-increment issue, I got an error in replication...and it stopped replicating. Someone told me to do: stop slave; SET GLOBAL ...
0
votes
3answers
236 views

My system administrator set up 2 databases that sync. Master-Master. However, these two databases are not syncing

DB1 and DB2. I made changes to DB1, and it does not seem to be on DB2. When I do "SHOW SLAVE STATUS\G" on DB2, there seems to be an error: mysql> show slave status\G *************************** ...
0
votes
1answer
167 views

Sync mysql databases to master server

Hi I need to do a database synchronization from each store to central store. Each store employee should be able to do this sync once or twice a day, due ISPs unavailability here. Owner would check at ...
0
votes
2answers
846 views

Setting up MySQL database replication

I have read a couple of tutorials on setting up database replication on MySQL, but I have not got it working yet. I think the problem is that my machine can't connect to another. For example, I can't ...
2
votes
4answers
2k views

How to set up replication on SQL Server 2008

Say you have a production database and a staging database that you want to have replicate on a semi-hourly basis across the internet. The general intent is to have a stand-by backup, but also to have ...
3
votes
5answers
2k views

Using MySQL replication to enable a read-only copy of a database in a DMZ

I need to set up a MySQL database instance in a DMZ that is a read-only copy of the live master inside a secure network. MySQL replication seems ideal for this, except that it works by the slave ...
1
vote
5answers
616 views

Low Latency or High Bandwidth, which is more important for database replication?

When considering the placement of an offsite slave database, which is more important in a network connection for maintaining up-to-date replication: low latency or high bandwidth?
2
votes
6answers
4k views

How best to script selected tables and data on SQL Server 2008?

The SQL Server Management Studio has the ability generate scripts. The problem is that it breaks on identity columns. I can't find a link to this bug at the moment but Microsoft basically declared it ...