Replication enables data from one MySQL database server (the master) to be replicated to one or more MySQL database servers (the slaves).

learn more… | top users | synonyms

3
votes
2answers
123 views

MySQL Replication 'Catchup' UPDATES keep newer record

I've got two MySQL clusters that have Master-Master replication setup between them. Most tables are log based, with only inserts and selects, so they don't have any problems with the replication. ...
2
votes
2answers
221 views

Mysql cluster Vs basic Mysql db setup(not cluster)

Why mysql cluster requires more ram as compared to basic mysql db setup (no cluster)? What is the ideal ram requirement for a mysql cluster with 2 mysql servers on 2 different hosts ?
1
vote
2answers
412 views

What is the best way to change the replication scheme of 2 currently replicated slaves?

I have MySQL replication set up in production as follows: DB1 -> DB2 DB1 -> BAK Where DB2 and BAK are slaves to DB1. All 3 servers are in sync (0 seconds behind the master) and have 30+ GB of data....
1
vote
2answers
515 views

A few tables are still out of sync after running mk-table-sync

I have 1 master and 2 slaves. I am using MySQL 5.1.42 on all servers. I am attempting to use mk-table-checksum to verify that their data is in sync, but I am getting unexpected results on one of ...
0
votes
2answers
111 views

How to open the MySQL port only to Amazon RDS for replication?

I have a MySQL database on a dedicated server, that I want to replicate to Amazon RDS to always have an up-to-date backup. For this, Amazon RDS needs to be able to connect to my master MySQL server. ...
0
votes
2answers
83 views

mysql replication setup but not working

I'm experiencing some trouble setting up mysql replication between a master & a slave.. I did the setup successfully, but data doesn't update. Master : show master status; [File]: mysql-bin....
0
votes
2answers
447 views

Keeping two servers in sync - secondary server only to be booted for the backup, or in outage

I've just started a new Software Development job but I've basically been given loads of sysadmin stuff to do because the development team consists of only 2 people + the CTO. I've got pretty much zero ...
0
votes
2answers
139 views

Mysql Replication restart

I have a slave db (db1) that I moved into the master position after my master db (db2) died. I brought up a new slave db (db3) from a day old snapshot of db1, my problem is trying to figure out which ...
0
votes
2answers
927 views

How do I sync a subset of tables between two databases on the same mysql database server

would like to be able to sync a subset of tables between two mysql databases that are running on the same server. One of the databases acts as the master where inserts, updates and deletes can be made....
0
votes
1answer
36 views

mysql replicate-* data transfer from master

I have been playing with MySQL replication for a new project of mine. I am using row based replication. I have a particular confusion with replicate_do_db which is to be written in the my.cnf of the ...
0
votes
1answer
165 views

GTID have been turned off But I have error in replication

I just upgrade from mariadb5 to mariadb10. Then I have error on my slave replication Unable to load replication GTID slave state from mysql.gtid_slave_pos: Table 'mysql.gtid_slave_pos' doesn't ...
0
votes
1answer
34 views

How to avoid MySQL replication corruption while executing flush-logs command

I have three servers running MySQL, let's say A, B and C. Server A is the master, and server B is the slave. I want to do mysql replication between server A and B, at the same time, I also want to use ...
0
votes
1answer
84 views

mysql GTID replication

i try to use GTID and backdump mysql -u root -h xx.xxx.xxx.xx -p < 2015-10-30_all_database.sql Enter password: ERROR 1840 (HY000) at line 24: @@GLOBAL.GTID_PURGED can only be set when @@GLOBAL....
0
votes
1answer
146 views

MySQL proxy or Master-Master replication?

I currently have a MySQL database hosted on a remote server (Server A). This database have to stay there because this remote server is very secure. Our online website use this database to display ...
0
votes
1answer
222 views

How does read/write splitting work with MySQL replication?

I know how to setup a master->slave replication but I am a bit confused on how I would do read/write splitting between the two MySQL servers with a PHP application. When I have MySQL replication ...
0
votes
1answer
1k views

MySQL table only replication (Master->Slave)

I've set up two servers (one master and one slave db). I want to synchronize one single table of a whole database live (or with a delay of up to 5 minutes) in only one direction. I wanted to try the ...
0
votes
1answer
212 views

