The MySQL Runtime team is look for Windows Server developers. Windows is a very important platform for MySQL and we need good folks to help drive the product forward.
There are about a gazillion FAQs and HOWTOs out there that talk about XFS configuration, RAID IO alignment, and mount point options. I wanted to try to put some of that information together in a condensed and simplified format that will work for the majority of use cases. This is not meant to cover every single tuning option, but rather to cover the important bases in a simple and easy to understand way.
Let’s say you have a server with standard hardware RAID setup running conventional HDDs.
Statement based replication writes the queries that modify data in the Binary Log to replicate them on the slave or to use it as a PITR recovery. Here we will see what is the behavior of the MySQL when it needs to log “not usual” queries like Events, Functions, Stored Procedures, Local Variables, etc. We’ll learn what problems can we have and how to avoid them.
SCaLE 10X is the premier Open Source show in Southern California. This year it will feature a MySQL day with top speakers from the MySQL Community. Volunteers run SCaLE and do such an amazing job that they charge only $60 for a full pass. If you are anywhere near Southern California January 20th to the 22nd, you need to be at SCaLE.
Normally I write for the MySQL DBA audience. But this blog entry is different. Print out a hard copy and hand it to friends and family when they ask you what sort of presents you want for Christmas, Hanukkah, Festivus or other end of the year gift exchange instead of grunting ‘I do not know1‘ and ending up with something you will have to pretend to like.