{"repo":"Aiven-Open/aiven-mysql-migrate","free":true,"listed":false,"github":"https://github.com/Aiven-Open/aiven-mysql-migrate","clone":"git clone https://github.com/Aiven-Open/aiven-mysql-migrate.git","description":"MySQL® migration tool","language":"Python","stars":14,"topics":["mysql","migration","database"],"license":"Apache-2.0","category":"databases-storage","readme_excerpt":"aiven-mysql-migrate The aim of this tool is to help migrate MySQL servers from one place to another. aiven-mysql-migrate supports two methods of migration: mysqldump + replication This method is preferred for production databases because it allows migrating data with a minimal downtime. The way it works - aiven-mysql-migrate checks if all preconditions are met for this method and starts coping initial data dump from the source database to the target using mysqldump/mysql tools. This will not lock the origin database. Once the initial dump is copied, the target database will set up the replication from the source and set the GTID (Global Transaction Identifier) from the dump. This will let the target database start getting changes from the source database which were made while initial dump migration. When the source and target database are in sync, the user can stop the source database and switch to using the target database. The replication can be stopped at this point. Pre-conditions: The source database should be in = 5.7 and = 8, source DB: = 5.7. InnoDB engine: if MyISAM engine is used (even partially) replication method will not work System databases/tables ( information schema. , mysql. , performance schema. , sys. ) are excluded from migration (DB users need to be pre-created on a target database beforehand). Functions/triggers/events will be created during the initial import, however they won't be synchronized while the import is in progress, so there should be no cha","default_branch":null,"files":null,"tree":[],"storefront":"/r/Aiven-Open","claimed":false,"request_supported":{"post":"https://gitbuyer.com/r/Aiven-Open/aiven-mysql-migrate/request-supported","requests":0},"note":"indexed from public GitHub; nothing is for sale on this page. Clone it from GitHub. Paid listings live at /search."}