Listen to external connections on dbserver-mysql role
ClosedPublic
Actions

Authored by dereckson on Apr 9 2023, 22:25.

Details

Reviewers

dereckson

Maniphest Tasks

T1803: Move and migrate Ysul production services elsewhere

Commits

rOPS2ce580561ae1: Listen to external connections on dbserver-mysql role

Summary

There are 2 kinds of servers where MariaDB is deployed with dbserver-mysql role:

devserver, where it makes sens to listen to 127.0.0.1
pure dbserver-mysql clusters, where it needs to accept other machines

This change configures the listen address accordingly.

It's no-op for Docker MySQL and MariaDB containers.

Ref T1803

Test Plan

Deploy on db-B-001, then mysql -H db-B-001

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

Lint Not Applicable

Unit

Tests Not Applicable

Event Timeline

dereckson requested review of this revision.Apr 9 2023, 22:25

dereckson created this revision.

Harbormaster completed remote builds in B4716: Diff 7621.Apr 9 2023, 22:25

dereckson retitled this revision from Listen to external conections on dbserver-mysql role to Listen to external connections on dbserver-mysql role.Apr 9 2023, 22:51

dereckson edited the summary of this revision. (Show Details)

$ salt db-B-001 state.apply roles/dbserver-mysql
[...]
----------
          ID: /usr/local/etc/mysql/conf.d
    Function: file.recurse
      Result: True
     Comment: Recursively updated /usr/local/etc/mysql/conf.d
     Started: 00:57:27.179775
    Duration: 711.287 ms
     Changes:
              ----------
              /usr/local/etc/mysql/conf.d/server.cnf:
                  ----------
                  diff:
                      ---
                      +++
                      @@ -35,7 +35,7 @@
                       datadir = /var/db/mysql
                       lc-messages-dir = /usr/local/share/mysql

                      -bind-address                     = 127.0.0.1
                      +bind-address                     = 0.0.0.0
                       socket = /var/run/mysql/mysqld.sock
                       port = 3306
[...]