List:Bugs« Previous MessageNext Message »
From:sasha Date:September 25 2000 3:26pm
Subject:Re: More on replication ..
View as plain text  
Benjamin Pflugmann wrote:
> 
> Hi.
> 
> On Wed, Sep 13, 2000 at 11:03:57AM +0300, monty@stripped wrote:
> [...]
> > How about if the slave would when it starts to replicate request that
> > all other replications from that slave should be killed?
> >
> > That would be easy to do (at least on Unix);  Just do a
> > thr_alarm_kill() on all slave threads that comes from the same
> > hosts.
> 
> Maybe I am misunderstanding you, but IMHO the specification must be
> more precise than just 'hostname', since one could run several mysqlds
> on one host and therefore several slaves on the same host.
> 
> We have an 'own' database and a 'customer' one running on the same
> host (the reason is that the customer one has far more restrictive
> settings to protect the server against relative 'beginners'). If we
> would chose to replicate both to another server, we would run across
> the above problem.

Benjamin:

You are correct - a slave cannot be identified just by host/username pair. One
needs to introduce server id for this, which we plan to do in 3.23.26.

-- 
Sasha Pachev

+------------------------------------------------------------------+
|      ____  __     _____   _____  ___     http://www.mysql.com    |
|     /*/\*\/\*\   /*/ \*\ /*/ \*\ |*|     Sasha Pachev            |
|    /*/ /*/ /*/   \*\_   |*|   |*||*|     sasha@stripped         |
|   /*/ /*/ /*/\*\/*/  \*\|*|   |*||*|     Provo, Utah, USA        |
|  /*/     /*/  /*/\*\_/*/ \*\_/*/ |*|____                         |
|  ^^^^^^^^^^^^/*/^^^^^^^^^^^\*\^^^^^^^^^^^                        |
|             /*/             \*\ Developers Team                  |
+------------------------------------------------------------------+
Thread
More on replication ..Weslee Bilodeau8 Sep
  • Re: More on replication ..sasha10 Sep
    • Re: More on replication ..Thimble Smith11 Sep
  • Re: More on replication ..sasha12 Sep
  • Re: More on replication ..sasha13 Sep
    • RE: More on replication ..Weslee Bilodeau13 Sep
      • RE: More on replication ..Michael Widenius13 Sep
    • Re: More on replication ..Michael Widenius13 Sep
      • Re: More on replication ..Benjamin Pflugmann24 Sep
  • Re: More on replication ..sasha25 Sep
  • Re: More on replication ..sasha5 Oct