Adam Majer
e4b2876888
- update to 10.2.12 GA
* release notes and changelog:
https://mariadb.com/kb/en/library/mariadb-10212-release-notes/
https://mariadb.com/kb/en/library/mariadb-10212-changelog/
- remove mysql-community-server-5.5.6-safe-process-in-bin.patch
becuase this moving is done in the specfile
- get rid of the archive with patches (remove mysql-patches.tar.xz
and series files), handle patches in the standard way
- add comments to the section with removing unused files (based on
https://lists.launchpad.net/maria-developers/msg11028.html)
- put rm statements together
- install the new upstream systemd-tmpfiles configuration file
'tmpfiles.conf' and rename it to 'mariadb.conf' in order to
follow the manual
- remove the new upstream systemd-sysusers configuration file as
we handle creating of mysql user in the specfile
- mysql.service: remove calling of the wait function and let
systemd to do this job. Switch from 'Type=simple' to
'Type=notify' and add TimeoutSec=300
- rename unit files from mysql to mariadb and add mysql alias for
the backward compatibility [bsc#1067443]
* mysql.service -> mariadb.service
* mysql.target -> mariadb.target
* mysql@.service -> mariadb@.service
- remove configuration-tweaks.tar.xz and move configuration to
my.ini/my.cnf file (omit default_plugins.cnf as all
configuration here was commented out)
- add a numeric prefix for galera.cnf file in order to allow users
to speficy in which order the configs will be loaded within the
my.cnf.d directory [bsc#1055268]
OBS-URL: https://build.opensuse.org/request/show/563119
OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=203
109 lines
3.6 KiB
INI
109 lines
3.6 KiB
INI
# The following options will be passed to all MariaDB clients
|
|
[client]
|
|
# Please note that storing the password in this file is not safe. For this
|
|
# purpose you can, for example, list your password in the [client] section
|
|
# of the '~/.my.cnf' configuration file with an access mode set to 400 or 600.
|
|
# password = your_password
|
|
# port = 3306
|
|
# socket = /run/mysql/mysql.sock
|
|
|
|
# The MariaDB server
|
|
[mysqld]
|
|
|
|
# For security reasons, bind to 127.0.0.1 by default to enable networking
|
|
# only on the loopback interface.
|
|
bind-address = 127.0.0.1
|
|
|
|
# If log-error is not set, mysqld will write to "/var/lib/mysql/$HOSTNAME.err"
|
|
# which is not beneficial for rotating the log file if it grows in size.
|
|
log-error = /var/log/mysql/mysqld.log
|
|
|
|
# Operations 'LOAD DATA', 'SELECT ... INTO' and 'LOAD FILE()' will only
|
|
# work with files in the specified directory
|
|
secure_file_priv = /var/lib/mysql-files
|
|
|
|
# Remove leading # and set to the amount of RAM for the most important data
|
|
# cache in MySQL. Start at 70% of total RAM for dedicated server, else 10%.
|
|
# innodb_buffer_pool_size = 128M
|
|
|
|
# Using newer file format that supports dynamic and compressed row formats.
|
|
# If you are using replication you have to make sure, that these options are
|
|
# set everywhere the same way (probably comment them out is the easiest way)
|
|
innodb_file_format=Barracuda
|
|
innodb_file_per_table=ON
|
|
|
|
# Remove leading # to turn on a very important data integrity option: logging
|
|
# changes to the binary log between backups.
|
|
# log_bin=mysql-bin
|
|
# binlog_format=mixed
|
|
|
|
# Remove leading # if you want to store your database elsewhere
|
|
# datadir = /var/lib/mysql
|
|
|
|
# required unique id between 1 and 2^32 - 1
|
|
# defaults to 1 if master-host is not set
|
|
# but will not function as a master if omitted
|
|
server-id = 1
|
|
|
|
# These are commonly set, remove the # and set as required.
|
|
# port = 3306
|
|
# socket = /run/mysql/mysql.sock
|
|
|
|
# Remove leading # to set options mainly useful for reporting servers.
|
|
# The server defaults are faster for transactions and fast SELECTs.
|
|
# Adjust sizes as needed, experiment to find the optimal values.
|
|
# join_buffer_size = 128M
|
|
# sort_buffer_size = 2M
|
|
# read_rnd_buffer_size = 2M
|
|
|
|
# Configure the MariaDB server to use SSL
|
|
# ssl-ca=/etc/mysql/ssl/ca-cert.pem
|
|
# ssl-cert=/etc/mysql/ssl/server-cert.pem
|
|
# ssl-key=/etc/mysql/ssl/server-key.pem
|
|
|
|
sql_mode=NO_ENGINE_SUBSTITUTION,STRICT_TRANS_TABLES
|
|
|
|
[mysqld_multi]
|
|
mysqld = /usr/bin/mysqld_safe
|
|
mysqladmin = /usr/bin/mysqladmin
|
|
log = /var/log/mysqld_multi.log
|
|
|
|
# If you want to use mysqld_multi uncomment 1 or more mysqld sections
|
|
# below or add your own ones.
|
|
|
|
# WARNING
|
|
# --------
|
|
# If you uncomment mysqld1 than make absolutely sure, that database mysql,
|
|
# configured above, is not started. This may result in corrupted data!
|
|
#
|
|
# [mysqld1]
|
|
# port = 3306
|
|
# datadir = /var/lib/mysql
|
|
# pid-file = /var/lib/mysql/mysqld.pid
|
|
# socket = /var/lib/mysql/mysql.sock
|
|
# user = mysql
|
|
|
|
# [mysqld2]
|
|
# port = 3307
|
|
# datadir = /var/lib/mysql-databases/mysqld2
|
|
# pid-file = /var/lib/mysql-databases/mysqld2/mysql.pid
|
|
# socket = /var/lib/mysql-databases/mysqld2/mysql.sock
|
|
# user = mysql
|
|
|
|
# [mysqld3]
|
|
# port = 3308
|
|
# datadir = /var/lib/mysql-databases/mysqld3
|
|
# pid-file = /var/lib/mysql-databases/mysqld3/mysql.pid
|
|
# socket = /var/lib/mysql-databases/mysqld3/mysql.sock
|
|
# user = mysql
|
|
|
|
# [mysqld6]
|
|
# port = 3309
|
|
# datadir = /var/lib/mysql-databases/mysqld6
|
|
# pid-file = /var/lib/mysql-databases/mysqld6/mysql.pid
|
|
# socket = /var/lib/mysql-databases/mysqld6/mysql.sock
|
|
# user = mysql
|
|
|
|
!includedir /etc/my.cnf.d
|
|
|