daily pastebin goal
67%
SHARE
TWEET

my.cnf for 48G Linode Fabric Percona 5.6

a guest May 13th, 2015 244 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. [mysql]
  2.  
  3. # CLIENT #
  4. port                            = 3306
  5. socket                          = /var/lib/mysql/mysql.sock
  6.  
  7. [mysqld]
  8.  
  9. # GENERAL #
  10. user                            = mysql
  11. default-storage-engine          = InnoDB
  12. socket                          = /var/lib/mysql/mysql.sock
  13. pid-file                        = /var/lib/mysql/mysql.pid
  14.  
  15. #Connection timeout
  16. wait_timeout                    = 600
  17. interactive_timeout             = 600
  18.  
  19. # MyISAM #
  20. key-buffer-size                 = 32M
  21. myisam-recover                  = FORCE,BACKUP
  22.  
  23. # SAFETY #
  24. max-allowed-packet              = 16M
  25. max-connect-errors              = 1000000
  26. sysdate-is-now                  = 1
  27. innodb                          = FORCE
  28.  
  29. # DATA STORAGE #
  30. datadir                         = /var/lib/mysql/
  31.  
  32. # BINARY LOGGING #
  33. log-bin                         = /var/lib/mysql/mysql-bin
  34. expire-logs-days                = 14
  35. sync-binlog                     = 1
  36.  
  37. # REPLICATION #
  38. server-id                       = 34
  39. read-only                       = 0
  40. #skip-slave-start               = 1
  41. log-slave-updates               = 1
  42. relay-log                       = /var/lib/mysql/relay-bin
  43. slave-net-timeout               = 60
  44. sync-master-info                = 1
  45. sync-relay-log                  = 1
  46. sync-relay-log-info             = 1
  47.  
  48. #temporary for fabric prep dat acleanup
  49. #slave-skip-errors              = 1032
  50.  
  51. #binlog-do-db                   = serpsalpha
  52. binlog-format                   = 'ROW'
  53.  
  54. #Fabric:
  55. #skip-slave-start (=0), binlog-do-db (empty), & binlog-format (ROW) above are changed for Fabric.
  56. #additionally, sync-master-info must be on for Fabric, and the following:
  57. gtid-mode                       = 'ON'
  58. enforce-gtid-consistency        = 'ON'
  59. simplified_binlog_gtid_recovery = 'ON'  #Note: this variable has been changing name a lot. It can fail under special circumstances. See details at http://v.gd/2XcOhf
  60. master-info-repository          = TABLE
  61. relay-log-info-repository       = TABLE
  62. #report-host=   might want to set this for fabric
  63. #report-port    #no need to set, as it's reported correctly as of 5.5 or 5.6...
  64.  
  65. # CACHES AND LIMITS #
  66. tmp-table-size                  = 32M
  67. max-heap-table-size             = 32M
  68. query-cache-type                = 0
  69. query-cache-size                = 0
  70. max-connections                 = 500
  71. thread-cache-size               = 50
  72. open-files-limit                = 65535
  73. table-definition-cache          = 1024
  74. table-open-cache                = 55
  75.  
  76. # INNODB #
  77. innodb-flush-method             = O_DIRECT
  78. innodb-log-files-in-group       = 2
  79. innodb-log-file-size            = 512M
  80. innodb-flush-log-at-trx-commit  = 2
  81. innodb-file-per-table           = 1
  82. innodb-buffer-pool-size         = 40G
  83. innodb-rollback-on-timeout      = ON
  84. transaction-isolation           = READ-COMMITTED
  85. low-priority-updates            = 1
  86.  
  87. # LOGGING #
  88. log-error                       = /var/log/mysql/mysql-error.log
  89. log-queries-not-using-indexes   = 0
  90. slow-query-log                  = 1
  91. slow-query-log-file             = /var/log/mysql/mysql-slow.log
  92. long-query-time                 = 10
RAW Paste Data
We use cookies for various purposes including analytics. By continuing to use Pastebin, you agree to our use of cookies as described in the Cookies Policy. OK, I Understand
 
Top