MySQL logging server how can i 'log rotate' all the data
I'm looking for a decent method of rotating data in a MySQL table that has log files piped into it from a few different servers. Basically one of the most important things is that the table or MySQL doesn't stop running so that the servers logging to it are always able to connect and send any log message to the MySQL database, 24/7. I'd like to be able to archive off the logs for a date and also every so often run a clean down of the table. My thoughts were a mysqldump with a where clause in it to specify the date range, and then to clean out the table every so often to truncate the table. Basically i need to make sure i don't loose any data at the times of this happening so does this sound like a good method or are there other methods that may be better.