Skip to content

Demonstrating gh-ost functionality using local mysql servers

Notifications You must be signed in to change notification settings

bitovi/medline-ghost-demo

Folders and files

NameName
Last commit message
Last commit date

Latest commit

 

History

9 Commits
 
 
 
 
 
 
 
 
 
 
 
 

Repository files navigation

medline-ghost-demo

Demo repo to show functionality of gh-ost to clients

  1. run docker compose up to create a pair of mysql 8.0 servers with distinctly configured server_id's (needed for row based replication)
  2. run ./scripts/initial-setup.sh to create a user for replication, configure the master/slave to allow replication, and start replication
  3. run ./scripts/init-seeds.sh to create a generic users table, and seed with randomly generated records
  4. [todo] execute gh-ost targeting our local environment, as "Test on replica"
    • [todo] verify new table has changes made, and has expected records
    • docs here
  5. [todo] execute gh-ost targeting our local environment, as "Migrate on replica"
    • [todo] verify ghost table is gone, and replication is still continuing

About

Demonstrating gh-ost functionality using local mysql servers

Resources

Stars

Watchers

Forks

Releases

No releases published

Packages

No packages published

Languages