DevHeads.net

Replication

Watch Porto vs Manchester City Live Stream Free Soccer Online

Watch Porto vs Manchester City Live Stream Free Soccer Online
Porto vs Manchester City
Match Scheduled 16-02-2012 from 3:05pm (US/Eastern)
Location Estádio Do Dragão (Porto)
UEFA Europa League
Porto vs Manchester City team are known to all soccer faners in the world.UEFA Europa League live streaming soccer match Porto vs Manchester City match is very exciting.
Watch Porto vs Manchester City Live

<a href="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/" title="http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stream-free-soccer-online/">http://www.live-stream-free.com/watch-porto-vs-manchester-city-live-stre...</a>

Error 1236 and contradictory data from MySQL that a binlog file exists

Our replication recently stopped working. I submitted a question to DBA Stack Overflow but was unsuccessful in fixing the problem (<a href="http://dba.stackexchange.com/q/139131/55530" title="http://dba.stackexchange.com/q/139131/55530">http://dba.stackexchange.com/q/139131/55530</a>).

Invisible data inconsistency

Hullo list,

I've found another one that stumps me: maatkit (I don't have access to the hosts directly, so percona toolkit doesn't work) reports differences between a few tables. Using checksum table confirms those differences. Using md5() and length() I can, again, confirm the differences. However, when I do a comparison of the actual data, nothing is different, even when using mysql --batch to export the offending fields and comparing with diff or md5sum...

Versions (5.5.46) and character sets are identical. Does anyone have any idea how to pinpoint this?

This should be simple...

..and hopefully this is the right list.

I have a FreeBSD server running Mysql-server 5.5 with a handful of databases (well, maybe 20).

I have three other machines:

Slave A - FreeBSD
Slave B - FreeBSD
Slave C - OS X

What I want is for all the databases on the sever to be replicated to the other three machines.

log event entry exceeded max_allowed_packet

Hullo,

I'm running a generic master/master setup with one active node. On the passive node, I am getting the dreaded error 1236: "Got fatal error 1236 from master when reading data from binary log: 'log event entry exceeded max_allowed_packet; Increase max_allowed_packet on master".

However, max_allowed_packet is already 1G on both nodes; and the master had no problem receiving the incoming statements. Binlog format is mixed, so perhaps the transaction is too large in ROW format?

Are everyone interested in compressing binlog?

Hi All,

I'm a dba of tencent Inc. We make extensive use of MySQL as our database in our
business. So we are very grateful for your contribution.

But in our businesses (mainly are games), there is usually a lot of binlog generated in
a short time. For example, a game called "QQ Dancer", it has one million online players at the
same time, we use more than 200 machines as its database server, they generate about 1.6T
binlog per hour altogether. This is the result of using MIXED mode, it will be even larger in ROW mode,
However, we have more than 10 games just like it.

connection issue

Hi,

We have replication implemented on 2 servers (master/slave) that are located in 2 different locations.

Master Master Mysql replication

Hi,

We have two AWS region EU Ireland and Singapore which is currently being
zeroed in for Redundancy. Can someone please provide me some insights about
Replication as described in
<a href="http://dev.mysql.com/doc/refman/5.7/en/replication.html" title="http://dev.mysql.com/doc/refman/5.7/en/replication.html">http://dev.mysql.com/doc/refman/5.7/en/replication.html</a>. I am not sure
which one i need to choose for my setup and any pros and cons associated
with this setup. Basically we are planning to have Master Master MySQL DB
setup. Any help will be really appreciable.

Regards,

Kaushal

Issue with mylogin.cnf in version 5.6.25

Hi,

I have configured replication with 1 master and 1 slave with GTID mode = ON on Red Hat Enterprise Linux Server release 6.6,

Mysql version 5.6.25.

We have done this on other RH 6 servers with no issues on mysql version 5.6.21, and tested on 5.6.24.

In 5.6.25, I get a connection error when using mysqlrpladmin:

mysql)/var/lib/mysql> mysqlrpladmin --master=shibpr03:3306 --slaves=shibpr05:3306 health

ERROR: ("Cannot connect to the master server.\nError Access denied for user 'dbaroot'@'ip address' (using password: YES)", 1045)

