Hi,
I've spent the last few days trying to set up basic Master > Slave
replication with auto-backup on the Slave:
Xserve G5 (10.4.11 Server) --> PowerMac G5 (10.5.8 Client)
-- Both running MySQL 5.1.39 64-bit PowerPC
I've followed the docs and several online articles meticulously, and
go
Mike,
What behaviour you experience depends to some extent on what storage engine
you are using and on what other non-unique indexes you have on the tables.
With LOAD DATA INFILE on empty MyISAM tables all non-unique indexes are
created in a separate batch which makes it much faster if you have a
Hello,
I have a Python application that is using MySQL to store records of
transactions about 3 tables with ~1k records each.
How can I periodically copy the records off the production on to an "archive
server"? I would like to this for two reasons:
1) To run data-mining queries on a cop
Have a look at the Merge engine.
On Sun, Oct 18, 2009 at 10:31 PM, Allen Fowler wrote:
> Hello,
>
> I have a Python application that is using MySQL to store records of
> transactions about 3 tables with ~1k records each.
>
> How can I periodically copy the records off the production on to an
