Download the PHP package masom/lhm without Composer
On this page you can find all versions of the php package masom/lhm. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.
Informations about the package lhm
Large Hadron Migrator
This is a PHP port of https://github.com/soundcloud/lhm . lhm_php supports primary keys with a name other than id
.
Version 0.4.0 is considered "production-ready". It is in use at PopKey.co to migrate millions of records.
TODO
- [x] [SqlHelper] Support column renames
- [x] [LHM] Support cleanup
- [ ] [Chunker] data limits/filtering
- [ ] [Chunker] throttle
- [x] [Switchers] Locked switcher
- [x] add index / remove index
Usage
Cleanup
If there is an error while LHM is running a few triggers and tables might be left in the database.
bin/lhm
command will let you clean your database.
It executes a dry-run unless the --run
option is specified.
AWS Considerations
Amazon RDS disables log_bin_trust_function_creators
by default.
See https://github.com/soundcloud/lhm/issues/76 and https://github.com/soundcloud/lhm/issues/65
If your database instance is running a custom parameter group:
- Open the RDS web console.
- Open the “Parameter Groups” tab.
- Create a new Parameter Group. On the dialog, select the MySQL family compatible to your MySQL database version, give it a name and confirm.
- Select the just created Parameter Group and issue “Edit Parameters”.
- Look for the parameter ‘log_bin_trust_function_creators’ and set its value to ‘1’.
- Save the changes.
The changes to the parameter group will be applied immediately.
If your database instance is running on the default parameter group:
- Open the RDS web console.
- Open the “Parameter Groups” tab.
- Create a new Parameter Group. On the dialog, select the MySQL family compatible to your MySQL database version, give it a name and confirm.
- Select the just created Parameter Group and issue “Edit Parameters”.
- Look for the parameter ‘log_bin_trust_function_creators’ and set its value to ‘1’.
- Save the changes.
- Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Modify”.
- Select the just created Parameter Group and enable “Apply Immediately”.
- Click on “Continue” and confirm the changes.
- Open the “Instances” tab. Expand your MySQL instance and issue the “Instance Action” named “Reboot”.
source: https://techtavern.wordpress.com/2013/06/17/mysql-triggers-and-amazon-rds/
All versions of lhm with dependencies
psr/log Version ^1.0.0
symfony/console Version ~2
symfony/event-dispatcher Version ~2
symfony/monolog-bridge Version ~2