Workaround 1 (input the user, pwd & server names or I

data on slave are missing after restart the master server

Hi,

I have restarte the master, now some data are missing on the slave server.
What I have to do to get the missing data on the slave server.

slave server status is OK and master / slave is working...

thanks
Thomas

slave server id ..70 to id ..87 is missing
+-------------+---------------------+
| id_varcheck | attempt_start |
+-------------+---------------------+
| 358588 | 2015-06-30 20:16:34 |
| 358569 | 2015-06-30 17:54:26 |

Replication manual: table about mixed log format

I refer to the "big" table that appears here:

<a href="https://dev.mysql.com/doc/refman/5.1/en/binary-log-mixed.html" title="https://dev.mysql.com/doc/refman/5.1/en/binary-log-mixed.html">https://dev.mysql.com/doc/refman/5.1/en/binary-log-mixed.html</a>

In my understanding, there are two errors in the table, in the lines for
SAFE statement, with ROW format: "Error: not loggable" should appear only
when RLR is Yes (and the logging should be ROW in the two lines where RLR
is No).
In fact, if the logging can only be ROW, but the ROW Logging is
Restricted (RLR=Yes) logging should not be possible.

Am I wrong?

Thanks in advance
Flavio

Table schema is not in order - Binlog

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 and send it to
hdfs, but it's not working as expected.

My MySQL table will has a table (Id, Name, age), but in binlog it's coming
as (age, Id, Name)(the fields are sorted in alphabetical order).

Is there a way to avoid this situation?

Here are my specs:

Server : Centos 6.5 64bit
Mysql Version : 5.1.73 installed using yum
Hadoop : 2.4.1
Hive : 0.13
Python : 2.7

Changing "binlog_format" on master and slave

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 STATEMENT-based logging of course).
However, we are OK with restarting master and/or slave.

So, what is the safest way to switch, while ensuring that no data is
lost in replication?
Will setting "binlog_format=ROW" on master, and "binlog_format=MIXED"
on slave suffice?

Waiting for a reply.

Thanks and Regards,
Ajay

MySQL 5.6 parallel replication broke

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 thread, resulting in a delay of 0 to 4000 seconds.
Both servers are running Ubuntu with mysql 5.6.17

I suspect that the problem iam seeing is from the following bugs-reports:
<a href="http://bugs.mysql.com/bug.php?id=72794" title="http://bugs.mysql.com/bug.php?id=72794">http://bugs.mysql.com/bug.php?id=72794</a>
<a href="http://bugs.mysql.com/bug.php?id=73066" title="http://bugs.mysql.com/bug.php?id=73066">http://bugs.mysql.com/bug.php?id=73066</a>

Can anyone tell, if newest version is affected too?

problem after sync between master and slave

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 new slave without blocking the master and without doing a
mysqldump/import on the master.

The master is using LVM, so i've created a script that does the following:

- stop mysql on slave
- flush tables with read lick on master
- read the master file and position
- create a snapshot on the LVM on master
- remove the lock on master
- mount the snapshopt on master
- make an rsync from master to sl

Mysql replication setup

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
avoid doing a full locked dump of the db if possible, since the database
is quite large
My idea is to start the slave sync with one table, and add all of the
databases / tables one by one.
This way, the only down time would be while 1 table gets dumped

In theory, it should work, does anybody has any experience with a
solution like this?

I've put together a script to add a table to a running

MYSQL timing task is missing

Hi :

MYSQL when doing data synchronization, the occasional lost events .Excuse me what reason be?

thanks!

MYSQL loss events

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) lost.What reason is this excuse me?
thanks

Re: replication problem's with data base mysql

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 master).
I had copied the DB from the master to the slave, change the rights and
now it's OK.

Thank you very much for your help.

Regards,

replication problem's with data base mysql

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 LAMP servers in DMZ (accessible from the Internet) that
are slaves of the master.
The configuration is done with the file / etc / my.cnf (the servers are
under centos)
Below is a sample configuration of a slave:
[mysqld]
datadir=/var/lib/mysql
socket=/var/lib/mysql/mysql.sock
user=mysql
# Disabling symbolic-links is recommended to prevent assorted security risks
symbolic-links=0
master-host=peric2.ib

