Advertisement
Guest User

Untitled

a guest
Dec 10th, 2013
80
0
Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
text 1.07 KB | None | 0 0
  1. [mysqld]
  2.  
  3. datadir=/var/lib/mysql
  4. user=mysql
  5. log_error=error.log
  6. # Path to Galera library
  7. wsrep_provider=/usr/lib64/libgalera_smm.so
  8. innodb_doublewrite=0
  9. # Cluster connection URL contains the IPs of node#1, node#2 and node#3
  10. wsrep_cluster_address=gcomm://192.168.1.202,192.168.1.203,192.168.1.204
  11.  
  12. # In order for Galera to work correctly binlog format should be ROW
  13. binlog_format=ROW
  14.  
  15. # MyISAM storage engine has only experimental support
  16. default_storage_engine=InnoDB
  17.  
  18. # This is a recommended tuning variable for performance
  19. innodb_locks_unsafe_for_binlog=1
  20. innodb_buffer_pool_size=3G
  21. # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera
  22. innodb_autoinc_lock_mode=2
  23.  
  24. # Node #1 address
  25. wsrep_node_address=192.168.1.202
  26.  
  27. # SST method
  28. wsrep_sst_method=rsync
  29.  
  30. # Cluster name
  31. wsrep_cluster_name=my_centos_cluster
  32.  
  33. # Authentication for SST method
  34. wsrep_sst_auth="sstuser:s3cret"
  35.  
  36. slow_query_log=1
  37. slow_query_log_file=/var/lib/mysql/slow.log
  38. long_query_time=10
  39. #log_slow_rate_limit = 1000
  40. log_slow_verbosity=query_plan
Advertisement
Add Comment
Please, Sign In to add comment
Advertisement