Page MenuHomeDevCentral
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
F10864106: D2987.diff
Fri, Aug 1, 11:20
Unknown Object (File)
Thu, Jul 31, 07:51
Unknown Object (File)
Wed, Jul 30, 11:10
Unknown Object (File)
Tue, Jul 29, 05:29
Unknown Object (File)
Mon, Jul 28, 11:39
Unknown Object (File)
Mon, Jul 28, 10:33
Unknown Object (File)
Sun, Jul 27, 22:37
Unknown Object (File)
Sun, Jul 27, 20:22
View All Files
Subscribers
None

Details

Reviewers
dereckson
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 Errors
SeverityLocationCodeMessage
Errorroles/dbserver-mysql/salt/files/dbserver_mysql_salt_credentials.py:50E501flake8 E501
Unit
No Test Coverage
Branch
mysql-salt
Build Status
Buildable 4724
Build 5005: 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
dereckson updated this revision to Diff 7625.Apr 10 2023, 10:36

import sys

Harbormaster completed remote builds in B4718: Diff 7625.Apr 10 2023, 10:36
dereckson updated this revision to Diff 7626.Apr 10 2023, 10:53

cluster-B was edited at two places, merging them

Harbormaster completed remote builds in B4719: Diff 7626.Apr 10 2023, 10:53
dereckson updated this revision to Diff 7630.Apr 10 2023, 12:49

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.
dereckson updated this revision to Diff 7631.Apr 10 2023, 12:53

Was missing a part not pushed on datacube.

Harbormaster completed remote builds in B4723: Diff 7631.Apr 10 2023, 12:53
dereckson updated this revision to Diff 7632.Apr 10 2023, 12:54

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
dereckson updated this revision to Diff 7633.Apr 10 2023, 12:57

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
dereckson updated this revision to Diff 7634.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.
dereckson added a comment.Apr 10 2023, 12:58

Tested with D2989.

Revision Contents
Changeset List

PathSize
pillar/
credentials/
4 lines
dbserver/
36 lines
3 lines
roles/
dbserver-mysql/
content/
92 lines
4 lines
salt/
files/
66 lines
22 lines
42 lines

Diff 7632

View Options

pillar/credentials/vault.sls

Loading...
View Options

pillar/dbserver/cluster-B.sls

Loading...
View Options

pillar/top.sls

Loading...
View Options

roles/dbserver-mysql/content/init.sls

Loading...
View Options

roles/dbserver-mysql/init.sls

Loading...
View Options

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

Loading...
View Options

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

Loading...
View Options

roles/dbserver-mysql/salt/init.sls

Loading...
Nasqueron DevCentral · If it had been much bigger the moon would have had a core of ice. · Powered by Phabricator