Shawn,
Very Interesting idea. I definitely want to look into this a bit more.
I fear though that the bin-logs might be written first to disk before they are copied over to the replicas.
Another member of my team mentioned there might be a way to issue direct MyISAM table INSERTS. She suggested that we could bypass the parsing and param checking of our large string-based INSERT queries.
Since our sampling application can guarantee the inputs on the INSERT, this would offer us a potential performance boost as there is no reason for MySQL to verify our INSERT query inputs a second time.
Does anyone know if the direct table/index insert idea is valid?
At 09:43 AM 6/29/04, you wrote:
Could Alejandro re-use the sections of the MySQL source code that handle replication and bin-logging to make his data capture application appear as a "Master" server and have his MySQL database act as its slave?
-- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]