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

1
vote
3answers
360 views

MySQL HA Solutions

I am evaluating the options to build MySQL HA and found the below solutions Percona XtraDB Cluster, Tungsten Replicator, and MySQL Cluster. Could you please help me to choose the best one with ...
0
votes
1answer
1k views

install MySQL Server 5.0 on CentOS 6.3

How can I install MySQL version 5.0.x to CentOS 6.3. The MySQL in CentOS 6.3 is version 5.1. The MySQL 5.0.x is required to run a slave database of a master database server running MySQL 5.0.x
1
vote
2answers
420 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
1answer
65 views

Find mysql replications diffs patterns

I'm using pt-table-checksum and pt-table-sync to check for differences in my replicas. when I use pt-table-sync with the -print option, I can only see the master values. How can I show the ...
0
votes
1answer
157 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 ...
3
votes
2answers
117 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
472 views

MySQL binary logging

My server is telling my that binary logging is disabled. When I do a mysqladmin variables, I see this: log_bin | OFF. This is my configuration file: [mysqld] ...
1
vote
1answer
1k views

MySQL replication recovery

I can't sync the slave server after master server crashed. Could you please advise if the recovery is possible (without data/transaction lost) or do I have to create a new slave server? Please note ...
0
votes
2answers
3k views

How to reset mysql's replication settings completely, without reinstalling it?

I set up mysql replication by adding references to binlogs, relay logs etc in my.cnf restarted mysql, it worked. I wanted to change it so I deleted all binlog related files including log-bin.index, ...
6
votes
1answer
4k views

MySQL: Pacemaker cannot start the failed master as a new slave?

pacemaker-1.0.12-1 corosync-1.2.7-1.1 I'm going to setup failover for MySQL replication (1 master and 1 slave) follow this guide: ...
4
votes
1answer
2k views

max_binlog_size & log-bin size

I have a problem with full disk -rw-rw---- 1 mysql mysql 1073741982 2012-07-03 18:14 mysql-bin.000034 -rw-rw---- 1 mysql mysql 1073741890 2012-07-04 14:39 mysql-bin.000035 -rw-rw---- 1 mysql mysql ...
1
vote
2answers
245 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 ...
0
votes
1answer
39 views

Mysql varchar issue on replication [closed]

This issue is showing it a duplicate key, but when I verify I could understand that one column having varchar(5) and the insert is having more than 5 character, normally it will get truncated and will ...
0
votes
1answer
419 views

MySQL slave server from dumps

I've created a slave server from live machine which is acting as a master now. I use the following procedure to create it: mysqldump --opt -Q -B --master-data=2 --all-databases > dump.sql then ...
0
votes
1answer
80 views

MySQL SSL replication

I'm currently testing MySQL replication over SSL. I have two mysql-slave pairs. I would like to configure second slave server for each pair in different data centre: Do I have to generate ...
0
votes
1answer
681 views

RDS slave (read replica) not replication

It appears overnight our Master RDS mysql server went offline for 3-4 minutes. When it came back online the replication was broken. On the slave, issuing SHOW SLAVE STATUS\G; "Got fatal error 1236 ...
1
vote
2answers
2k views

Redundant FreeRADIUS + MySQL

I’m working on some web service having it’s AAA implemented by FreeRADIUS + MySQL on Debian. The problem I’m working right now is HA & scalability of RADIUS. If the FreeRADIUS machine or MySQL ...
2
votes
1answer
448 views

Mysql replicate-rewrite-db not working

Been "slaving" on this issue all day. I have a master/slave setup that works, but when I try to replicate to a different database name on the slave it fails. This is what my.cnf looks like: ...
2
votes
3answers
208 views

MySQL replication automation?

I was wondering if there are any MySQL replication automators or managers that can take over the tasks of deploying MySQL slaves from a master. I come from an old school server management background, ...
0
votes
1answer
215 views

mysql relay log corrupted, How to recover?

I am running with one master and two slaves in a chain. ie Master-->Primary Slave-->Secondary Slave. The relay log of primary slave got corrupted. How can I recreate the relay log of ...
2
votes
4answers
420 views

Replicate main MySql db to a development server to play with real data

I have a main architecture with a MySql db, replication and backup, it's working fine. Now I also have a development server where I play with the code and I would like to use the data from the main db ...
3
votes
3answers
687 views

MySQL to PostgreSQL replication

Is there way to replicate in near-realtime MySQL changes to equal PostgreSQL database?
1
vote
0answers
46 views

Mysql Master-ColdMaster

I explain my case: I'm at Amazon AWS and I want to be fault tolerant on a entire region failure. My basic problem is to have the db in sync with 2 regions. My options: Master-Master (high lag) ...
1
vote
1answer
102 views

MySQL master-master replication between database running on 3 different server

I am trying to implement a master-master replication between 3 MySQL Databases running on 3 different servers. I implemented master-master replication for 2 servers, but can't figure out how can I ...
1
vote
2answers
133 views

MySQL replication not working on leap day

Though out of my "core" knowledge I maintain a two-way replicated MySQL database (primary and backup). It's been working fine mostly. All changes are almost instantly replicated between the two ...
0
votes
0answers
60 views

Replicate mysql server with networking disabled

