another replication question..

re db? My slaves will be read-only dbs in a production environment with a lot of traffic, so I need to insure that they can always serve requests. Thanks, Ross -- Ross Simpson <[EMAIL PROTECTED]> MapQuest.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysq

RE: table copying/replication

> > --add-drop-table option to mysqldump like this: > > > > mysqldump --add-drop-table -e -hstage -usomeuser somedatabasename | > > mysql -hprod -usomeuser > > > > This will then replicate as fast as your network/hardware will allow. > > > > Ho

RE: table copying/replication

ight be impractical depending on the amount of data involved. > > regards, > Martin -- Ross Simpson <[EMAIL PROTECTED]> MapQuest.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]

RE: table copying/replication

as your network/hardware will allow. > > Hope this helps.. (I'm all for open source but it's a bit weird that I'm > helping out our state-side mapping competitors here - at least it's not > microsoft - I'll check tomorrow to make sure I don't get sacked :)

RE: table copying/replication

My need is that somehow a table already existing on stage can be copied/replicated/etc over to prod, but _only_ when requested, and then immediately. Any thoughts? Thanks, Ross On Tue, 2003-06-03 at 12:07, Dathan Vance Pattishall wrote: > -->-Original Message- > -->From: Ross

table copying/replication

nyone solved this problem before? Any ideas that would help out? Thanks! Ross -- Ross Simpson <[EMAIL PROTECTED]> MapQuest.com -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe:http://lists.mysql.com/[EMAIL PROTECTED]