February 2020 – 一江春水向东流

ansible安装mariadb

最近在搞mariadb的高可用安装, 直接使用的官方ansible, 坑太多了, 现在记录下来官方脚本下载: ansible-galaxy install geerlingguy.mysql 需要修改的地方: roles/tasks/main.yml

---
# Variable configuration.
- include_tasks: variables.yml

# Setup/install tasks.
- include_tasks: setup-RedHat.yml
  when: ansible_os_family == 'RedHat' and not uninstall_mysql

- include_tasks: setup-Debian.yml
  when: ansible_os_family == 'Debian' and not uninstall_mysql

- include_tasks: setup-Archlinux.yml
  when: ansible_os_family == 'Archlinux' and not uninstall_mysql

- name: Check if MySQL packages were installed.
  set_fact:
    mysql_install_packages: "{{ (rh_mysql_install_packages is defined and rh_mysql_install_packages.changed)
      or (deb_mysql_install_packages is defined and deb_mysql_install_packages.changed)
      or (arch_mysql_install_packages is defined and arch_mysql_install_packages.changed) }}"
  when: not uninstall_mysql

- name: Include task list in play only if the condition is true
  include_tasks: "{{ item }}"
  with_items:
    - configure.yml
    - secure-installation.yml
    - databases.yml
    - users.yml
    - replication.yml
  when: not uninstall_mysql

- name: Uninstall mariadb
  include: uninstall.yml
  when: uninstall_mysql

---

# Variable configuration.

- include_tasks: variables.yml

# Setup/install tasks.

- include_tasks: setup-RedHat.yml

when: ansible_os_family == 'RedHat' and not uninstall_mysql

- include_tasks: setup-Debian.yml

when: ansible_os_family == 'Debian' and not uninstall_mysql

- include_tasks: setup-Archlinux.yml

when: ansible_os_family == 'Archlinux' and not uninstall_mysql

- name: Check if MySQL packages were installed.

set_fact:

mysql_install_packages: "{{ (rh_mysql_install_packages is defined and rh_mysql_install_packages.changed)

or (deb_mysql_install_packages is defined and deb_mysql_install_packages.changed)

or (arch_mysql_install_packages is defined and arch_mysql_install_packages.changed) }}"

when: not uninstall_mysql

- name: Include task list in play only if the condition is true

include_tasks: "{{ item }}"

with_items:

- configure.yml

- secure-installation.yml

- databases.yml

- users.yml

- replication.yml

when: not uninstall_mysql

- name: Uninstall mariadb

include: uninstall.yml

when: uninstall_mysql

roles/tasks/configure.yml: 如果要自定义一些目录的话, 需要创建目录并修改文件夹权限

---
- name: Get MySQL version.
  command: 'mysql --version'
  register: mysql_cli_version
  changed_when: false
  check_mode: false

- name: Copy my.cnf global MySQL configuration.
  template:
    src: my.cnf.j2
    dest: "{{ mysql_config_file }}"
    owner: root
    group: root
    mode: 0644
    force: "{{ overwrite_global_mycnf }}"
  notify: restart mysql

- name: Verify mysql include directory exists.
  file:
    path: "{{ mysql_config_include_dir }}"
    state: directory
    owner: root
    group: root
    mode: 0755
  when: mysql_config_include_files | length

- name: Copy my.cnf override files into include directory.
  template:
    src: "{{ item.src }}"
    dest: "{{ mysql_config_include_dir }}/{{ item.src | basename }}"
    owner: root
    group: root
    mode: 0644
    force: "{{ item.force | default(False) }}"
  with_items: "{{ mysql_config_include_files }}"
  notify: restart mysql

