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
Thanks for the reply.
I didn't explain properly :)
A diagram should help:
||
|-| 1 || 2 | ||
|stage| --> |prod| --> |-| ||
|-| || |-|replicas|
||
'stage' is a staging mysql instance,
-->-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
mysql
-->server to a number o
