Hello.


Replication should work with MERGE tables. You may make a test

setup and check your scenario.







Eric Anderson <[EMAIL PROTECTED]> wrote:

> 

> Here's a question for you guys: is it possible to have a replicated 

> table of type MERGE?

> 

> Scenario:

> 

> Server: WWW1

> Table: A.local_table (MASTER)

> 

> replicates to:

> 

> Server: MEMBERS

> Table: B.www1 (SLAVE)

> 

> and

> 

> Server: WWW2

> Table: A.local_table (MASTER)

> 

> replicates to:

> 

> Server: MEMBERS

> Table: B.www2 (SLAVE)

> 

> where B.www1 and B.www2 are type MERGE?

> 

> Then I could a SELECT on the type merge (B.www1,B.www2,etc)?  Possible? 

> The more I look at it, the more complicated it looks.  (sigh)

> 



-- 
For technical support contracts, goto https://order.mysql.com/?ref=ensita
This email is sponsored by Ensita.NET http://www.ensita.net/
   __  ___     ___ ____  __
  /  |/  /_ __/ __/ __ \/ /    Gleb Paharenko
 / /|_/ / // /\ \/ /_/ / /__   [EMAIL PROTECTED]
/_/  /_/\_, /___/\___\_\___/   MySQL AB / Ensita.NET
       <___/   www.mysql.com




-- 
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/[EMAIL PROTECTED]

Reply via email to