Hi Ross,
On Wed, 2003-06-04 at 16:35, Ross Simpson wrote:
> This sounds like the best idea yet :)
>
> I have a couple of questions:
>
> - I need to keep the data in x_shadow while still creating table x..
> will copying accomplish the same thing? I'm guessing it will be slower,
> but keeping t
ansfer personally...)
>
> Hope this helps...
>
> Andrew
>
>
>
> -Original Message-
> From: Ross Simpson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday 03 June 2003 23:57
> To: Andrew Braithwaite
> Cc: Dathan Vance Pattishall; [EMAIL PROTECTED]
> Subjec
This sounds like the best idea yet :)
I have a couple of questions:
- I need to keep the data in x_shadow while still creating table x..
will copying accomplish the same thing? I'm guessing it will be slower,
but keeping the 'shadow' table around is important.
- Will either / both of these (r
On Tue, 2003-06-03 at 22:44, Ross Simpson wrote:
> Thanks for the reply.
>
> I didn't explain properly :)
>
> A diagram should help:
>
>||
> |-| 1 || 2 | ||
> |stage| --> |prod| --> |-| ||
> |-| || |-|replicas|
>
7
To: Andrew Braithwaite
Cc: Dathan Vance Pattishall; [EMAIL PROTECTED]
Subject: RE: table copying/replication
I looked at that type of idea, and the reason I didn't mention it was the
indexes -- each table involved has ~5 indexes, and on a large table, that
equals a lot of work that's a
>
> Cheers,
>
> Andrew
> multimap.com
>
>
> -Original Message-
> From: Ross Simpson [mailto:[EMAIL PROTECTED]
> Sent: Tuesday 03 June 2003 22:44
> To: Dathan Vance Pattishall
> Cc: [EMAIL PROTECTED]
> Subject: RE: table copying
Sent: Tuesday 03 June 2003 22:44
To: Dathan Vance Pattishall
Cc: [EMAIL PROTECTED]
Subject: RE: table copying/replication
Thanks for the reply.
I didn't explain properly :)
A diagram should help:
||
|-| 1 || 2 | ||
|stage| --> |prod| --&g
Simpson [mailto:[EMAIL PROTECTED]
> -->Sent: Tuesday, June 03, 2003 10:31 AM
> -->To: [EMAIL PROTECTED]
> -->Subject: table copying/replication
> -->
> -->Hello,
> -->
> -->I have a need for fast copying of a specific table from a master
> mysql
> -->s
-->-Original Message-
-->From: Ross Simpson [mailto:[EMAIL PROTECTED]
-->Sent: Tuesday, June 03, 2003 10:31 AM
-->To: [EMAIL PROTECTED]
-->Subject: table copying/replication
-->
-->Hello,
-->
-->I have a need for fast copying of a specific table from a master
Hello,
I have a need for fast copying of a specific table from a master mysql
server to a number of slave servers (say 5).
The database in question could potentially have up to 2000 tables, and
at any time, one of those tables would need to be copied to all 5 of the
slaves, upon command of the ma
10 matches
Mail list logo
