Blenra LogoBlenra
Optimized for: Gemini / ChatGPT / Claude
#Database

Implementing Ghost Migrations for Large-Scale MySQL Table Refactoring

Customize the variables below to instantly engineer your prompt.

Required Variables

ghost-migrations-mysql-automation.txt
As a Technical Architect, provide a production-ready configuration for using 'gh-ost' (GitHub's Online Schema Change tool) to migrate a [TABLE_SIZE] table. Integrate this into a [CI_CD_RUNNER] workflow. Define the specific throttling parameters ([GH_OST_THROTTLE_PARAMS]) to prevent replica lag and master load. Explain the cut-over strategy and how to automate the cleanup of the ghost tables post-migration. Include a contingency plan for a failed cut-over.

Example Text Output

"A YAML configuration for a GitLab CI job that executes gh-ost with dynamic load-based throttling, ensuring the 1TB table is refactored without locking the production database."

More Cloud & DevOps Prompts

View all →

Frequently Asked Questions

What is the "Implementing Ghost Migrations for Large-Scale MySQL Table Refactoring" prompt used for?

A YAML configuration for a GitLab CI job that executes gh-ost with dynamic load-based throttling, ensuring the 1TB table is refactored without locking the production database.

Which AI tools work with this prompt?

This prompt is optimized for Gemini / ChatGPT / Claude, but works great with ChatGPT, Claude, Gemini, and other large language models. Simply copy it and paste it into your preferred AI tool.

How do I customize this prompt?

Use the variable fields above to fill in your specific details. The prompt will auto-update as you type, ready to copy instantly.

Is this prompt free?

Yes! All prompts on Blenra are free to copy and use immediately. No account required.