SHARE
TWEET

Untitled

a guest Oct 30th, 2018 78 Never
Not a member of Pastebin yet? Sign Up, it unlocks many cool features!
  1. # This is default example of MariaDB configuration provided with SLE package
  2. # It is based on upstream defaults with some additional examples.
  3.  
  4.  
  5. # The following options will be passed to all MariaDB clients
  6. [client]
  7. # password  = your_password
  8. # port       = 3306
  9. # socket     = /var/run/mysql/mysql.sock
  10.  
  11. [mysqld]
  12. # Remove leading # if you don't want to listen on network (only socket - safer)
  13. # skip-networking
  14.  
  15. # Remove leading # and set to the amount of RAM for the most important data
  16. # cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
  17. # innodb_buffer_pool_size = 128M
  18. #bind-address = 127.0.0.1
  19.  
  20. # Using newer file format that supports dynamic and compressed row formats.
  21. # If you are using replication you have to make sure, that these options are
  22. # set everywhere the same way (probably comment them out is the easiest way)
  23. innodb_file_format=Barracuda
  24. innodb_file_per_table=ON
  25.  
  26. # Remove leading # to turn on a very important data integrity option: logging
  27. # changes to the binary log between backups.
  28. # log_bin=mysql-bin
  29. # binlog_format=mixed
  30.  
  31. # Remove leading # if you want to store your database elsewhere
  32. # datadir   = /var/lib/mysql
  33.  
  34. # required unique id between 1 and 2^32 - 1
  35. # defaults to 1 if master-host is not set
  36. # but will not function as a master if omitted
  37. server-id   = 1
  38.  
  39. # These are commonly set, remove the # and set as required.
  40. # port = 3306
  41. # socket = /var/run/mysql/mysql.sock
  42.  
  43. # Don't listen on a TCP/IP port at all. This can be a security enhancement,
  44. # if all processes that need to connect to mysqld run on the same host.
  45. # All interaction with mysqld must be made via Unix sockets or named pipes.
  46. # Note that using this option without enabling named pipes on Windows
  47. # (via the "enable-named-pipe" option) will render mysqld useless!
  48. #
  49. # skip-networking
  50.  
  51. # Remove leading # to set options mainly useful for reporting servers.
  52. # The server defaults are faster for transactions and fast SELECTs.
  53. # Adjust sizes as needed, experiment to find the optimal values.
  54. # join_buffer_size = 128M
  55. # sort_buffer_size = 2M
  56. # read_rnd_buffer_size = 2M
  57.  
  58. sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
  59.  
  60. [mysqld_multi]
  61. mysqld     = /usr/bin/mysqld_safe
  62. mysqladmin = /usr/bin/mysqladmin
  63. log        = /var/log/mysqld_multi.log
  64.  
  65. [mysqld]
  66. mysql.connecttimeout = 300
  67. defaultsocket_timeout = 300
  68. max_allowed_packet=500M
  69. wait_timeout=800
  70.  
  71. # If you want to use mysqld_multi uncomment 1 or more mysqld sections
  72. # below or add your own ones.
  73.  
  74. # WARNING
  75. # --------
  76. # If you uncomment mysqld1 than make absolutely sure, that database mysql,
  77. # configured above, is not started.  This may result in corrupted data!
  78. #
  79. # [mysqld1]
  80. # port       = 3306
  81. # datadir    = /var/lib/mysql
  82. # pid-file   = /var/lib/mysql/mysqld.pid
  83. # socket     = /var/lib/mysql/mysql.sock
  84. # user       = mysql
  85.  
  86. # [mysqld2]
  87. # port       = 3307
  88. # datadir    = /var/lib/mysql-databases/mysqld2
  89. # pid-file   = /var/lib/mysql-databases/mysqld2/mysql.pid
  90. # socket     = /var/lib/mysql-databases/mysqld2/mysql.sock
  91. # user       = mysql
  92.  
  93. # [mysqld3]
  94. # port       = 3308
  95. # datadir    = /var/lib/mysql-databases/mysqld3
  96. # pid-file   = /var/lib/mysql-databases/mysqld3/mysql.pid
  97. # socket     = /var/lib/mysql-databases/mysqld3/mysql.sock
  98. # user       = mysql
  99.  
  100. # [mysqld6]
  101. # port       = 3309
  102. # datadir    = /var/lib/mysql-databases/mysqld6
  103. # pid-file   = /var/lib/mysql-databases/mysqld6/mysql.pid
  104. # socket     = /var/lib/mysql-databases/mysqld6/mysql.sock
  105. # user       = mysql
  106.  
  107. !includedir /etc/my.cnf.d
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
Not a member of Pastebin yet?
Sign Up, it unlocks many cool features!
 
Top