Mysql
Example: mysql resource using a Kubernetes StatefulSet
This example configures a mysql Resource Definition using Kubernetes StatefulSet
.
Requirements
Name | Version |
---|---|
terraform | >= 1.3.0 |
humanitec | ~> 1.0 |
Providers
Name | Version |
---|---|
humanitec | ~> 1.0 |
Modules
Name | Source | Version |
---|---|---|
mysql_basic | ../../humanitec-resource-defs/mysql/basic | n/a |
Resources
Name | Type |
---|---|
humanitec_resource_definition_criteria.mysql_basic | resource |
Inputs
Name | Description | Type | Default | Required |
---|---|---|---|---|
prefix | Prefix of the created resources | string |
"hum-rp-mysql-ex-" |
no |
Deploy and use this example
To deploy this resource definition, run these commands below:
git clone https://github.com/humanitec-architecture/resource-packs-in-cluster
cd examples/mysql/
humctl login
humctl config set org YOUR-ORG
terraform init
terraform plan
terraform apply
The created Resource Definition can be used in your Score file like illustrated below:
apiVersion: score.dev/v1b1
metadata:
name: my-workload
containers:
my-container:
image: nginx:latest # this container image is just used as an example, it's not talking to mysql.
variables:
MYSQL_CONNECTION_STRING: "Server=${resources.my-mysql.host};Port=${resources.my-mysql.port};Database=${resources.my-mysql.name};Uid=${resources.my-mysql.username};Pwd=${resources.my-mysql.password};"
resources:
my-mysql:
type: mysql
This Score file when deployed to Humanitec will provision the mysql
database and inject the outputs in the associated environment variable.
Here is how to deploy this Score file, for example to the mysql-example
Application and development
Environment:
humctl create app mysql-example
humctl score deploy \
-f score.yaml \
--app mysql-example \
--env development
main.tf
(view on GitHub)
:
module "mysql_basic" {
source = "github.com/humanitec-architecture/resource-packs-in-cluster?ref=v2024-09-18//humanitec-resource-defs/mysql/basic"
prefix = var.prefix
}
resource "humanitec_resource_definition_criteria" "mysql_basic" {
resource_definition_id = module.mysql_basic.id
class = "default"
force_delete = true
}
providers.tf
(view on GitHub)
:
terraform {
required_providers {
humanitec = {
source = "humanitec/humanitec"
version = "~> 1.0"
}
}
required_version = ">= 1.3.0"
}
provider "humanitec" {}
terraform.tfvars.example
(view on GitHub)
:
# Prefix of the created resources
prefix = "hum-rp-mysql-ex-"
variables.tf
(view on GitHub)
:
variable "prefix" {
description = "Prefix of the created resources"
type = string
default = "hum-rp-mysql-ex-"
}