MySQL implementation of Oracle sequences

2004-10-15 Thread Kenneth Lim
ately. This approach seems to create a bottleneck also. But I would imagine this approach is more costly than solution #1. 3- Redo our semantics by replacing our insert statements and allowing AUTO_INCREMENTed columns to keep the IDs unique. Thanks for you feedback. -ken Kennet

Replication and LOAD DATA LOCAL INFILE

2004-10-12 Thread Kenneth Lim
ssages above. The data seems to be the same on master and slave. Are there special considerations for using LOAD DATA LOCAL INFILE statements with a replication setup? Thanks. -ken Kenneth Lim Software Engineer Senvid, Inc. 2445 Faber Place, Suite #200 Palo Alto, CA 94303 phone: 650-354-3