old master to slave?

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 I should be using to get it all re-syncing again with the new master? The server will obviously have a lot of the data already onboard, so it just needs to pick up where it left off when starting to sync from the new master. Would I do a "show master status" on the NEW master to get the log file name only, and do the same on the OLD master to get the Position? Or what should I be doing?
Thanks.

solution to split read-only query between master and slave

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 application-level.

What do you suggest to use to split sql queries between many
slave-replicated and one master node?

Thanks

use rsync to fast sync a SLAVE node after a split-brain

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 first rsync from master to slave
2) shut down the master
3) run a 2nd rsync
4) start the slave
5) start the master

is this the correct way?

can i simply lock all write command to the master at step 2 instead of
shutting down it?

Thanks

MySQL Master and Slave Replication

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 slave to the master does
not get the data back."? Please suggest.

Regards,

Kaushal

2 slaves - one Master; continues to fail

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 = running mysql Ver 14.14 Distrib 5.5.17, for Linux (x86_64) using EditLine wrapper

For days now, I have been trying to resolve why my slaves keep failing. I have tried any number of suggestions found via Google, including doing a full dump & reload into my slave. However, both slaves keep coming up with some kind of duplication error.

Replication code

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 implemented.

Where and how does the code blocks parallel execution once the query is
decided as it to be on the same database. Is there a lock per database? Or
is there a unique thread per database?

In any case, can you point me more specifically to the code? I've been
trying to look over it and I am a bit stuck around rpl_rli, rpl_slave,
rpl_rli_pdb files.

Thanks,
Alex

Replicating on multiple Slaves DB from one Master

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 pron.
problems is as fallow:
Master:
Single Mysql with about ~30K QPS, mainly just work as AAA data back end.
not all but lots of these queries are writes (INSERT/UPDATE).
the matter is that when the slave wants to execute Transactions with one
thread!

How to sync SLAVE to a production MASTER

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 write-locked for a long
time (more than 5 minutes is a logn time in this case)

The database contains both MyISAM and InnoDB tables.

I've read that the LOAD-DATA-FROM-MASTER command is deprecated and not suggested

<a href="http://dev.mysql.com/doc/refman/5.1/en/load-data-from-master.html" title="http://dev.mysql.com/doc/refman/5.1/en/load-data-from-master.html">http://dev.mysql.com/doc/refman/5.1/en/load-data-from-master.html</a>

But

- i can't run a mysqldump on the production server as it takes about
3 hours and during that time there will be wr

How to add a new slave with Global Transaction ID in MySQL 5.6?

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 only seems to mention changing existing servers to use global
transaction ID, not how to add a new server.

- Kristian.

Best solution for a HA without shared storage

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
master-slave arquitecture, and if the master goes down, promote the
slave to master. Monitoring this case, after manually we can put the
master with slave status and recover the environment.

What do you think that's the best tool to do this? Pacemaker or Red Hat
Cluster Suite? Does anybody knows some example of configurations?

Thanks!

Structure of Binary Log

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 find information about the structure of the log
file and how can I read (without mysqlbinlog). In the MySQL
documentation I can not find this information specifies.

Thank you,

PS-Sorry if the email is received repeated emails to inform but some
flaws in reception

Replication breaks - slave differs from master

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 = 'Client_Object_SEQ'

We already checked, that no other process but the replication is altering the slave.

The logs show, that some transactions are completed in a different order on the master and the slave. Still, it’s in no way the obvious reason for the difference between the two hosts.

Any ideas? Any (kind) RTFMs? :-)

Cheers,

Andreas

how to manage one master and many slaves

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 many slaves
with a simple replication.

I can write some code into my application to connect directly to the
master when there is an insert/update/replace and connect directly to
slaves when i have slect queries, but this has a significant impact on
the application, expecially it the number of slaves increases a lot.

I'd like to use a very simple "proxy" feature that just forward write
requests to t

MySQL on XFS

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 until
i noticed that the lag increase, and when i check, one query got stucked:

3 system user my_db Connect 9661 updating
DELETE FROM blah blah

this did not happen to my other slave which is running on ext3.

Changing the bin log format on existing servers

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 needs that format.

Sync between master and slave

Hi,

How come even though replication is in sync, sometimes the no of rows will
be different between master and slave? Without any bugs!

Unix command after slave sync

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 a way to do it?

thank you very much

