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
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
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
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
