MySQL

Konfiguration

Custom Settings

#/etc/mysql/conf.d/settings.cnf
[mysqld]
#
# * Basic Settings
#
datadir         = /srv/mysql/datadir55

ft_min_word_len=3

table_cache             = 256

Secure 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.

Clients

• MySQL Workbench
• Navicat

Links

• MySQL Performance Tuning
• MySQL Tuner