Matthew

mysql tmpdir

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 just simply change it during
runtime, is there a way to update without mysq restart?

also, since i will be usig RAID 0, if 1 disk fails my tmpdir will be
broken, is that gonna cause mysql to fail, and again
the need to restart mysql. thank you in advanced.

Regards
Ron

Build slave manually with master binlogs

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

Last_Errno: 1594
Last_Error: Relay log read failure: Could not parse relay log event entry. The possible reasons are: the master's binary log is corrupted (you can check this by running 'mysqlbinlog' on the binary log), the slave's relay log is corrupted (you can check this by running 'mysqlbinlog' on the relay log), a network problem, or a bug in the master's or slave's MySQL code.

maintain mysql session on bash script

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
the session while the script is running, e.g. i do these:

mysql -pblahblah -A blahblah -e 'flush tables with read lock; show
master status;'"

then create snapshot then

mysql -pblahblah -A blahblah -e ''unlock tables;"

anyone who has successfully done this?

thank you in advance.

Regards,
Ron

Master-slave replication vs manual replication via mysqldump

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 approach have compared
to the second one? Is replication always safe and consistent with
mysqldump (with --single-transaction and so on, of course)? Can
master-slave replication be too slow?

Thank you in advance and kind regards,

Rafa

tracing cause of lag

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
how much delay: "Sun Apr 22 04:16:01 SGT 2012 -- Slave Lag: 120"
would this be possible? thanks in advanced!

Regards,
Ron

MySQL Replication

Hi,

Any documentation regarding setting up MySQL Replication. I have been
referring to <a href="http://dev.mysql.com/doc/refman/5.5/en/replication.html" title="http://dev.mysql.com/doc/refman/5.5/en/replication.html">http://dev.mysql.com/doc/refman/5.5/en/replication.html</a> and
also what are the typical scenarios to be setup viz Master Master Slave or
Master Slave or Master Slave Slave. Help me understand the pros and cons of
this various combinations.

Thanks and Regards,

Kaushal

discrepancy on a single table

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 pt-table-checksum to that table but i get the error "because 1
cannot be nibbled safely."

so i'm thinking of just stopping the slave, grab a dump of the table
and restore to slave. will there be any data corruption?

thanks in advance.

Regards,
Ron

adding another slave

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 and Relay_Master_Log_File. and create
a snapshot. once done, use the created snapshot to the new slave and
start replication with the values i got from the slave?

Reason i would like to do this is because i don't want to lock tables
on the master.

TIA

Regards,
Ron

Surge 2012 CFP is Open!

Surge 2012, the scalability conference, September 27-28, Baltimore, MD
has opened its CFP. Please visit <a href="http://omniti.com/surge/2012/cfp" title="http://omniti.com/surge/2012/cfp">http://omniti.com/surge/2012/cfp</a> for
details.

Slow Slave Replication Catchup

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 VMs are not using SWAP. The VMs have the following resources:

Master: 4 x VCPUs, 10GB of Memory, 8GB System Disk, 100GB Data Disk (for mysql, disk on iSCSI NAS)
Slave: 1 x VCPUs, 6GB of Memory, 8GB System Disk, 100GB Data Disk (for mysql, disk on local server storage)

Each night at 12:30am we run a mysqldump backup from the slave using the following process.

master to master upgrade 5.0-> 5.1

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

Please HELP us LIKE in Facebook (not a virus)

Hello there,

Please help us LIKE couple number #3..
-Deejoy & Luigi-
they are my friends who is getting married!

<a href="https://www.facebook.com/photo.php?fbid=10150399720159166&amp;set=a.10150399715774166.378046.79567424165&amp;type=1&amp;ref=nf" title="https://www.facebook.com/photo.php?fbid=10150399720159166&amp;set=a.10150399715774166.378046.79567424165&amp;type=1&amp;ref=nf">https://www.facebook.com/photo.php?fbid=10150399720159166&amp;set=a.10150399...</a>

 
Thank you,
Chen

Slave got " 'Invalid error code' (126)"

Hi,

Is there anybody seen this before? And how to resolve this?

From SLAVE STATUS:
Slave_IO_Running:Yes
Slave_SQL_Running:No

