Project:Infrastructure/MysqlMigration

This page contains scratchpad notes on MySQL cluster migration.

Mysql cluster migration

grebe / grouse are two old mysql masters.

groundroller / goldeneye are the two new mysql masters

Determine what is mastered on grebe / grouse

1. gentoo-adopt-a-dev: We think this is not needed, dump it and delete.
2. gentoo-bugday: We think this is not needed, dump it and delete.
3. gentoo-bugs: Mastered on grebe / grouse
4. gentoo-bugstest: mastered on grebe / grouse
5. gentoo-wiki: grknight says mastered on galera
6. gentoo-wiki-test: grknight says mastered on galera
7. gentoo_forums: mastered on grebe / grouse.
8. gentoo_forumstest: mastered on grebe / grouse.
9. gentoo_sources: We don't think we need this, dump it and delete.

old stuff

groundroller ~ # for table in gentoo-adopt-a-dev gentoo_sources gentoo-bugday > do > mysqladmin drop "$table" > done Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed.

Do you really want to drop the 'gentoo-adopt-a-dev' database [y/N] yes Database "gentoo-adopt-a-dev" dropped Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed.

Do you really want to drop the 'gentoo_sources' database [y/N] yes Database "gentoo_sources" dropped Dropping the database is potentially a very bad thing to do. Any data stored in the database will be destroyed.

Do you really want to drop the 'gentoo-bugday' database [y/N] yes Database "gentoo-bugday" dropped

upload: ./gentoo-adopt-a-dev-Fri 11 Sep 2020 07:47:58 PM UTC to s3://gentoo-private-archive/grebe-mysql/gentoo-adopt-a-dev-Fri 11 Sep 2020 07:47:58 PM UTC upload: ./gentoo-bugday-Fri 11 Sep 2020 07:48:05 PM UTC to s3://gentoo-private-archive/grebe-mysql/gentoo-bugday-Fri 11 Sep 2020 07:48:05 PM UTC upload: ./gentoo-sources-Fri 11 Sep 2020 07:47:21 PM UTC to s3://gentoo-private-archive/grebe-mysql/gentoo-sources-Fri 11 Sep 2020 07:47:21 PM UTC

upload: ./gentoo-adopt-a-dev-2020-09-11 to s3://gentoo-private-archive/groundroller-backups/gentoo-adopt-a-dev-2020-09-11 upload: ./gentoo-bugday-2020-09-11 to s3://gentoo-private-archive/groundroller-backups/gentoo-bugday-2020-09-11 upload: ./gentoo_sources-2020-09-11 to s3://gentoo-private-archive/groundroller-backups/gentoo_sources-2020-09-11

Galera

Dump and drop:

1. gentoo-bugs
2. gentoo-bugstest
3. gentoo-forums
4. gentoo-forumstest