I like having network disabled on mysql, but now I need to replicate one table across two servers. That is, the table will be updated on one server and then I need a copy of that table to be ...
1
vote
2answers
357 views

[MySQL]multiple-masters single-slave

Is is possible to have a setup where multiple mysql servers (containing different databases) are replicated in a single mysql slave server ? If yes, how to do it ?
1
vote
1answer
78 views

Backups from MySQL slave server — Good idea or bad?

I'm have one MySQL master and two MySQL slaves set up to replicate. I'm running my database backup process, consisting of an Xtrabakup (via the perl wrapper Innobackupex) backup and an atomic ...
2
votes
2answers
445 views

What do you think about this Debian Backup strategy? [closed]

I am not really a sys admin, I am mainly a developer with some unix knowledge, and because we don;t have any competent sysadmin , I have been delegated the task to implement the backup strategy. We ...
0
votes
2answers
190 views

Mysql Replicated database UPDATE not working

I have been trying to start replication in a MySQL database. I followed all the steps from the MySQL manual to setup and configure the replication. ...
1
vote
0answers
239 views

MySQL Replication not working on binlog-do-db

I set up MySQL master-master replication on my 2 Ubuntu VM. Configuration and connection done correctly according to this guide. Here is my problem. I print the master status on master 1 and it ...
1
vote
1answer
179 views

Automatic promotion of slave in MySQL master-slave replication

In a master-slave replication environment, what is required to automatically promote the slave as the master if the master goes down. What are common practice used to change the database reference ...
0
votes
1answer
97 views

Client to use the slave when the master is down in MySQL replication

Is it possible for the client to use the slave when the master is down in mysql replication? I have already set up a simple MySQL replication having a master and a slave. The client connects to the ...
2
votes
3answers
357 views

MySQL Master-Master Replication Lag

I have configured two MySQL servers (MySQL-1, MySQL-2) in master-master replication in the same datacenter using a local backend connection with the following options: ...
3
votes
2answers
12k views

How to sync two MySQL tables (on demand or via cron)

I have seen Cron sync mysql tables . But I cannot use replication. I used to use percona-toolkit and it worked perfectly. I could run the sync command on demand or just run it via cron. It would ...
0
votes
1answer
110 views

Setup MySQL replication - multiple machines?

i read a lot of mysql server repliaction tutorials, but there's no hint, if the slave server is on a second machine or on the same server but just another mysqld process? any advice? thanks in ...
0
votes
1answer
264 views

MySQL is failing to connect

I am building two mysql machines in master-slave config. Master has: mysql> create user 'repl'@'%.%.%.abc.mydomain.com' identified by 'mypassword'; mysql> grant replication slave on *.* to ...
3
votes
1answer
1k views

Recover a crashed MySQL master server from the slave

we are building a simple master/slave MySQL configuration using asynchronous replication, with MySQL enterprise 5.5.17 on both servers and innoDB based tables. In case of a crash of the master server ...
0
votes
1answer
1k views

Where can I find documentation on my.cnf directives?

I'm skimming through how to set up a basic master/slave replication in mysql. http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-fedora/ However ...
1
vote
3answers
246 views

MySQL incremental backups and database replication

We have some servers that runs a tomcat app with a MySQL database. These servers are in different cities and the web app is used locally by our customers. On these servers a crontab job runs twice a ...
3
votes
1answer
1k views

MySQL on VMware for High Availability

Given a choice between the current database-level HA options for MySQL, like Master-Master, Cluster, or Galera, and vSphere HA for the machine running the MySQL master, which would you use or combine ...
0
votes
1answer
146 views

Is there a difference between the mysql native master/slave replication setup versus one that uses percona xtrabackup?

The reason I ask is because these instructions seem to indicate that setting up a slave is different when using xtrabackup.
1
vote
1answer
83 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
48 views

Finding binary log position to start replication

I'm setting up master/slave replication on a non-trivally-sized schema (around 3Gb of data) and I'm trying to work out the best way to go about it. I have a backup script working on the master that ...
1
vote
1answer
45 views

How to check if data are the same between to Mysql servers setup as master-master replication

I have two servers using Mysql Master-Master replication. Actually, only one server receives write orders. One of the databases is out of sync. Several tables don't have the same numbers of records, ...
0
votes
1answer
63 views

MySQL two master databases for two seperate apps

We have two different websites one is hosted in asia datacenter called it asiadata.com and other site is hosted in europe datacenter called it europedata.com. Currently we have only one master ...
5
votes
3answers
14k views

What causes the MySQL error 1062 - duplicate entry when starting slave?

MySQL Master version: 5.5.16-1 MySQL Slave version: 5.5.18-1 The master's snapshot is created by: mysql> FLUSH TABLES WITH READ LOCK; shell> mysqldump --all-databases --master-data > ...
0
votes
1answer
73 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 ...
1
vote
2answers
153 views

Measuring MySQL Replication Delay

How to measure MySQL replication delay between 2 MySQL servers ( 1 Master 1 Slave ) ? Given that two Xeon E5620 grade 1U servers are separate machine in same network segment, using MySQL Community ...
1
vote
1answer
188 views

making slave server as master for another server

I have three servers, Server X, Y, and Z. I have the main mysql DB on X (innodb DB). now I have created Master-Slave from X to Y. everything is working fine here. and now i set Y as a master for Z. ...