Replication and table locking

2001-10-26 Thread Jon Gardiner
Hello all, We are doing a lot of data warehousing type work. The catch is we need to get data back out in seconds rather than minutes. To accomplish this we generate summary tables in real time. The problem we run into is that generating the summary tables becomes very costly and our sele

Re: Replication and table locking

2001-09-24 Thread Benjamin Pflugmann
Hi. On Sat, Sep 22, 2001 at 03:38:45PM +0200, [EMAIL PROTECTED] wrote: > > I have some questions about MySQL replication and table locking: > 1. If I lock a table on the master server, the table will be locked on > the slave server? It will be locked whenever the slave get

Replication and table locking

2001-09-22 Thread Thomas Jalsovsky
Hello I have some questions about MySQL replication and table locking: 1. If I lock a table on the master server, the table will be locked on the slave server? 2. If I use replication, the locking queues are the same on both servers? 3. If my master fails (or I turn off the server) and