- name: Create slow query log file (if configured).
  shell: >
    mysql_slow_query_log_file={{ mysql_slow_query_log_file }};
    mkdir -p ${mysql_slow_query_log_file%/*};
    touch ${mysql_slow_query_log_file}
  when: mysql_slow_query_log_enabled

- name: Create datadir if it does not exist
  file:
    path: "{{ mysql_datadir }}"
    state: directory
    owner: mysql
    group: mysql
    mode: 0755
    setype: mysqld_db_t

- name: Set ownership on slow query log file (if configured).
  file:
    path: "{{ mysql_slow_query_log_file }}"
    state: file
    owner: mysql
    group: "{{ mysql_log_file_group }}"
    mode: 0640
  when: mysql_slow_query_log_enabled

- name: Create error log directory (if configured).
  shell: >
    mysql_log_error={{ mysql_log_error }};
    mkdir -p ${mysql_log_error%/*};
    touch ${mysql_log_error};
    chown -R mysql:{{ mysql_log_file_group }} ${mysql_log_error%/*}
  when:
    - mysql_log == ""
    - mysql_log_error != ""
  tags: ['skip_ansible_galaxy']

- name: Set ownership on error log file (if configured).
  file:
    path: "{{ mysql_log_error }}"
    state: file
    owner: mysql
    group: "{{ mysql_log_file_group }}"
    mode: 0640
  when:
    - mysql_log == ""
    - mysql_log_error != ""
  tags: ['skip_ansible_galaxy']

- name: Create socket/pid directory
  shell: >
    mysql_pid_file={{ mysql_pid_file }};
    mysql_socket={{ mysql_socket }};
    for file in `echo $mysql_pid_file $mysql_socket`; do
      dir=${file%/*};
      if [[ ! -d $dir ]]; then
        mkdir -p ${dir}
        chown mysql:mysql ${dir}
        chmod 0755 ${dir}
      else
        echo "$dir already exist"
      fi
    done

- name: Create tmpdir if it does not exist
  file:
    path: "{{ mysql_tmpdir }}"
    state: directory
    owner: mysql
    group: mysql
    mode: 0777
    
- name: init mysql db
  shell: >
    mysql_install_db --user=mysql --basedir=/usr --datadir={{ mysql_datadir }}
  ignore_errors: true

- name: Ensure MySQL is started and enabled on boot.
  service: "name={{ mysql_daemon }} state=started enabled={{ mysql_enabled_on_startup }}"
  register: mysql_service_configuration

100

101

102

103

104

105

106

107

108

109

110

111

112

113

114

115

116

---

- name: Get MySQL version.

command: 'mysql --version'

changed_when: false

check_mode: false

- name: Copy my.cnf global MySQL configuration.

template:

src: my.cnf.j2

dest: "{{ mysql_config_file }}"

owner: root

group: root

mode: 0644

force: "{{ overwrite_global_mycnf }}"

notify: restart mysql

- name: Verify mysql include directory exists.

file:

path: "{{ mysql_config_include_dir }}"

state: directory

owner: root

group: root

mode: 0755

when: mysql_config_include_files | length

- name: Copy my.cnf override files into include directory.

template:

src: "{{ item.src }}"

dest: "{{ mysql_config_include_dir }}/{{ item.src | basename }}"

owner: root

group: root

mode: 0644

force: "{{ item.force | default(False) }}"

with_items: "{{ mysql_config_include_files }}"

notify: restart mysql

- name: Create slow query log file (if configured).

shell: >

mysql_slow_query_log_file={{ mysql_slow_query_log_file }};

mkdir -p ${mysql_slow_query_log_file%/*};

touch ${mysql_slow_query_log_file}

when: mysql_slow_query_log_enabled

- name: Create datadir if it does not exist

file:

path: "{{ mysql_datadir }}"

state: directory

owner: mysql

group: mysql

mode: 0755

setype: mysqld_db_t

- name: Set ownership on slow query log file (if configured).

file:

path: "{{ mysql_slow_query_log_file }}"

state: file

owner: mysql

group: "{{ mysql_log_file_group }}"

mode: 0640

when: mysql_slow_query_log_enabled

- name: Create error log directory (if configured).

shell: >

mysql_log_error={{ mysql_log_error }};

mkdir -p ${mysql_log_error%/*};

touch ${mysql_log_error};

chown -R mysql:{{ mysql_log_file_group }} ${mysql_log_error%/*}

when:

- mysql_log == ""

- mysql_log_error != ""

tags: ['skip_ansible_galaxy']

- name: Set ownership on error log file (if configured).

file:

path: "{{ mysql_log_error }}"

state: file

owner: mysql

group: "{{ mysql_log_file_group }}"

mode: 0640

when:

- mysql_log == ""

- mysql_log_error != ""

tags: ['skip_ansible_galaxy']

- name: Create socket/pid directory

shell: >

mysql_pid_file={{ mysql_pid_file }};

mysql_socket={{ mysql_socket }};

for file in `echo $mysql_pid_file $mysql_socket`; do

dir=${file%/*};

if [[ ! -d $dir ]]; then

mkdir -p ${dir}

chown mysql:mysql ${dir}

chmod 0755 ${dir}

else

echo "$dir already exist"

done

- name: Create tmpdir if it does not exist

file:

path: "{{ mysql_tmpdir }}"

state: directory

owner: mysql

group: mysql

mode: 0777

- name: init mysql db

shell: >

mysql_install_db --user=mysql --basedir=/usr --datadir={{ mysql_datadir }}

ignore_errors: true

- name: Ensure MySQL is started and enabled on boot.

service: "name={{ mysql_daemon }} state=started enabled={{ mysql_enabled_on_startup }}"

roles/tasks/database.yml: 注意修改默认字符集

---
- name: Ensure MySQL databases are present.
  mysql_db:
    name: "{{ item.name }}"
    login_user: "{{ mysql_root_username }}"
    login_password: "{{ mysql_root_password }}"
    login_unix_socket: "{{ mysql_socket }}"
    collation: "{{ item.collation | default('utf8mb4_unicode_ci') }}"
    encoding: "{{ item.encoding | default('utf8mb4') }}"
    state: "{{ item.state | default('present') }}"
  with_items: "{{ mysql_databases }}"

---

- name: Ensure MySQL databases are present.

mysql_db:

name: "{{ item.name }}"

login_user: "{{ mysql_root_username }}"

login_password: "{{ mysql_root_password }}"

login_unix_socket: "{{ mysql_socket }}"

collation: "{{ item.collation | default('utf8mb4_unicode_ci') }}"

encoding: "{{ item.encoding | default('utf8mb4') }}"

state: "{{ item.state | default('present') }}"

with_items: "{{ mysql_databases }}"

roles/tasks/variables.yml:

---
# Variable configuration.
- name: Include OS-specific variables.
  include_vars: "{{ item }}"
  with_first_found:
    - files:
        - "vars/{{ ansible_os_family }}-{{ ansible_distribution_major_version }}.yml"
        - "vars/{{ ansible_os_family }}.yml"
      skip: true

- name: Define mysql_packages.
  set_fact:
    mysql_packages: "{{ __mysql_packages | list }}"
  when: mysql_packages is not defined

- name: Define mysql_daemon.
  set_fact:
    mysql_daemon: "{{ __mysql_daemon }}"
  when: mysql_daemon is not defined

- name: Define mysql_slow_query_log_file.
  set_fact:
    mysql_slow_query_log_file: "{{ __mysql_slow_query_log_file }}"
  when: mysql_slow_query_log_file is not defined

- name: Define mysql_log_error.
  set_fact:
    mysql_log_error: "{{ __mysql_log_error }}"
  when: mysql_log_error is not defined

- name: Define mysql_syslog_tag.
  set_fact:
    mysql_syslog_tag: "{{ __mysql_syslog_tag }}"
  when: mysql_syslog_tag is not defined

- name: Define mysql_pid_file.
  set_fact:
    mysql_pid_file: "{{ __mysql_pid_file }}"
  when: mysql_pid_file is not defined

- name: Define mysql_config_file.
  set_fact:
    mysql_config_file: "{{ __mysql_config_file }}"
  when: mysql_config_file is not defined

- name: Define mysql_config_include_dir.
  set_fact:
    mysql_config_include_dir: "{{ __mysql_config_include_dir }}"
  when: mysql_config_include_dir is not defined

- name: Define mysql_socket.
  set_fact:
    mysql_socket: "{{ __mysql_socket }}"
  when: mysql_socket is not defined

- name: Define mysql_supports_innodb_large_prefix.
  set_fact:
    mysql_supports_innodb_large_prefix: "{{ __mysql_supports_innodb_large_prefix }}"
  when: mysql_supports_innodb_large_prefix is not defined

---

# Variable configuration.

- name: Include OS-specific variables.

include_vars: "{{ item }}"

with_first_found:

- files:

- "vars/{{ ansible_os_family }}-{{ ansible_distribution_major_version }}.yml"

- "vars/{{ ansible_os_family }}.yml"

skip: true

- name: Define mysql_packages.

set_fact:

mysql_packages: "{{ __mysql_packages | list }}"

when: mysql_packages is not defined

- name: Define mysql_daemon.

set_fact:

mysql_daemon: "{{ __mysql_daemon }}"

when: mysql_daemon is not defined

- name: Define mysql_slow_query_log_file.

set_fact:

mysql_slow_query_log_file: "{{ __mysql_slow_query_log_file }}"

when: mysql_slow_query_log_file is not defined

- name: Define mysql_log_error.

set_fact:

mysql_log_error: "{{ __mysql_log_error }}"

when: mysql_log_error is not defined

- name: Define mysql_syslog_tag.

set_fact:

mysql_syslog_tag: "{{ __mysql_syslog_tag }}"

when: mysql_syslog_tag is not defined

- name: Define mysql_pid_file.

set_fact:

mysql_pid_file: "{{ __mysql_pid_file }}"

when: mysql_pid_file is not defined

- name: Define mysql_config_file.

set_fact:

mysql_config_file: "{{ __mysql_config_file }}"

when: mysql_config_file is not defined

- name: Define mysql_config_include_dir.

set_fact:

mysql_config_include_dir: "{{ __mysql_config_include_dir }}"

when: mysql_config_include_dir is not defined

- name: Define mysql_socket.

set_fact:

mysql_socket: "{{ __mysql_socket }}"

when: mysql_socket is not defined

- name: Define mysql_supports_innodb_large_prefix.

set_fact:

mysql_supports_innodb_large_prefix: "{{ __mysql_supports_innodb_large_prefix }}"

when: mysql_supports_innodb_large_prefix is not defined

roles/tasks/secure-installation.yml: 此文件坑较多, 若用官方的, 会出现没有mysql.user库的报错, 因为存在匿名帐户, 直接用mysql -uroot -p登录的话, 会看到没有默认的mysql库, 但是其实已经有库了, 只是登录时如果不写-h的话, 默认就直接解析到通过hostname了, 在my.cnf里添加skip-name-resolve,可以不通过DNS解析. 所以只能通过mysql -hlocalhost -uroot -p方式都能正确地进入到库, 所以更改如下: [ mysql -NBe 改为: mysql -NB -h localhost -e ] Read more…

By sean, 5 years02/20/2020 ago

未分类

iterm2远程连接中文显示乱码

问题: 服务器是ubuntu，用Mac的iterm2 ssh连上去，终端显示中文乱码，也不能输入中文，然而本地终端可以显示和输入。解决方法：这种情况一般是终端和服务器的字符集不匹配，MacOSX下默认的是utf8字符集。输入locale可以查看字符编码设置情况，而我的对应值是空的。因为我在本地和服务器都用zsh替代了bash，而且使用了oh-my-zsh，而默认的.zshrc没有设置为utf-8编码，所以本地和服务器端都要在.zshrc设置，步骤如下，bash对应.bash_profile或.bashrc文件。 1.在终端下输入

vim ~/.zshrc

1	vim ~/.zshrc

或者使用其他你喜欢的编辑器编辑~/.zshrc文件 2.在文件内容末端添加：

export LC_ALL=en_US.UTF-8 
export LANG=en_US.UTF-8

1 2	export LC_ALL=en_US.UTF-8 export LANG=en_US.UTF-8

接着重启一下终端，或者输入source ~/.zshrc使设置生效。设置成功的话，在本地和登录到服务器输入locale回车会显示下面内容。

LANG="en_US.UTF-8" 
LC_COLLATE="en_US.UTF-8" 
LC_CTYPE="en_US.UTF-8" 
LC_MESSAGES="en_US.UTF-8" 
LC_MONETARY="en_US.UTF-8" 
LC_NUMERIC="en_US.UTF-8" 
LC_TIME="en_US.UTF-8" 
LC_ALL="en_US.UTF-8"

LANG="en_US.UTF-8"

LC_COLLATE="en_US.UTF-8"

LC_CTYPE="en_US.UTF-8"

LC_MESSAGES="en_US.UTF-8"

LC_MONETARY="en_US.UTF-8"

LC_NUMERIC="en_US.UTF-8"

LC_TIME="en_US.UTF-8"

LC_ALL="en_US.UTF-8"

这时，中文输入和显示都正常了。

By sean, 5 years02/11/2020 ago

M	T	W	T	F	S	S
					1	2
3	4	5	6	7	8	9
10	11	12	13	14	15	16
17	18	19	20	21	22	23
24	25	26	27	28	29