Differential D2987

Provision users and databases on devserver-mysql role
ClosedPublic
Actions

Authored by dereckson on Apr 10 2023, 10:35.

Tags

None

Referenced Files

	F52187196: D2987.id7633.diff
	Wed, Sep 30, 21:46

	F52148086: D2987.id7633.diff
	Wed, Sep 30, 14:59

	F52142667: D2987.id7634.diff
	Wed, Sep 30, 14:00

	F52142665: D2987.id7630.diff
	Wed, Sep 30, 14:00

	F52130311: D2987.id7635.diff
	Wed, Sep 30, 12:09

	F52124577: D2987.id7625.diff
	Wed, Sep 30, 11:17

	F52045446: D2987.id7626.diff
	Tue, Sep 29, 23:31

	F52045426: D2987.id7624.diff
	Tue, Sep 29, 23:31

Subscribers

None

Details

Reviewers

Maniphest Tasks

T1803: Move and migrate Ysul production services elsewhere

Commits

rOPSb44705d1eca1: Provision users and databases on devserver-mysql role

Summary

Salt uses the mysql execution module to configure MySQL, ie the pymysql
library. Credentials are stored in the node itself to use a localhost
root-like account "salt", defined in the pillar.

Test Plan

Deploy on db-B-001

Diff Detail

Repository

rOPS Nasqueron Operations

Lint

Lint Passed

Severity	Location	Code	Message
Advice	roles/dbserver-mysql/salt/files/dbserver_mysql_salt_credentials.py:58	F821	flake8 F821
Advice	roles/dbserver-mysql/salt/files/dbserver_mysql_salt_credentials.py:61	F821	flake8 F821
Advice	roles/dbserver-mysql/salt/files/dbserver_mysql_salt_credentials.py:61	F821	flake8 F821
Advice	roles/dbserver-mysql/salt/files/dbserver_mysql_salt_credentials.py:62	F821	flake8 F821
Advice	roles/dbserver-mysql/salt/files/dbserver_mysql_salt_credentials.py:64	F821	flake8 F821

Unit

No Test Coverage

Branch

mysql-salt

Build Status

Buildable 4717
Build 4998: arc lint + arc unit

Event Timeline

dereckson created this revision.Apr 10 2023, 10:35

dereckson held this revision as a draft.

Harbormaster completed remote builds in B4717: Diff 7624.Apr 10 2023, 10:35

import sys

Harbormaster completed remote builds in B4718: Diff 7625.Apr 10 2023, 10:36

cluster-B was edited at two places, merging them

Harbormaster completed remote builds in B4719: Diff 7626.Apr 10 2023, 10:53

Provision content.

Tested fine with D2989.

Harbormaster completed remote builds in B4722: Diff 7630.Apr 10 2023, 12:49

dereckson published this revision for review.Apr 10 2023, 12:50

dereckson added a task: T1803: Move and migrate Ysul production services elsewhere.

Was missing a part not pushed on datacube.

Harbormaster completed remote builds in B4723: Diff 7631.Apr 10 2023, 12:53

Was missing a part not pushed on datacube (git reset --hard datacube/mysql-salt will work better than git reset same branch name locally).

Harbormaster completed remote builds in B4724: Diff 7632.Apr 10 2023, 12:54

Des espaces insécables.

Harbormaster completed remote builds in B4725: Diff 7633.Apr 10 2023, 12:57

dereckson accepted this revision.Apr 10 2023, 12:57

This revision is now accepted and ready to land.Apr 10 2023, 12:57

Black style

Harbormaster completed remote builds in B4726: Diff 7634.Apr 10 2023, 12:57

Closed by commit rOPSb44705d1eca1: Provision users and databases on devserver-mysql role (authored by dereckson). · Explain WhyApr 10 2023, 12:58

This revision was automatically updated to reflect the committed changes.

dereckson added a commit: rOPSb44705d1eca1: Provision users and databases on devserver-mysql role.

Tested with D2989.

Revision Contents
Changeset List

Path

Size

pillar/

credentials/

4 lines

dbserver/

19 lines

roles/

dbserver-mysql/

1 line

salt/

files/

dbserver_mysql_salt_credentials.py

64 lines

23 lines

41 lines

Diff 7624

pillar/credentials/vault.sls

Loading...

pillar/dbserver/cluster-B.sls

Loading...

roles/dbserver-mysql/init.sls

Loading...

roles/dbserver-mysql/salt/files/dbserver_mysql_salt_credentials.py

Loading...

roles/dbserver-mysql/salt/files/mysql.conf

Loading...

roles/dbserver-mysql/salt/init.sls

Loading...