1
vote
2answers
64 views

MySQL Replication threeway

We have MySQL Multi-Master replication setup between two servers ( A & B ). It has been working for a few years now and life is good. The management tool in our office connects directly to ...
1
vote
2answers
229 views

mysql replication 1x master, 1x slave

I have just setup one master and one slave server, but its not working.. On my website I connect to the slave server and I insert some rows, but they do not appear on the master and vice versa.. What ...
1
vote
1answer
82 views

SQL Server 2005 to Mysql Replciation DATA duplication

I set up Replication between SQL Server 2005 and Mysql 5 using following articles : http://ratecontrol.blogspot.com/2010/12/one-way-transactional-replication-from.html and error setting up ...
2
votes
1answer
433 views

error setting up replication from mssql to mysql

I'm trying to setup replication from SQL Server 2005 to MySql 5.1.53. I am able to add the publication without any problem. However, when I go to add the subscription I get this error: OLE DB or ...
1
vote
1answer
78 views

MySQL Database Replication and Server Load

I have an online service with around 5000 MySQL databases. Now, I am interested in building a development area of the exactly same environment in my office, therefore, I am about to setup MySQL ...
0
votes
1answer
114 views

What is the best of two approaches to achieve DB Replication?

we have two approaches to achieve DB Replication: Master-Master replication. Master, 1 Primary Slave, 1 Secondary slave. I am planning to analyze these two approaches and prepare a comparison ...
0
votes
3answers
1k views

synchronize 2 mysql servers (all databases + users)

We want to sync 2 mysql servers with eachother (products & qa system). We would like to sync all databases, data and users of the production machine to a secondary mysql machine. What would be ...
2
votes
2answers
712 views

Replicate Oracle to MySQL

I am developing a web apps, this web application will be using MySQL. Now I need to replicate my client's Oracle database into MySQL, only a few tables will be involved.. a table can be up to 2-3 ...