MySQL: Unterschied zwischen den Versionen
Zur Navigation springen
Zur Suche springen
K (secure) |
K (http://mysqltuner.com/) |
||
| (3 dazwischenliegende Versionen desselben Benutzers werden nicht angezeigt) | |||
| Zeile 32: | Zeile 32: | ||
/srv/mysql/datadir55/** rwk,</source> | /srv/mysql/datadir55/** rwk,</source> | ||
== | =Backup= | ||
*[[MySQLDumper]] | |||
*http://hollandbackup.org/ | |||
*[http://www.lenzg.net/mylvmbackup/ mylvmbackup is a tool for quickly creating full physical backups of a MySQLserver's data files.] | |||
= | = Clients = | ||
*[http://dev.mysql.com/downloads/tools/workbench/ MySQL Workbench] | |||
*[http://www.navicat.de/ Navicat] | |||
[ | =Links= | ||
*[http://www.thomas-krenn.com/de/wiki/MySQL_Performance_Tuning MySQL Performance Tuning] | |||
*[http://mysqltuner.com/ MySQL Tuner] | |||
[[Kategorie:Datenbank]] | [[Kategorie:Datenbank]] | ||
[[Kategorie:MySQL]] | [[Kategorie:MySQL]] | ||
Aktuelle Version vom 18. Dezember 2015, 22:37 Uhr
Konfiguration
Custom Settings
#/etc/mysql/conf.d/settings.cnf
[mysqld]
#
# * Basic Settings
#
datadir = /srv/mysql/datadir55
ft_min_word_len=3
table_cache = 256Secure Installation
/usr/bin/mysqladmin -u root -h hostname password 'new-password'
Alternatively you can run:
/usr/bin/mysql_secure_installation
which will also give you the option of removing the test
databases and anonymous user created by default. This is
strongly recommended for production servers.
Apparmor config
#/etc/apparmor.d/usr.sbin.mysqld
#find and replace
#/var/lib/mysql/ r,
#/var/lib/mysql/** rwk,
/srv/mysql/datadir55/ r,
/srv/mysql/datadir55/** rwk,
Backup
- MySQLDumper
- http://hollandbackup.org/
- mylvmbackup is a tool for quickly creating full physical backups of a MySQLserver's data files.