MySQL: 4. Create the service
This documentation is part of the Automate with the CLI guide. View the full guide here: Start MySQL, retrieve its credentials, and change its configuration programmatically with the Stackhero CLI.
👋 Welcome to the Stackhero documentation!
Stackhero provides a fully managed MySQL cloud service that simplifies deployment and management for production workloads:
- Unlimited connections and data transfers.
- Integrated phpMyAdmin web interface for easy database management.
- Hassle-free updates with one-click upgrades.
- Consistent performance and strong security on a private, dedicated infrastructure.
With Stackhero, you can have a reliable MySQL database ready in just a few minutes. Spend less time on setup and maintenance, and more time building your applications. Try MySQL cloud hosting on Stackhero today.
Here is a sample script that creates a stack, adds your MySQL service to it, waits for it to start, retrieves its configuration (including generated credentials), and then applies a new configuration.
#!/bin/bash
set -e
export STACKHERO_TOKEN="usr-xxxxxx:your-token"
serviceStore="mysql" # The MySQL service store name (see step 2)
instance="..." # An instance size from step 3
region="europe" # A region name from step 3
# Create a stack for your service (uses your default organization; add --organization if needed)
stackId=$(stackhero --format=script stack-create \
--name="My MySQL stack")
echo "Stack created: ${stackId}"
# Add MySQL to the stack (names are resolved automatically)
serviceId=$(stackhero --format=script service-add \
--stack="My MySQL stack" \
--service-store="${serviceStore}" \
--instance="${instance}" \
--region="${region}")
echo "Service added: mysql"
# Wait for the service to be fully running (this may take a couple of minutes)
stackhero service-wait-for --service="mysql"
# Retrieve the service configuration, including generated credentials
stackhero service-configuration-get --service="mysql" --format=json