… off by default with default size of 1MB while in MySQL 5.5 and before it was “ON” by default with query cache… operation (such as using MySQL on NFS file system). innodb_data_file_path got a small change with starting ibdata1 size raised from… sense in my opinion. MySQL 5.6 adds a lot more optimizer switches which you can play with: mysql [localhost] {msandbox} (test) > select…
Post: Using XtraBackup on NFS for MySQL backups
December 9, 2010 By 6 Comments
XtraBackup works great for backing MySQL up to an NFS volume, but there is a gotcha that you need to be aware of. This applies to anything you do with NFS, not just XtraBackup. The gotcha is that NFS uses client-side caching to reduce overhead…
Post: Storing MySQL Binary logs on NFS Volume
July 30, 2010 By 19 Comments
There is a lot of discussions whenever running MySQL storing data on NFS is a good idea. There is a lot of… issues in MySQL 5.0 rather than any NAS issues. This number was reachable even with binary log stored on NFS volume. This… behavior and if there is an NFS tuning which can be done to avoid it or if we need to fix MySQL
Comment: Why you don't want to shard.
August 7, 2009 By 34 Comments
… sharding for as long as possible. Recent development in the MySQL and File Systems point toward migration to ZFS hybrid storage… migrated to ZFS hybrid storage pool, although I disagree with the NFS methodology. Since NFS uses 10Gbit switches and adapters, which are about… JBODs on the ZFS NFS server too). I dream of one day you can run MySQL with perfect scalability with this machine setup: http…
Post: Making replication a bit more reliable
March 4, 2009 By 14 Comments
… with replication state (relay-log.info, master.info) are not synchronized on disk after each update, and even wrose – in case with NFS they are stored on client side OS/NFS cache for long time. As solution we… TransactionalReplication http://code.google.com/p/google-mysql-tools/wiki/TransactionalReplication patch and http://bugs.mysql.com/bug.php?id=34058 bug…
Post: Should MySQL and Web Server share the same box ?
October 16, 2006 By 9 Comments
… for each of methods. Smaller applications usually start with single server which has both MySQL and Web server on it. In this… disk less booting by NFS. So if using dedicated boxes is so great why to think about sharing MySQL and Web server… benefit of local access to MySQL is latency. This was problem many years ago with 10Mbit network but with 1Gbit networks being commodity…
Comment: Is MySQL 5.6 slower than MySQL 5.5?
February 18, 2013 By 23 Comments
… aligned with this. What I did is 367/331= 1.10876 which I rounded to 11% yes… Perhaps I should say MySQL… are relevant. Now regarding performance schema. I used MySQL Sandbox set up with MySQL 5.6 and 5.5 in their default settings… sandbox: [mysqld] user = root port = 5610 socket = /tmp/mysql_sandbox5610.sock basedir = /mnt/nfs/dist/5.6.10 datadir = /mnt/data/sandboxes…
Comment: Using LVM for MySQL Backup and Replication Setup
December 20, 2011 By 53 Comments
… a MySQL slave. Then you have oodles of space for online historical backups there. You could also share it as an NFS export to all the other MySQL slaves. There is also a utility called…. Just had a thought, maybe this idea could be combined with rsnapshot for space efficient backups using hard-links. Peter seemed…
Comment: Storing MySQL Binary logs on NFS Volume
August 2, 2010 By 19 Comments
… but the MySQL community has yet to implement a tool to archive binlogs (write them locally, archive them to NFS). That tool is easier to do with recent changes in mysqlbinlog and Harrison will…
Comment: Storing MySQL Binary logs on NFS Volume
July 31, 2010 By 19 Comments
Peter, Do you consider a Linux server having a MySQL data dir on NFS safe? I have no first hand interaction with such a setup and have read numerous ominous reports. I am curious if this is a recipe for disaster.
