forked from pool/mariadb
cc8871cde2
- Add mariadb-10.1.22-xtradb_null_checks.patch (boo#1041525) (See also https://jira.mariadb.org/browse/MDEV-12358) - switch from '/var/run' to '/run' as /var/run is just a symlink to /run - fix permissions for /var/run/mysql that were wrongly set to 700 instead of 755 due to added umask. This prevented non-root from connecting to the database [bsc#1038740] - change permissions of the configuration dir/files to 755/644. Please note that storing the password in the /etc/my.cnf file is not safe. Use for example an option file that is accessible only by yourself [bsc#889126] - set the default umask to 077 in mysql-systemd-helper [bsc#1020976] OBS-URL: https://build.opensuse.org/request/show/499775 OBS-URL: https://build.opensuse.org/package/show/server:database/mariadb?expand=0&rev=191
58 lines
1.9 KiB
Plaintext
58 lines
1.9 KiB
Plaintext
Notes about MySQL 5.1 package:
|
|
==============================
|
|
|
|
With MySQL 5.1 package we introduced some changes you may like to know. Most of
|
|
them will affect you only if you are upgrading from previous version and you
|
|
did some changes to your configuration.
|
|
|
|
1) Plugins:
|
|
===========
|
|
|
|
One of the new features in MySQL 5.1 is support for plugins. So some of the
|
|
storage engines are now shipped like that. You can use following plugins:
|
|
|
|
- archive
|
|
- blackhole
|
|
- federated
|
|
- example
|
|
|
|
InnoDB is still compiled as internal part of MySQL. If you are upgrading from
|
|
version 5.0 or if this is your first installation of MySQL 5.1, all plugins
|
|
will be enabled by default and you can disable them manually later (see
|
|
http://dev.mysql.com/doc/refman/5.1/en/uninstall-plugin.html).
|
|
|
|
With this change you need to remove skip-federated option from your my.cnf file
|
|
if you have changed it manually. This option was there by default in previous
|
|
versions of MySQL.
|
|
|
|
2) File locations:
|
|
==================
|
|
|
|
There were some changes in files locations. Most of them were made in the
|
|
default configuration file so if you are experiencing problems and you have
|
|
made some manual adjustments to your /etc/my.cnf, try to merge this file with
|
|
/etc/my.cnf.rpmnew.
|
|
|
|
File locations changes:
|
|
- MySQL socket file and pid file were moved from /var/lib/mysql to more
|
|
reasonable location ( /run/mysql ) by default.
|
|
- MySQL log files are in /var/log/mysql.
|
|
|
|
3) BerkeleyDB:
|
|
==============
|
|
|
|
MySQL no longer contains BerkeleyDB as storage engine. There is no fix for that
|
|
and if you used it before, you have to migrate your data to different storage
|
|
engine BEFORE updating. This can be done for example using following command:
|
|
|
|
ALTER TABLE foo ENGINE = INNODB;
|
|
|
|
4) MySQL Upgrade Log
|
|
====================
|
|
|
|
If you missed messages displayed during automatic MySQL database upgrade, you
|
|
can find them from now on in
|
|
|
|
/var/log/mysql/mysqld-upgrade.log
|
|
|