Paths

Table of Contentst

Differential D12322

[terraform] MariaDB RDS config options
ClosedPublic
Actions

Authored by will on Wed, Jun 5, 3:22 PM.

Tags

None

Referenced Files

	F2191300: D12322.diff
	Thu, Jul 4, 2:57 PM

	Unknown Object (File)
	Wed, Jul 3, 5:41 AM

	Unknown Object (File)
	Wed, Jun 26, 3:21 PM

	Unknown Object (File)
	Sat, Jun 22, 6:20 AM

	Unknown Object (File)
	Sat, Jun 22, 3:59 AM

	Unknown Object (File)
	Fri, Jun 21, 8:03 PM

	Unknown Object (File)
	Fri, Jun 21, 9:58 AM

	Unknown Object (File)
	Fri, Jun 21, 6:57 AM

View All 34 Files

Subscribers

Details

Reviewers

ashoat
bartek
varun

Commits

rCOMMb2f66ef85324: [terraform] MariaDB RDS config options

Summary

This sets mostly the same parameter options as MariaDB besides innodb_buffer_pool_size which is set to {DBInstanceClassMemory*3/4} matching our phabricator database and general recommendations.

Here are the configuration options in our keyserver docker compose file:

--performance-schema
--max-allowed-packet=256M
--local-infile=0
--sql-mode=STRICT_ALL_TABLES
--innodb-buffer-pool-size=1600M
--innodb-ft-min-token-size=1
--innodb-ft-enable-stopword=0

Test Plan

successful terraform deploy. Ran transfer process and successfully accessed the rds instance with mysql

Diff Detail

Repository

Branch

keyserver_to_aws

Lint

No Lint Coverage

Unit

No Test Coverage

Event Timeline

will created this revision.Wed, Jun 5, 3:22 PM

Herald added a subscriber: tomek. · View Herald TranscriptWed, Jun 5, 3:22 PM

will added inline comments.Wed, Jun 5, 3:25 PM

services/terraform/self-host/aws_db.tf
60	This is representative of 256 MiB: (1024 * 1024 * 256).

will edited the test plan for this revision. (Show Details)Wed, Jun 5, 3:27 PM

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

Harbormaster completed remote builds in B29463: Diff 40998.Wed, Jun 5, 3:39 PM

will requested review of this revision.Wed, Jun 5, 3:39 PM

will added a child revision: D12323: [terraform] remove usage of s3 bucket for terraform config.Wed, Jun 5, 4:18 PM

I haven't dug deep into what these params mean but they match docker configuration so it should be okay

services/terraform/self-host/aws_db.tf
60	Comment would be good

This revision is now accepted and ready to land.Thu, Jun 6, 12:34 AM

add comment: 256 MiB: (1024 * 1024 * 256)

Harbormaster completed remote builds in B29495: Diff 41068.Thu, Jun 6, 12:00 PM

ashoat mentioned this in D12337: [keyserver] Bump MariaDB --innodb-buffer-pool-size config to 14000M in docker-compose.yml.Thu, Jun 6, 8:02 PM

rebase

Harbormaster completed remote builds in B29506: Diff 41079.Thu, Jun 6, 9:28 PM

ashoat mentioned this in rCOMMcdbbbc452d07: [keyserver] Bump MariaDB --innodb-buffer-pool-size config to 14000M in docker….Fri, Jun 7, 5:55 AM

Closed by commit rCOMMb2f66ef85324: [terraform] MariaDB RDS config options (authored by will). · Explain WhyFri, Jun 7, 10:55 AM

This revision was automatically updated to reflect the committed changes.

will added a commit: rCOMMb2f66ef85324: [terraform] MariaDB RDS config options.

Revision Contents
Changeset List

Path

Size

services/

terraform/

self-host/

50 lines

Diff 40998

services/terraform/self-host/aws_db.tf

Loading...