Brian Moon suggest that community provided example my.cnf files would be a great thing to have on MySQLforge in this recent post: http://doughboy.wordpress.com/2008/05/06/example-mycnf-files/
I pulled out the "innodb heavy" config sample file and modified it with the standard settings that I typically start with when setting up a new InnoDB master. I've also modified the comments in the file a bit and have added some of my own too. I removed the sample slave configuration parameters (master-host, etc) because you should be using 'CHANGE MASTER TO'.
He suggested tagging such files with a 'mycnf' tag and very kindly tagged mine after I posted it :)
Feel free to share yours too and please feel free to make any comments about my configuration choices.
You can find it here (along with any [Read more...]