different servers different databases replication mysql

I am not sure if this is possible or not but I have 3 servers. Server A, B and C Server A has database A_dataBase, B_database Server B has database A_dataBase, B_database and C_database Server C has ...
0
votes
1answer
162 views

MySQL replication ignoring BINLOG statements for certain table

I'm trying to make MySQL Replication work, but my slave is constantly stopping because of constraint fails. This errors occurs because the replication of one particular table is not working. If I ...
0
votes
1answer
34 views

Force a connect to mysql

My Mysql server instance has crashed (I assume its been 10 hours and its not running) - I have tried show full processlist but the new connection can't connect. I've tried using mysqladmin and that ...
0
votes
1answer
262 views

Can I do zero downtime MySQL replication if I have archive tables present?

I've read the question and answers at How to setup MySQL replication with minimal downtime. It looks like I can get a slave DB into sync without down time if I am using only Innodb tables. My ...
0
votes
1answer
104 views

MySQL replication slave got 2147483647 (INT32_MAX) in a column for time stamp

I have set up two replication slaves, one on CentOS(x86_64 5.1.37), the other on Ubuntu LTS(x86_64 mysql 5.5.38). Both of them seem to replicate most of the Master db (CentOS i686, mysql 5.5.37) ...
0
votes
1answer
449 views

MySQL Master-Master Replication Issue

I have two databases that sync data through Master-Master replication. The setup was created using the following guide: digitalocean.com/community/tutorials/how-to-set-up-mysql-master-master-...
0
votes
1answer
111 views

MySQL Cluster with no access to Data Nodes

I'd like to set up a MySQL Cluster for HA, but the client of the data cannot yet use ClusterJ. I would like create 2 SQL Nodes and access only them from the client. i.e. No access to the NDB Data ...
0
votes
1answer
133 views

What is wrong with this iptable for Mysql Replication

I'm not quite used to IPTables and I'm trying to run an iptables script to allow only ssh connection from all and connection to mysql server only from specified IPs. I made a bash script for this, ...
0
votes
1answer
363 views

MySQL replication & logrotate

I'm using MySQL Master-Slave replication for backup purposes (for a few days). Today after changing to expire_logs_days = 3 on master and slave I got this message (from slave): /etc/cron.daily/...
0
votes
1answer
34 views

Single slave - multiple master MySQL replication

I need to replicate different MySQL databases from multiple servers into a single slave server. How can this be done? is there a way to define multiple master hosts?
0
votes
1answer
738 views

MySQL Slave Not Replicating

I had a deleted some data on the master mysql. Looking at the slave status, it shows this: mysql> show slave status \G; *************************** 1. row *************************** ...
0
votes
1answer
206 views

Replicate from slaves to master and viceversa

I've a great dilema here and didn't know how to solve it. I need to replicate a few tables from MySQL DB (slaves) to MySQL DB (master). Take as an example this: MySQL DB (master) table1 table2 ...
0
votes
1answer
291 views

mysqlbinlog does not continue to last log

I am using the following command to start reading mysqlbinlog. mysqlbinlog -t -v -v --base64-output=DECODE-ROWS -h my_host -ppasswd -R mysql-bin.000960 -j 1052323996 I would expect the output to ...
0
votes
1answer
476 views

Mysql Replication— restricting drop database statements

we have a master-slave mysql replication setup. The master has multiple databases and they get created and dropped, fairly often. I would like to restrict the slave to not drop the databases. I ...
0
votes
1answer
671 views

MySQL Master-Master replication using MMM on Linode

Linode allows you have multiple IP's assigned to your node but I'm trying to setup MySQL Master-Master Replication with MMM following the guide on http://mysql-mmm.org/mmm2:guide. One part I don't ...
0
votes
1answer
490 views

Promote MySQL master-slave to master-master replication

I'll be doing a upgrade of a large MySQL 5.0 database to Percona 5.1 and I'm attempting to keep the actual downtime as short as possible during the upgrade, so the regular mysqldump + mysql import ...
-1
votes
1answer
138 views

Mysql MariaDB replication broken

I have a primary DB and two replicates. replicate1 became corrupted when the linux server was rebooted without stopping mysqld. I want to load replicate1 with a dump I've taken from replicate2 with ...