🐬 MySQL Container Testing
Master MySQL Testing with Testcontainers
Build bulletproof MySQL integration tests that survive real-world chaos
🎯 Why MySQL?
🚀 Popular & Fast
Extremely popular in web applications, fast to spin up in containers
🧪 Perfect for Chaos
Great candidate for chaos testing in CI/CD pipelines
🔧 Easy Integration
Simple setup with Testcontainers and comprehensive testing
✅ Test Cases Implemented
Test Case 1 — Check MySQL Version
✅ PassedRuns a query to ensure MySQL is running and accessible.
result = conn.execute(text("SELECT VERSION();")).fetchone()
assert "MySQL" in result[0] or "MariaDB" in result[0]Test Case 2 — Insert and Query
✅ PassedInserts a single record and retrieves it.
conn.execute(text("INSERT INTO users (name) VALUES ('Alice');"))
result = conn.execute(text("SELECT name FROM users;")).fetchone()
assert result[0] == "Alice"Test Case 3 — Insert Multiple Rows
✅ PassedAdds multiple rows and verifies the total count.
conn.execute(text("INSERT INTO users (name) VALUES ('Bob'), ('Charlie');"))
result = conn.execute(text("SELECT COUNT(*) FROM users;")).fetchone()
assert result[0] == 3Test Case 4 — Primary Key Constraint
✅ PassedVerifies the primary key prevents duplicate entries.
conn.execute(text("INSERT INTO users (id, name) VALUES (1, 'David');"))
with pytest.raises(Exception):
conn.execute(text("INSERT INTO users (id, name) VALUES (1, 'Eve');"))Test Case 5 — Truncate Table
✅ PassedClears the table and confirms it's empty.
conn.execute(text("TRUNCATE TABLE users;"))
result = conn.execute(text("SELECT COUNT(*) FROM users;")).fetchone()
assert result[0] == 0🚀 How to Run the Tests
Quick Start
pytest -v testcontainers/test_mysql_container.py✅ Expected Output:
5 passed in X.XXsUseful Commands
See running containers:
docker psCheck MySQL logs:
docker logs <container_id>🧪 Chaos Testing Scenarios
Real-World Failure Simulation
Test your application's resilience against common MySQL failures
Scenario 1: Connection Failures
Connection ErrorTest that your app handles MySQL connection failures gracefully
def test_mysql_connection_failure():
"""Test that our app handles MySQL connection failures gracefully"""
with MySqlContainer("mysql:8.0") as mysql:
# Simulate connection failure
mysql.get_docker_client().stop(mysql.get_container_id())
# Verify our app handles the failure
with pytest.raises(ConnectionError):
create_connection(mysql.get_connection_url())Scenario 2: Slow Queries
Performance IssueTest that your app handles slow MySQL queries within timeouts
def test_mysql_slow_query_handling():
"""Test that our app handles slow MySQL queries"""
with MySqlContainer("mysql:8.0") as mysql:
conn = create_connection(mysql.get_connection_url())
# Simulate slow query
import time
start_time = time.time()
# Execute a potentially slow query
conn.execute(text("SELECT SLEEP(2)"))
# Verify it completes within reasonable time
assert time.time() - start_time < 5.0📊 Monitoring & Reporting
Generate Beautiful Reports
Create comprehensive HTML reports for stakeholders
📊 Generate HTML Report
pytest testcontainers/test_mysql_container.py \
--html=reports/mysql-test-report.html \
--self-contained-htmlCreates a beautiful HTML report with test results and metrics
📋 View Container Logs
# Get container ID
docker ps | grep mysql
# View logs
docker logs <container_id>Monitor container behavior and debug issues