On Tue, Oct 19, 2010 at 19:06, John Daisley wrote:
> You may also want to take a look at MySQL MMM which makes use of
> Active/passive masters to makes MySQL failover very simple.
+1 We could not do much of our daily work without MMM. It makes
the whole HA/Failover thing a breeze. We have it i
:machi...@rdc.co.za]
>Sent: Tuesday, October 19, 2010 5:15 AM
>To: mysql mailing list
>Subject: Failover on master/slave replication
>
>Good day all
>
>I am hoping someone has had some experience in this to assist
>me.
>
>I have been going through lots of foru
You may also want to take a look at MySQL MMM which makes use of
Active/passive masters to makes MySQL failover very simple.
On 19 October 2010 11:45, Johan De Meersman wrote:
> That's pretty much it, indeed. You need to make absolutely sure that no
> more
> connections can be made to the old,
That's pretty much it, indeed. You need to make absolutely sure that no more
connections can be made to the old, broken master, though - even if you have
to physically pull the network or power cable. Failover services refer to
this as STONITH: Shoot The Other Node In The Head.
Don't think "but it
Quoting Machiel Richards :
The question I have however is how do you fail over to the slave
server in the event that the master server is unavailable and then how
to revert back to the master server once the server is available again.
Hi,
to fail over to the slave, you dont need t
Good day all
I am hoping someone has had some experience in this to assist
me.
I have been going through lots of forums and documentation and
can find a lot of information on how to setup a master/slave replication
on MySQL.
The question I have however is how do you fail
On Thu, Aug 26, 2010 at 6:04 AM, Norman Khine wrote:
> hello,
> i have a working master-slave replication, the problem i find is that
> if i restart the MASTER there is a difference in the MASTER_LOG_FILE
> and MASTER_LOG_POS on the SLAVE.
>
> what is the correct way to keep
* 1. row ***
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
-Original Message-
From: Norman Khine [mailto:nor...@khine.net]
Sent: Thursday, August 26, 2010 6:05 AM
To: mysql@lists.mysql.com
Subject: master-slave replication sync proble
Slave_IO_Running: Yes
Slave_SQL_Running: Yes
> -Original Message-
> From: Norman Khine [mailto:nor...@khine.net]
> Sent: Thursday, August 26, 2010 6:05 AM
> To: mysql@lists.mysql.com
> Subject: master-slave replication sync problems.
>
> hello,
> i have a wor
Quoting jitendra ranjan :
Hi,
The best way to use sync the master and slave is using mk-checksum
tools. just google it and use the the tools for online sync of
master and slave.
Jeetendra Ranjan
MySQL DBA
Yes, data integrity isnt guaranteed with MySQL replication. So if you
want to b
Quoting Ananda Kumar :
Smith,
I never said, this wont work.Some times, there are chances of lossing data.
regards
anandkl
If you have experience of this fair enough. Theres no reason it should
make any difference, as everything is based upon the binlog file and
position...
--
MySQL
Hi,
The best way to use sync the master and slave is using mk-checksum tools. just
google it and use the the tools for online sync of master and slave.
Jeetendra Ranjan
MySQL DBA
--- On Thu, 26/8/10, Norman Khine wrote:
From: Norman Khine
Subject: master-slave replication sync problems
Smith,
I never said, this wont work.Some times, there are chances of lossing data.
regards
anandkl
On Thu, Aug 26, 2010 at 8:48 PM, wrote:
> Quoting Norman Khine :
>
> i see, so the best is to just stop slave and then check the master
>> status, and when the master status syncs then i start t
Quoting Norman Khine :
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
Well Im willing to hear from others experiences, but if you really
shouldnt have to do anything. If you want you can issue a stop slav
Yes,
You need to note down the master bin-log file name and position on the
slave, this is a must.
regards
anandkl
On Thu, Aug 26, 2010 at 7:34 PM, Norman Khine wrote:
> i see, so the best is to just stop slave and then check the master
> status, and when the master status syncs then i start
i see, so the best is to just stop slave and then check the master
status, and when the master status syncs then i start the slave?
On Thu, Aug 26, 2010 at 3:09 PM, wrote:
> That is really bad, you will loose changes.
>
> You shouldnt have to do anything when rebooting either the master or sla
True,
But some times, this does not work and u need to know the master bin-log
file and position to start, so that there is no loss of data.
regards
anandkl
On Thu, Aug 26, 2010 at 6:39 PM, wrote:
> That is really bad, you will loose changes.
>
> You shouldnt have to do anything when rebooting
That is really bad, you will loose changes.
You shouldnt have to do anything when rebooting either the master or
slave. If the master is down, then the slave recieves no updates. If
the slave is down, when it comes back up it checks the master log pos
and plays thro any changes that are nec
complete sync with
master...
Here u will see the master log file and position.
U need to use this, next time u start ur slave to sync with master.
regards
anandkl
On Thu, Aug 26, 2010 at 6:34 PM, Norman Khine wrote:
> hello,
> i have a working master-slave replication, the problem i find is tha
hello,
i have a working master-slave replication, the problem i find is that
if i restart the MASTER there is a difference in the MASTER_LOG_FILE
and MASTER_LOG_POS on the SLAVE.
what is the correct way to keep the two slaves in sync even after i
restart the server. the way i do it now is to
n read-heavy environments. As I mentioned
before, my main goal here is geographic redundancy, load balancing and the
ability to use applications that aren't really designed to be used with
master/slave replication (Drupal, WordPress, etc) without having to modify
those applications.
ecords for
1.2.3.4, 2.3.4.5 and 3.4.5.6. Using round-robin DNS, the connections for
clients are distributed across all three geographically redundant servers using
poor-man's load balancing.
> Geographical redundancy is different: a dns record with a zero
> ttl, with a master->sla
ications will never support it, and therefore never be able to be
geographically redundant."
Geographical redundancy is different: a dns record with a zero ttl, with a
master->slave replication setup. Point the record a the master and if it fails,
change the dns entry to point to the slave.
> Moreover, it works today as opposed to waiting until the end
> of time for the database developers to add features like that
> (which mysql cluster is already a distributed database, and
> the devs have said they're not interested in trying to turn
> the regular mysql into a distributed product,
ey were designed to scale well.
Regards,
Gavin Towey
-Original Message-
From: Tim Gustafson [mailto:t...@soe.ucsc.edu]
Sent: Friday, September 25, 2009 2:44 PM
To: mysql@lists.mysql.com
Subject: Re: Master/Slave Replication Question
> Another thought would be at the application laye
> Another thought would be at the application layer, sending
> all the updates (insert,delete, update, etc) to server A,
> and the selects to the local slave servers.
This has been suggested before, and I'm totally against it. Applications like
PHPBB, Drupal, WordPress, etc can't be easily confi
Hi,
I'm a big fan of mySQL's multi-master replication, but I've run into gotchas
over the years. Off the top of my head, I can think of:
- auto_increment complications,
- if you have a->b->c->a, it's not exactly graceful to insert a "d" server for
a->b->c->d->a
- if you have a->b->c->a and b
Yeah. You should use mk-heartbeat, it's the best tool for this situation
that I have seen before.
On Wed, Dec 24, 2008 at 10:06 PM, Baron Schwartz wrote:
> On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul wrote:
> > Slightly more complicated (and also probably more accurate- the time
> > reported by
il.com [mailto:baron.schwa...@gmail.com] On Behalf
> Of Baron Schwartz
> Sent: 2008年12月26日 0:56
> To: xufeng
> Cc: Jake Maul; claudio.na...@gmail.com; andy-li...@networkmail.eu;
> mysql@lists.mysql.com
> Subject: Re: On fighting with master-slave replication lag
>
> 2008/12/24 xufen
2008/12/24 xufeng :
>
>
>> -Original Message-
>> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf
>> Of Baron Schwartz
>> Sent: 2008年12月24日 22:06
>> To: Jake Maul
>> Cc: mysql@lists.mysql.com
>> Subject: Re: On fig
your great help.
>> Yours
>> Xu Feng
>>
>>
>>
>>> -Original Message-
>>> From: xufeng [mailto:xuf...@yuanjie.net]
>>> Sent: 2008年12月25日 10:13
>>> To: 'Baron Schwartz'; 'Jake Maul'; claudio.na..
tworkmail.eu; claudio.na...@gmail.com
>> Cc: mysql@lists.mysql.com
>> Subject: RE: On fighting with master-slave replication lag
>>
>>
>>
>>
>>> -Original Message-
>>> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
>
etworkmail.eu; claudio.na...@gmail.com
> Cc: mysql@lists.mysql.com
> Subject: RE: On fighting with master-slave replication lag
>
>
>
> > -Original Message-
> > From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On
Behalf
> > Of Baron Schwartz
> -Original Message-
> From: baron.schwa...@gmail.com [mailto:baron.schwa...@gmail.com] On Behalf
> Of Baron Schwartz
> Sent: 2008年12月24日 22:06
> To: Jake Maul
> Cc: mysql@lists.mysql.com
> Subject: Re: On fighting with master-slave replication lag
>
> On W
On Wed, Dec 24, 2008 at 2:31 AM, Jake Maul wrote:
> Slightly more complicated (and also probably more accurate- the time
> reported by show slave status is known to be unreliable in some cases)
> would be a script that inserts a row into a table, then check the
> slave over and over till it arrive
in maatkit which does replication tracking,
although I've not yet used it. Judging by the other tools in that
package though, it's probably pretty decent :).
Jake
On Mon, Dec 22, 2008 at 8:26 PM, xufeng wrote:
> Hello everyone,
> In my production system, I set up MySQL 5.0.67 master/
Hi,
I use Mycat to monitor more than 300 servers using a single config file.
It can be used only for replication monitoring though
Regards,
Chandru
www.mafiree.com
On Tue, Dec 23, 2008 at 10:51 PM, Andy Shellam wrote:
> Hi
>
> I would suggest a Nagios monitoring system, useful for many di
Hi
I would suggest a Nagios monitoring system, useful for many different checks
and with plugins to check also mysql replication.
I'll second this. The standard check_mysql plugin included with Nagios
allows you to monitor a MySQL slave and alert when the lag behind the
master is larger
I would suggest a Nagios monitoring system, useful for many different checks
and with plugins to check also mysql replication.
Aloha!
Claudio Nanni
2008/12/23 xufeng
> Hello everyone,
> In my production system, I set up MySQL 5.0.67 master/slave replication,
> and
> recently I met
Hello everyone,
In my production system, I set up MySQL 5.0.67 master/slave replication, and
recently I met with master/slave replication lag problem.
Is there a good monitoring tool or some other tools to detect and discover
this latency on slave?
Any suggestion is welcomed.
Thank you in advance
On Thu, May 22, 2008 at 5:36 PM, Salah Nait-Mouloud <
[EMAIL PROTECTED]> wrote:
> Hi all.
>
> I have 2 MySQL servers.
> One master and one slave.
> In order to add new slave server, and because i can't stop the master one,
> i
> have tried this:
>
> http://forums.mysql.com/read.php?26,99846,102058
Hi all.
I have 2 MySQL servers.
One master and one slave.
In order to add new slave server, and because i can't stop the master one, i
have tried this:
http://forums.mysql.com/read.php?26,99846,102058
"
*You don't have to modify the other slaves configuration. What you need to
do is obtain a sna
Hi Tom,
Your master binary log start with mysql-bin.03, then, your insert ( or
update) in the master could be in mysql-bin.02 or 1.
Please, reload your binary logs again from the beginning ( put
mysql-bin.02 or 1, ). Your insert or update could be in one of this
files.
Regards,
Juan
Yes thanks - i have done that and restarted the slave and _some_
tables now appear to update but others dont
eg
master:
mysql> select count(*) from tbl_checkcommand;
+--+
| count(*) |
+--+
| 30 |
+--+
1 row in set (0.00 sec)
slave:
mysql> select count(*) from
The error 1062 you could skipped in the slave modifying your my.cnf ( slave
side) using :
slave-skip-errors=1062
This error on duplicated records, normally is problem in binarylogs transfer
data. But, anyway, please confer that the data exist in the slave.
Yes thanks - i have done tha
Hi Tom,
The error 1062 you could skipped in the slave modifying your my.cnf ( slave
side) using :
slave-skip-errors=1062
This error on duplicated records, normally is problem in binarylogs transfer
data. But, anyway, please confer that the data exist in the slave.
Regards,
Juan
On Fri, May
Hi
I am running 4.1.20 as this is the stock version in RHEL4 u5 and i have
setup a master/slave combination. Updates at first appeared to work as
creating and inserting into the master created the db's on the slave
etc. I have noticed however that data in the master is not making its
way to t
ound out that my problem was that my firewall was not
> > allowing my to computers to talk to each other on port 3306. I use the
> > link you sent but this are th eoriginal links I used:
> > 1) Master/Slave replication
> >
> >
> > http://crazytoon.com/2008/01
g my to computers to talk to each other on port 3306. I use the
> > link you sent but this are th eoriginal links I used:
> > 1) Master/Slave replication
> >
> >
> > http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up-masterslave-replication-in-mysql-centos-rhel-f
I will try this tomorrow and let you know.
> > >
> > >
> > > Néstor :-)
> > >
> > >
> > >
> > > On Sun, Apr 6, 2008 at 10:52 PM, Kaushal Shriyan <
> > [EMAIL PROTECTED]>
> > > wrote:
> > > >
> > > >
> &
Kaushal,
That worked. I found out that my problem was that my firewall was not
allowing my to computers to talk to each other on port 3306. I use the
link you sent but this are th eoriginal links I used:
1) Master/Slave replication
http://crazytoon.com/2008/01/29/mysql-how-do-you-set-up
Am Montag, den 07.04.2008, 11:22 +0530 schrieb Kaushal Shriyan:
> is this a correct documentation
> http://howtoforge.com/mysql_master_master_replication for Master Slave
> Replication
No, it's not. As the title says, it describes Master-Master replication,
not Master-Slave replicat
t 10:52 PM, Kaushal Shriyan <[EMAIL PROTECTED]>
> > wrote:
> > >
> > >
> > >
> > > hi
> > >
> > > is this a correct documentation
> > > http://howtoforge.com/mysql_master_master_replication for Master Slave
> > &
AIL PROTECTED]>
wrote:
> hi
>
> is this a correct documentation
> http://howtoforge.com/mysql_master_master_replication for Master Slave
> Replication
>
> Thanks and Regards
>
> Kaushal
>
> --
> MySQL General Mailing List
> For list archives: http://li
hi
is this a correct documentation
http://howtoforge.com/mysql_master_master_replication for Master Slave
Replication
Thanks and Regards
Kaushal
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]
bruce wrote:
hi..
doing a simple test of master/slave replication, using mysql.
i have two test systems:
master - foo (192.168.10.13)
slave - cat (192.168.20.20)
on both machines, i created a testmasterdb. on the master, i populated the
tbl within the db with some test data. there are no
hi..
doing a simple test of master/slave replication, using mysql.
i have two test systems:
master - foo (192.168.10.13)
slave - cat (192.168.20.20)
on both machines, i created a testmasterdb. on the master, i populated the
tbl within the db with some test data. there are no tbls in the
From: B. Keith Murphy [mailto:[EMAIL PROTECTED]
> show slave status after it stops copying should give you some type of
> error information about the failure. What does it show?
In addition to the error, what do the following fields show?
Slave_IO_Running
Slave_SQL_Running
Seconds_Behind_Mast
Ryan,
show slave status after it stops copying should give you some type of
error information about the failure. What does it show?
Keith
Ryan Klein wrote:
I am having an issue that I cannot determine the cause. We have a
master server that is actually a production server and a slave server
I am having an issue that I cannot determine the cause. We have a master server
that is actually a production server and a slave server that is a fall back but
after around 10 days, it stops coping data and the servers fall out of sync.
Here is my my.cnf file for the master server:
key_buffer
At 14:11 -0400 10/18/03, DePhillips, Michael P wrote:
Hi List
I'm having trouble start a slave. All seems to be configured well as per
show slave status, I issue a
mysql> slave start;
Query OK, 0 rows affected (0.00 sec)
and nothing happens, show slave status sill says slave is not running.
Any
Hi List
I'm having trouble start a slave. All seems to be configured well as per
show slave status, I issue a
mysql> slave start;
Query OK, 0 rows affected (0.00 sec)
and nothing happens, show slave status sill says slave is not running.
Any insght??
Thanks
mike
--
MySQL General Mailing Li
ave is
connected waiting for binlog updates.
Make sure the master is replicating..
Etc.
-->-Original Message-
-->From: Sanya Shaik [mailto:[EMAIL PROTECTED]
-->Sent: Thursday, August 21, 2003 12:51 PM
-->To: [EMAIL PROTECTED]
-->Subject: Master-Slave Replication
-->
-->Hi
TECTED]
-->Sent: Thursday, August 21, 2003 12:51 PM
-->To: [EMAIL PROTECTED]
-->Subject: Master-Slave Replication
-->
-->Hi all,
-->
--> Thanks for the answers for Master-Master replication. Right now i
want
-->to try the Master-Slave replication first and the
Here is a good URL, maybe it can help you to deploy your Master-Slave
solution.
URL: http://mysql.us.themoes.org/doc/en/Replication_HOWTO.html
Greetings
Mikel
From: Sanya Shaik <[EMAIL PROTECTED]>
To: [EMAIL PROTECTED]
Subject: Master-Slave Replication Date: Thu, 21 Aug 2003 12:50:31
Hi all,
Thanks for the answers for Master-Master replication. Right now i want to try the
Master-Slave replication first and then do a circular replication.
Unfortunately, I am facing problems with updating slave automatically.
I started the slave and loaded the data from the master
On Sat, Apr 27, 2002 at 07:40:51PM -, [EMAIL PROTECTED] wrote:
> Hi Jeremy,
>
> you wrote:
>
> > If you send the traffic thru an ecnrypted tunnel, such as with SSH,
> > you'll get decent compression and security to boot! :-)
>
> Yep, that's a bright idea in fact... I wanted to make sure tha
Hi Jeremy,
you wrote:
> If you send the traffic thru an ecnrypted tunnel, such as with SSH,
> you'll get decent compression and security to boot! :-)
Yep, that's a bright idea in fact... I wanted to make sure that we didn't
already have that feature built-in.
Now I am just curious to know if t
On Sat, Apr 27, 2002 at 04:28:27PM -, [EMAIL PROTECTED] wrote:
> Hi there,
>
> I am wondering if there's a way of estabilishing a compressed link
> between a master and slave mysql servers. I know that a compressed
> client-server protocol exists. Do we have anything similar for
> replicati
Hi there,
I am wondering if there's a way of estabilishing a compressed link between
a master and slave mysql servers.
I know that a compressed client-server protocol exists.
Do we have anything similar for replication?
When replicated data is mostly text, such an option would save a lot of
time,
70 matches
Mail list logo
