1
vote
2answers
67 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
1answer
25 views

re-enabling a table for mysql replication

We were able to setup mysql master-slave replication with the following version on both master/slave: mysqld Ver 5.5.28-29.1-log for Linux on x86_64 (Percona Server (GPL), Release 29.1) One day, ...
1
vote
1answer
163 views

What are the options for any SQL Multi Master Master replication?

I am looking for a proper way to do Multi Master Master replication. I am currently using MySQL but open to switching to Postgres or Oracle if needed. So far the only solution I find is ...
1
vote
0answers
142 views

mysql cluster node lost connection shutdown

I'm testing a mysql cluster with VirtualBox using several virtual machines: Each virtual machine (2 in total) has a mysqld and ndbd node. Plus there's a vm for the ndb_mgmd to manage the cluster. I ...
0
votes
2answers
429 views

MySql server master-master seconds_behind_master jumps

I'm running a 4 servers master-master cluster of MySql. (2 servers version 5.1, and 2 version 5.5) While checking the slave status, i see the seconds_behind_master at 0, and half a second after i see ...
0
votes
0answers
33 views

How to do replication of data on mysql?

i am trying to do mysql replication for my site database. i searched on internet but did not get proper solution for replication. i am looking to do replication on same server.
0
votes
2answers
238 views

Synchronisation between MySQL databases on different hosts

I want to solve a data replication/data sync problem between two MySQL server instances. Both of them have the same database structure (databases, tables, columns, everyting ...) but each of them has ...
1
vote
1answer
494 views

MySQL error 2003 over ssh tunnel when replicating, not when using client

I am trying to set up replication on a MySQL server over an SSH tunnel. I've set up a port forward on the slave from port 7777 at localhost to port 3306 on the master, and I can connect to my ...
2
votes
3answers
97 views

MySQL Replication A->B->C

I was setting the MySQL Replication for master -> slave/master -> slave and Replication for master -> slave its works fine but when i have enable this option in my.cnf log-slave-updates=1 for ...
1
vote
1answer
989 views

MySQL replication - rapidly growing relay bin logs

Morning all, I've got a really strange situation here this morning much like a reportedly fixed MySQL bug. http://bugs.mysql.com/bug.php?id=28421 My relay bin logs are rapidly filling with an ...
0
votes
1answer
56 views

Preparing a server for mysql replication and use it as standalone

I want to host an application on a single server running MySQL server. To get the best performance I plan on using a UNIX socket connection (to avoid TCP overhead). Later, I would like to scale up by ...
0
votes
3answers
122 views

MySQL replicate multiple places

Very trick task to find a good title for this question, but here goes the q: I have a few development machines, where I develop my PHP applications on, and testing via a local webserver. This works ...
5
votes
4answers
491 views

Testing MySQL Database Replication / Synchronization

I'm setting up a MySQL Master database which replicates to a few Slave databases. My question is what are the best practices to monitor and / or test that the slave databases are up-to-date, and that ...
1
vote
2answers
351 views

mysql master slave “table already exists” but table not exists

I have 1 master mysql process, and 2 slave. Today on both slaves i see : Error 'Table 'bgbilling.contract_status_balance_dump' already exists' on query. Default database: 'bgbilling'. Query: ...
1
vote
2answers
231 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 ...
3
votes
3answers
547 views

MySQL to PostgreSQL replication

Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?
0
votes
1answer
68 views

Aggregating data from multiple MySQL servers

I have 10 MySQL servers and each one holds a database that needs to be replicated to a single, centralised MySQL server. The complexity is that each server must replicate its database to the same ...
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 ...
1
vote
1answer
459 views

Running MySql replication between datacenters

I run my website from EC2. Due to AWS outages, I am contemplating replicating my setup on Rackspace and switch over from DNS in case of an outage. I am looking to learn ways to replicate my MySql ...
0
votes
1answer
113 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
3answers
82 views

What is a good tool/method for version controlling a part of a live database?

Sometimes if a database gets corrupted, a replicated database could also replicate that same corruption. What is the best way to replicate/backup a database and prevent something like this from ...
1
vote
3answers
715 views