From slave's error log:
[Error] Slave: Query caused differnt errors on master and slave.
Error on master: 'Invalid error code' (126), Error on slave: 'no error' (0)
...
[Error running query, slave SQL thread aborted.
...

Thanks,
Lisa

sql_log_bin

Hi!,

I have 3 servers A, B and C

A is master, B is slave of A
C is a slave, B is master of C

if i do a delete in A, i need that the deletes replicate in B.. its ok,
work ok.

But.. in need that in B the delete don't affect the binlog and C without
deletes from B.

I try to put a set session sql_log_bin=0 or set session sql_log_bin=1 in
triggers in B (before delete value 0, after delete value 1)... not work :(

C must have all the data, no delete of any kind.

any ideas??

Thank you!

Temporary table issue

Dear Team/Group

I am facing a weired proble. I have a M-S replication setup. Application
useing temporary table on master server. Normally Replication running fine,
But when ever MySQL instance is down(Either By carsh or Scheduled Downtime),
Replication breaks giving error (Table not exist).

What is the solution/Fix for this error, so i can ensure replication is up
and there is no data loss.

Any help will be appriciated.

Master-Master -> duplicate entry

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 agent so I have a master-master and not a mmm system
- and now I come across the awfull 1062 error - the 'Error 'Duplicate entry
'123020901' for key 'PRIMARY'' on query.'

The issue here is I sometimes insert on master 1 (let's call it like this)
and sometimes on master 2.

dual master setup good but one issue

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

mmm - mysql

Hey guys

Followed your gentle advice regarding the mmm-mysql system and It is a go. I
have a few questions that I've tried to found asnwer too but in vain.
Regarding the configuration of the monitor, I found that there are a bunch
of virtual addresses that the manual doesn't specify if I need to create
them (on my network) or if is just something the monitor will handle.

More trouble about semi-sync

Hi all

First time I read the feature about
semi-sync<http://code.google.com/p/google-mysql-tools/wiki/SemiSyncReplication>,
i found this in the Introduction

"it blocks return from commit until either ****at least one semi-sync
slave**** acknowledges receipt of all replication events for the transaction
or until a configurable timeout expires"

So i though if *multi* semi-sync slaves can help the master get ack more
quickly.

Error connecting to master

Hi,

In my master-> multi-slave replications, one of the slaves was stopped. The error said
Slave I/O error: error connecting to master 'rep_user'@'host_ip:3306'
Error_code:1129.
Another similar error message said Error_code 2003. (I don't find this error code in the manual)

The network connection is fine. The number of connections is much less than max_connections on the master. Host ip didn't change and ping from slave to master is OK.

Any advices? Thanks advance,
Lisa

A feature patch for semi-sync

Hi all

The patch for semi-sync has been commit to Launchpad.net:
lp:~orczhou/mysql-server/ESR<https://code.launchpad.net/~orczhou/mysql-server/ESR>
.

A feature request on bug system has been report :
<a href="http://bugs.mysql.com/62174" title="http://bugs.mysql.com/62174">http://bugs.mysql.com/62174</a>

Semi-sync is cool. But in the semi-sync solution, there are “phantom
read”: When InnoDB commit a transaction and no slave have accept the
binary log, at the time another “new thread” still can read the
data generated by this transaction.

5.0 Master -> 5.1 Slave replication issues

I have a new slave server that has MySQL 5.1 on it and I have a 5.0
Master server. As I understand it this is a valid setup.

It seems as if the 5.1 server's replication is falling far behind the
master even though it appears as if replication is functioning
properly otherwise.

Seconds Behind the master 0 but in reality it's over 10 minutes or hours..

Dear List,

I have a Master -> [ Slave 1, Slave 2 ] setup for years.

Last week we've reinstalled the whole setup to: 5.1.58 from: 5.1.54.

The situation is:

the master says: (show master status)

mysql-bin.000087 | 974376716

slave says: (show slave status)

Master_Log_File: mysql-bin.000087
Read_Master_Log_Pos: 627246309
Exec_Master_Log_Pos: 627246309
Relay_Log_Space: 596009233
Seconds_Behind_Master: 0

In reality, it's NOT 0 seconds! it's delayet more than 10-20 minutes,
some times more than 1 hours.

Why? Is it a network problem? If i restart the slave, nothing happens.

Syndicate content