Re: Replication:many masters,one centralized slave

[Claudio Jose Zanardi Grillo <suppressed>]

Can we have multiple mysql instances acessing the same database ?(Or sharing
the  same memory blocks, locks controls ...)


Claudio Grillo

Citando Rafal Jank <suppressed>:

> Dnia Tue, 20 May 2003 10:22:31 -0300
> Claudio Jose Zanardi Grillo <suppressed> zezna³/a co nastêpuje:
> 
> > Hi,
> > 
> > How can we set up a replication with many masters and one slave ,with
> > a centralized database that contains all the data of the masters - the
> > tables have something like a vertical partition scheme ( it is impossible
> to
> > insert the same row in two  diferent masters).
> > 1. Can we have
> > many slave threads:One for each diferent master ? Semething like:
> > START SLAVE masters_name 
> > 2.Only remote applying the binary logs from the masters would work,but
> > we have INSERT LOAD_FILE commands...What to do?
> > 
> The only solution is to have multiple mysql instances, each replicating from
> different master
> 
> 
> 
> sql
> -- 
> _/        _/  _/_/_/  -----     Rafa³ Jank suppressed     -----
>  _/  _/  _/  _/   _/         Wirtualna Polska SA   http://www.wp.pl 
>   _/_/_/_/  _/_/_/    ul. Traugutta 115c, 80-237 Gdansk, tel/fax.
> (58)5215770
>    _/  _/  _/         --------==*  http://szukaj.wp.pl *==----------
> 
> -- 
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:    http://lists.mysql.com/suppressed
> 
> 




--------------------------------------------------------
Este e-mail foi enviado pelo IMP: http://horde.org/imp/

-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/suppressed