MySQL / InnoDB replication: how to perform crash recovery?

How do I perform crash recovery in a MySQL/InnoDB Master-Slave asynchronous replication setup? Specifically: If a slave crashes, how do I make it syncs up with the master after I bring it back up? ...
2
votes
1answer
4k views

Failed to connect from slave to master with error “error connecting to master (1045)”

I try to setup replication from slave to the master. CHANGE MASTER TO MASTER_HOST = 'master', MASTER_PORT = 3306, MASTER_USER = 'repl', MASTER_PASSWORD = 'xxx'; And I did grant privileges ...
0
votes
0answers
71 views

MySQL replication for scalability

Consider the following hypothetical scenario: A Web application receives 25% write traffic and 75% read traffic. Given that this application can tolerate reads that slightly stale, an easy way to ...
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
0answers
237 views

Problem while Installing mysql cluster

I downloaded latest mysql cluster file 64 bit (mysql-cluster-gpl-7.1.9-linux-x86_64-glibc23) from mysql site. Ran following command to install mysql server. ...
3
votes
4answers
756 views

master-slave-slave replication: master will become bottleneck for writes

the mysql database has arround 2TB of data. i have a master-slave-slave replication running. the application that uses the database does read (SELECT) queries just on one of the 2 slaves and write ...
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 ...
3
votes
1answer
1k views

One way replication from MSSQL2005 to MYSQL 5.x

I have a mysql database acting as our websever backend. We have our production mssql server that we would like data pushed from, to our mysql server. I have successfully made the mysql server an ...
4
votes
2answers
511 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
3answers
1k views

Two way, multi-site replication in MySQL

We have MySQL 5.1 databases at 5 separate locations that we need to keep as synced as possible. Each office needs to read/write from/to the local server at that office, but I need the DB at each ...
0
votes
3answers
603 views

Rebuilding corrupt slave by copying mysql folder

Rebuilding an existing slave from a master using cold-copying of /var/lib/mysql, would this be the proper process/order? Anything missing? master mysql> SHOW MASTER STATUS\G (take notes) slave ...
5
votes
4answers
905 views

Prevent non-replication writes to MySQL slave?

We have some MySQL database servers set up with row-based replication, for performance. The software writes to the master, and reads from either the master or the slave. Everything's working great, ...
5
votes
1answer
1k views

why use mixed-based replication for mysql

I am in the process of configuring MySQL replication and am intending to use row-based-replication but I was also reading up about mixed-based replication. This is where statement-based is the ...
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 ...
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 ...
6
votes
2answers
2k views

MySQL replication issues after a power outage

After a power outage at our data centre, the slave MySQL databases are struggling. This is in the logs for one of the slaves: 100118 10:05:56 [Note] Slave I/O thread: connected to master ...
1
vote
3answers
291 views

repairing mysql replication

We were running out of the disk space on slave because of relay-bin files, so I stopped the mysql server, deleted the relay-bin files. changed my.cnf file to point the relay log to another ...
0
votes
4answers
980 views

Does mySQL Replication: Master DB Name have to be the same as the Slave DB name?

I have set the Master DB Name as MDB and in the Slave server I set to replicate-do-db=SDB, but this did not work. But when I set it up as the same DB name it works. Is there any solution out there to ...
1
vote
3answers
775 views

Is MySQL Replication on Windows reliable?

We played a bit with postgresql and slony for a master-slave-slave replication setup on windows. But we hit a wall with failover/switchover which is very unreliable. How about MySQL? How reliable is ...
0
votes
2answers
162 views

Lots of tiny mysql-bin.NNNN files

We're using mysql 5.0.somethin with a binary log and replication. However /var/log/mysql is full of lots of tiny 141 byte sized mysql-bin.NNNNN files. using mysqlbinlog I can see that they are empty ...
1
vote
1answer
3k views

Why exactly is --skip-slave-start recommended with MySQL `START SLAVE UNTIL`?

When issuing START SLAVE UNTIL on MySQL , I'm getting the following: Warning: It is recommended to use --skip-slave-start when doing step-by-step replication with START SLAVE UNTIL; otherwise, you ...
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 ...