FAQ

MySQL > replication

Search Discussions

649 discussions - 2,476 posts

  • I am working on a tool like "Hadoop Applier for mySQL" where my tool will replicate rows to an hdfs file which will be queried using hive. I am able to pull the insert values from the binlog of mySQL ...
    Muthu PandiMuthu Pandi
    Sep 9, 2014 at 4:29 am
    Sep 9, 2014 at 2:18 pm
  • Hi all. We have a master-slave setup, and currently both are using the default STATEMENT binlog_format. However, we wish to switch to ROW binlog_format. Right now, the replication is on (using ...
    Ajay GargAjay Garg
    Sep 4, 2014 at 7:55 am
    Sep 4, 2014 at 7:55 am
  • Hi List! Im running a two server replication setup with mysql 5.6 with parallel replication (256 threads) And our setup is now running a unusable slow replication, and seem to only be using one ...
    Peter L. Hansen - Tiger Media A/SPeter L. Hansen - Tiger Media A/S
    Sep 4, 2014 at 7:26 am
    Sep 10, 2014 at 1:04 pm
  • Dear all i've got a problem with a sync between master and slave: I've got a master in production with 120 GB of mysql data (~300 databases), i'm using innodb_file_per_table = 1 . I want to start a ...
    Nik600Nik600
    May 10, 2014 at 10:41 am
    May 15, 2014 at 7:15 am
  • Hi, I'm building a mysql replication solution to one of our clients, and I would like to minimize the downtime during the setup We've dealt with replication before, but in this case I would like to ...
    Balogh PéterBalogh Péter
    Feb 17, 2014 at 5:39 pm
    Feb 19, 2014 at 4:03 pm
  • Hi : MYSQL when doing data synchronization, the occasional lost events .Excuse me what reason be? thanks!
    邢立明邢立明
    Jan 8, 2014 at 2:49 am
    Jan 8, 2014 at 3:12 am
  • hi : happy new year，I am a MYSQL enthusiasts。Using MYSQL Replication, test MYSQL data synchronization.Due to data synchronization lines often disconnected, found himself to create events (events) ...
    邢立明邢立明
    Jan 2, 2014 at 9:51 am
    Jan 2, 2014 at 9:51 am
  • Hello Shawn, I have found my problem with your explanation. That was a problem with the master_log-file and the master_log_pos. I had made change on the slave with the good value (these of the ...
    Christophe CarlesChristophe Carles
    Dec 20, 2013 at 4:26 pm
    Dec 20, 2013 at 4:26 pm
  • Hello, I contact you about a problem with replication Databases with MySQL. We have a main master MySQL database server that contains data unit. This server is only accessible internally. We have ...
    Christophe CarlesChristophe Carles
    Dec 17, 2013 at 7:46 pm
    Dec 18, 2013 at 2:41 pm
  • Can someone explain the process I should go through to bring an "old" master back online as a "slave" after a successful failover using mysql-master-ha? I'm unsure exactly which log file and position ...
    Regan YelcichRegan Yelcich
    Nov 18, 2013 at 1:25 am
    Nov 18, 2013 at 10:31 am
  • Hi what do you use to split read/write requests between one master and many slave mysql server? The mysq-proxy is in alpha state from years...ad it seems that you have to manage the split at ...
    Nik600Nik600
    Oct 12, 2013 at 12:35 pm
    Oct 14, 2013 at 3:20 pm
  • I'm looking at the fastes solution to re-sync a SLAVE node after a split-brain. I have 300 databases with 80 GB of data, as i want to miminize the down-time on the master node i'd like to: 1) run a ...
    Nik600Nik600
    Sep 16, 2013 at 11:15 am
    Sep 16, 2013 at 9:54 pm
  • Kaushual, Yes, you should do a test restore when setting up your backup processes, and periodically afterwards, to check for integrity (and to make sure you have the restore process well-documented ...
    Valerie Parham-ThompsonValerie Parham-Thompson
    Sep 14, 2013 at 4:35 pm
    Sep 14, 2013 at 4:35 pm
  • Hi, I have a question regarding MySQL replication master slave setup. One question is of concern "If data is corrupted, lost or deleted in the master that will be synced to the slave. Restoring the ...
    Kaushal ShriyanKaushal Shriyan
    Sep 13, 2013 at 6:09 am
    Sep 15, 2013 at 9:49 am
  • Please leave the list in CC, Jamen - other people may either learn something or add their two cents. I'm not particularly familiar with innobackupex; but what you're showing sounds to me as if the ...
    Johan De MeersmanJohan De Meersman
    Jul 18, 2013 at 12:19 pm
    Jul 22, 2013 at 8:28 pm
  • Hi, I have configured replication from EC2 mysql instance to another mysql instance on our network via vpn in between. Sometimes it is showing no errors on the slave but the slave falls behind . When ...
    Umapathi bUmapathi b
    Jul 17, 2013 at 8:49 am
    Jul 17, 2013 at 8:49 am
  • If pt-table-checksum tells you everything is in sync, and you don't see any non-deterministic updates in the master's error log; and you still get replication errors, then I would very much assume ...
    Johan De MeersmanJohan De Meersman
    Jul 17, 2013 at 8:34 am
    Jul 17, 2013 at 8:34 am
  • Master MySQL = running mysql Ver 14.14 Distrib 5.5.17, for Linux (x86_64) using EditLine wrapper Slave #1 = running mysql Ver 14.14 Distrib 5.5.17, for Linux (x86_64) using EditLine wrapper Slave #2 ...
    McGranahan, JamenMcGranahan, Jamen
    Jul 14, 2013 at 6:28 pm
    Jul 16, 2013 at 3:25 pm
  • Hi, I'm interested in learning more about the replication code, specifically more about the part where the replication on a slave is happening in a multi-threaded environment (released in 5.6) is ...
    Alexandru PaladeAlexandru Palade
    Mar 16, 2013 at 7:34 am
    Mar 16, 2013 at 7:37 am
  • Dears; I have been faced with a case of replication which may most of you had been faced before... I did some checks and test to find out the ways to solve, but I'm not pretty sure about the cons and ...
    Shayne AloneShayne Alone
    Jan 7, 2013 at 8:31 pm
    Jan 10, 2013 at 4:41 pm
  • Dear all i'm planning the configuration of a replication environment on a mysql master with more of 300 database and about 50 GB of data, the master is a production server and can't be stopped or ...
    Nik600Nik600
    Oct 20, 2012 at 5:11 pm
    Oct 23, 2012 at 5:25 pm
  • Hi, I have a Mysql replicate setup running for a while over 6 months and recent we had an outage. We fix it, bought the server back up and we spotted something peculiar and worrying. The replication ...
    Kent HoKent Ho
    Oct 17, 2012 at 2:33 pm
    Oct 18, 2012 at 9:38 am
  • Suppose we have some MySQL 5.6 servers replicating using global transaction ID. How does one add a new slave server to such running system? Can it be done without stopping all servers? The manual ...
    Kristian NielsenKristian Nielsen
    Oct 15, 2012 at 6:57 am
    Oct 15, 2012 at 6:57 am
  • Hello, I've to make a HA mysql, for me the scalability it's not important because it's not an environment with a lot of queries. I've thinked about, and I think that the best solution is to mount an ...
    Oriol MartíOriol Martí
    Oct 11, 2012 at 2:18 pm
    Oct 11, 2012 at 8:04 pm
  • Hello, I am a student of Masters and to final project I am planning to develop a robust tools for data recovery from the log file of mySQL, but for that I need to navigate this. I wonder where I can ...
    Nuno RebochoNuno Rebocho
    Oct 8, 2012 at 12:13 pm
    Oct 8, 2012 at 1:35 pm
  • Hi! One single table out of many differs after a while between mysql master and slave. The statement altering the table is: UPDATE SEQ_GEN SET SEQUENCE_VALUE = SEQUENCE_VALUE + 10 WHERE SEQUENCE_NAME ...
    Stallmann, AndreasStallmann, Andreas
    Oct 1, 2012 at 12:33 pm
    Oct 1, 2012 at 9:56 pm
  • Dear all i'm scouting some of the scalabilty features of Mysql, considering some of the limitations of NDB engine at the moment i'd like to implement an architecture with a single master node and ...
    Nik600Nik600
    Sep 23, 2012 at 12:56 pm
    Sep 23, 2012 at 6:21 pm
  • Hi MySQL users, For moniroting purposes, I did a test of MySQL replication + some other services configured on high availability with heartbeat/pacemaker on 2 VMs. Now I have to write the ...
    StyrStyr
    Sep 4, 2012 at 3:17 pm
    Sep 4, 2012 at 3:17 pm
  • Hi All, I am testing XFS on mysql as i have been reading stuff that says XFS performs faster. I created a extra slave and created a XFS volume and mount it on the mysql dir slave was running fine ...
    Ron ramosRon ramos
    Aug 15, 2012 at 5:50 pm
    Aug 15, 2012 at 5:50 pm
  • Hi, we run a master/slave mysql 5.1.61 Red Hat EL 6.3 setup - two servers. Both use the default binlog format. Today I'm asked to change the bin log format to 'ROW' because a special Application ...
    Götz ReinickeGötz Reinicke
    Aug 3, 2012 at 8:42 am
    Aug 3, 2012 at 1:31 pm
  • Hi, How come even though replication is in sync, sometimes the no of rows will be different between master and slave? Without any bugs!
    Reddy YKReddy YK
    Jul 20, 2012 at 5:18 am
    Jul 20, 2012 at 6:50 am
  • Hi, I would run a unix command at the end of each synchronization (on the PC with mysql server in slave mode). I checked the options to be included in my.cnf and I have not found anything... Is there ...
    Matteo BrighiMatteo Brighi
    Jul 13, 2012 at 10:40 pm
    Jul 17, 2012 at 11:38 am
  • Hi All, i am planning on allocating a separate volume for tmpdir on my slave(and most probably master), the volume will be setup as a software RAID 0.for write performance increase i noticed i cant ...
    Ron ramosRon ramos
    Jul 5, 2012 at 5:07 pm
    Jul 16, 2012 at 10:28 pm
  • Hello, I have a big problem with my MySQL Master Slave configuration on Debian Squeeze. I set up a replication configuration. But the slave stopped the replication with the error message below ...
    Gronies, ThomasGronies, Thomas
    Jun 13, 2012 at 8:24 pm
    Jun 13, 2012 at 8:24 pm
  • Hi All, I am currently using amazon ec2 for my database and i would like to create a script that captures snapshot of my volumes. I just want t know how i can flush tables with read lock and not lose ...
    Ron ramosRon ramos
    May 12, 2012 at 11:43 am
    May 17, 2012 at 11:37 pm
  • You may have better luck in the Cluster-specific mailing list: <span class="m_body_email_addr" title="8e51ea696a7022f419aac051c49611df" cluster@lists.mysql.com</span -- Shawn Green MySQL Principal ...
    Shawn GreenShawn Green
    May 10, 2012 at 3:32 pm
    May 14, 2012 at 1:40 pm
  • Hello everyone, Can anyone shed some light on the practical differences between master-slave replication and manual replication with mysqldump? What advantages and disadvantages does the first ...
    Rafael Arco ArredondoRafael Arco Arredondo
    May 8, 2012 at 11:36 am
    May 8, 2012 at 12:17 pm
  • Hi, Would it be possible to trace which query cause the lag on the slave? I have a script that runs every minute to check the lag, I basically have the output of "show slave status" and timestamp and ...
    Ron ramosRon ramos
    Apr 22, 2012 at 2:53 am
    Apr 24, 2012 at 2:00 pm
  • Hi, Any documentation regarding setting up MySQL Replication. I have been referring to http://dev.mysql.com/doc/refman/5.5/en/replication.html and also what are the typical scenarios to be setup viz ...
    Kaushal ShriyanKaushal Shriyan
    Apr 6, 2012 at 12:16 am
    Apr 6, 2012 at 6:24 pm
  • Hi Is it possible if i grab a dump of a certain table from the master restore it on the slave and start replication again? I have a table that is is not synched on the server, i have tried using ...
    Nhadie ramosNhadie ramos
    Apr 4, 2012 at 4:09 am
    Apr 4, 2012 at 8:17 pm
  • Hi, I currently have a replication setup with master and 1 slave. i would like to add one more slave into the setup. is it possible if i lock the slave tables, show slave status and get Relay_Log_Pos ...
    Nhadie ramosNhadie ramos
    Apr 1, 2012 at 4:54 pm
    Apr 3, 2012 at 5:04 am
  • Surge 2012, the scalability conference, September 27-28, Baltimore, MD has opened its CFP. Please visit http://omniti.com/surge/2012/cfp for details. -- Katherine Jeschke Director of Marketing and ...
    Katherine JeschkeKatherine Jeschke
    Mar 30, 2012 at 2:18 pm
    Mar 30, 2012 at 2:18 pm
  • They shouldn't, afaik, unless you precede your grants with a revoke statement. You don't need to issue flush privileges if you use grant statements, but a flush privileges will only flush the ...
    Johan De MeersmanJohan De Meersman
    Feb 21, 2012 at 6:47 am
    Feb 21, 2012 at 6:47 am
  • Hello people: I'm replicating a database master-slave with mysql replication, but my database have reference to files. I need any tools to solve my problem, do u have something that I can use?? sorry ...
    Ing. Yunior Bauta PentónIng. Yunior Bauta Pentón
    Jan 24, 2012 at 8:55 pm
    Jan 25, 2012 at 8:15 am
  • We are using MySQL5.1 (5.1.49-3) on debian squeeze and have it setup in a Master/Slave relationship. The master is a VM on our primary XenServer and the slave is a VM on our secondary XenServer. The ...
    SimonSimon
    Jan 18, 2012 at 7:07 pm
    Jan 20, 2012 at 7:33 am
  • Hi, We know when we upgrade replication servers from 5.0 to 5.1, we need to upgrade slave server first. But what about master to master replication? Thanks, Lisa -- MySQL Replication Mailing List For ...
    Database SystemDatabase System
    Jan 2, 2012 at 12:50 pm
    Jan 5, 2012 at 4:32 pm
  • One of the likely causes (barring unusual replication setup) for differing data, is nondeterministic queries, like "insert into table1 select * from table2 limit 10": because there is no order by in ...
    Shl_256Shl_256
    Dec 27, 2011 at 4:46 pm
    Dec 28, 2011 at 3:15 pm
  • To confirm that you would like <span class="m_body_email_addr" title="38c5e321ea462d1a40de26a6353ba09d" jlistreader@gmail.com</span added to the replication mailing list, please click on the ...
    Replication-helpReplication-help
    Dec 5, 2011 at 10:14 am
    Dec 5, 2011 at 10:14 am
  • Hello, my fellow developers and admins I have a question regarding a master-master replication system. I implemented one with the help of some of you guys - however I had some problems regarding the ...
    Ricardo FreitasRicardo Freitas
    Oct 26, 2011 at 7:20 pm
    Oct 27, 2011 at 8:52 pm
  • So the one issue I have is that replication one way takes half an hour but the other way is instantaneous. Anyone have any suggestions on how to troubleshoot this ? Thanks, Chris
    MarMar
    Oct 22, 2011 at 8:18 am
    Oct 23, 2011 at 3:19 pm
Latest
Group Navigation
period‹ prev | Latest | first ›
Group Overview
groupreplication @
categoriesmysql
discussions649
posts2,476
users591
websitemysql.com
irc#mysql

Top users

Rick James: 242 posts Database One: 133 posts Marcus Bointon: 108 posts Johan De Meersman: 63 posts Augusto Bott: 35 posts Jesse: 28 posts Kishore Jalleda: 28 posts Kaushal Shriyan: 24 posts Mats Kindahl: 23 posts Lars Thalmann: 22 posts Thomas: 21 posts Jesse: 19 posts Miguel Araújo: 19 posts Ricardo: 18 posts Shawn green: 18 posts Mark Callaghan: 18 posts Sureshkumarilu: 17 posts Eber Duarte: 17 posts Ed W: 16 posts Eric Bergen: 16 posts
show more
Archives