Many users of MySQL install and use the standard directories for MySQL data and binary logs. Generally this is /var/lib/mysql.
As your system grows and you need more disk space on the general OS partition that commonly holds /tmp, /usr and often /home, you create a dedicated partition, for example /mysql. The MySQL data, binary logs etc are then moved to this partition (hopefully in dedicated directories). For example data is placed in /mysql/data.
Often however, a symbolic link (symlink) is used to so MySQL still refers to the data in /var/lib/mysql.
MySQL 5.6 is GA! Now we have new things to play with and in my personal opinion the most interesting one is the new Global Transaction ID (GTID) support in replication. This post is not an explanation of what is GTID and how it works internally because there are many documents about that:
The deadline is fast approaching to submit proposals for the Birds of a Feather Sessions (BOFs) and the Lightning Talks (presented during the Wednesday Evening Networking Reception) for the Percona Live MySQL Conference and Expo 2013.
MySQl 5.6.10 is easily buildable from source code. In an earilier post I discussed the differences in using pre-packaged builds versus binaries bersus source code and had a few readers ask for details on building from scratch.
Step 1 — Download the source code from http://dev.mysql.com. Once again, you have the options of packages like RPM or a tar ball. In the following steps I usedthe good ol’ tar ball.
Multi-Threaded SlaveMySQL 5.6 has now been declared Generally Available (i.e. suitable for production use). This is a very exciting release from a MySQL replication perspective with some big new features. These include:
Percona Live 2013 is shortly upon us, and it might be a good idea to watch for what's ahead of us.
Talks of interest
There is no way I can do justice to all. I wish to point out a small number of sessions I am personally interested in attending. I will not be able to attend them all, since there are too many sessions of interest and too few instances of myself (merely one).