…access this information by calling mysqld with option: mysqld –wsrep-recover and having this information,…mysqld daemon with databases from /mnt/data/mysql 130129 23:01:22 mysqld_safe WSREP:… Oy
Post: Feature in details: Incremental state transfer after a node crash in Percona XtraDB Cluster
January 31, 2013 By 2 Comments
Post: Pacemaker, please meet NDB Cluster or using Pacemaker/Heartbeat to start a NDB Cluster
May 19, 2010 By 10 Comments
…2 sets of scripts to manage NDB startup, ndb-initializer and from Johan configurator www.severalnines.com. …to Pacemaker recently, a Clone resources set, that allows an optional startup if only one of 2 …mgmd #!/bin/bash /usr/bin/nohup /usr/local/mysql/libexec/ndb_mgmd > /dev/null & while [ 1 ] do…
Post: Using MyISAM in production
June 17, 2006 By 36 Comments
… comming from “traditional” databases you’re likely to be shocked by MyISAM behavior (and default MySQL …to adjust that or you can simply set low_priority_updates option. Anyway default behavior means any …danger if MySQL Server crashes or power goes down. In case crash happens without this option is …
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… helped dealing with performance problems (part MySQL related and part related to LAMP in general)… TTL Settings The system was using DNS based load balancing, using something like img23.domain.com to …and should not be mixed. Use noatime mount option Serving images you rarely need last access time…
Post: Percona Toolkit Webinar followup Q&A
December 19, 2012 By 1 Comment
… url like this: http://www.percona.com/get/
Post: TMP_TABLE_SIZE and MAX_HEAP_TABLE_SIZE
January 19, 2007 By 17 Comments
… support them Right ? Wrong. In fact setting tmp_table_size is not enough as MySQL also looks at max_heap_table_size… what you would read in MySQL manual as far as I understand it: From http://dev.mysql.com/doc/refman/5.0/en…:00, ted@ted.mysql.internal +6 -0 BUG #4291 fix: new configuration option “disk-tmp-table-size” introduced to set maximum expected on…
Comment: The ultimate tool for generating optimal my.cnf files for MySQL
August 20, 2008 By 34 Comments
… settings are bad to use? Most likely using 1GB as readbuffer for a general mysql server is far worse than having it set… my.cnf which comes with mysql is that those figures doesnt seem to reflect recommendations from mysql.com themselfs. Even if there are special cases where 1GB readbuffer might be a better option I believe that optimal options for…
Comment: Migrating to XtraDB Cluster Webinar follow up questions
June 6, 2012 By 3 Comments
… only 2 nodes. With the default settings, if one node goes away, also…you can use the pc.ignore_sb option. With that enabled, if you have network… you have with MySQL replication, but Galera is still better than MySQL replication so … Codership in doing this: http://fromdual.com/mpm-0-9-is-out Also …
Post: Heikki Tuuri answers to Innodb questions, Part II
November 4, 2007 By 13 Comments
… to play with read-ahead depth here. These settings mean there can be quite significant stall waiting… was only recently found and fixed: http://bugs.mysql.com/bug.php?id=29560 Concerning a switch to … rest to the OS cache? Is there special options or tricks that should be implemented on larger …
Post: Copying InnoDB tables between servers
July 31, 2009 By 11 Comments
…time ago http://www.mysqlperformanceblog.com/2009/06/08/impossible-possible…option “export” xtrabackup –defaults-file=/etc/my.reg.cnf –prepare –export –use-memory=8G –target-dir=/data/vadim/mysql… xtrabackup: Temporary instance for recovery is set as followings. xtrabackup: innodb_data_home_dir =…
