Multiple masters to 1 slave??

I'm trying to find a way to set up an off-site replication (slave 3). In house I have several MySQL 4.0 servers that are using replication. They consist of 1 master (master1) for all data, 1 slave (slave 1) for optimized web access and 1 slave (slave 2) for the internal database app. Both slave

Select statement locking tables in the from clause....

Hi all, We have just finished developing and application in C++ that uses a mysql 3.23.52 database on Linux. It went into productions this morning and now we are having problems with multiple select statements. When one user runs a very learge select query, it locks the tables involved so no