PHP download

Download the PHP package always-open/laravel-online-migrator without Composer

On this page you can find all versions of the php package always-open/laravel-online-migrator. It is possible to download/install these versions without Composer. Possible dependencies are resolved automatically.

Table of contents
Download always-open/laravel-online-migrator
More information about always-open/laravel-online-migrator
Files in always-open/laravel-online-migrator

Vendor always-open
Package laravel-online-migrator
Short Description Apply Laravel's database migrations with minimal disruptions using tools like Percona Online Schema Change
License MIT
Homepage https://github.com/always-open/laravel-online-migrator

Keywords migration laravel laravel-online-migrator always-open

FAQ

After the download, you have to make one include require_once('vendor/autoload.php');. After that you have to import the classes with use statements.

Example:

If you use only one package a project is not needed. But if you use more then one package, without a project it is not possible to import the classes with use statements.

In general, it is recommended to use always a project to download your libraries. In an application normally there is more than one library needed.

Some PHP packages are not free to download and because of that hosted in private repositories. In this case some credentials are needed to access such packages. Please use the auth.json textarea to insert credentials, if a package is coming from a private repository. You can look here for more information.

Some hosting areas are not accessible by a terminal or SSH. Then it is not possible to use Composer.
To use Composer is sometimes complicated. Especially for beginners.
Composer needs much resources. Sometimes they are not available on a simple webspace.
If you are using private repositories you don't need to share your credentials. You can set up everything on our site and then you provide a simple download link to your team member.
Simplify your Composer build process. Use our own command line tool to download the vendor folder as binary. This makes your build process faster and you don't need to expose your credentials for private repositories.

Please rate this library. Is it a good library?

Example code of always-open/laravel-online-migrator

Informations about the package laravel-online-migrator

Laravel Online Migrator

This package minimizes disruptions when applying Laravel's database migrations using tools like Percona Online Schema Change or InnoDB Online DDL. For example, one can write (mostly) standard Laravel migration files then run "php artisan migrate". Database changes will be automatically converted into PTOSC commands or online DDL queries.

Installation

You can install the package via composer:

The pt-online-schema-change command from Percona's toolkit must be in the path where Artisan will be run, unless InnoDB Online DDL is being used exclusively.

Configuration

Publish the configuration file:

If not using discovery then add the provider to config/app.php:

If changing tables with enum columns consider working around "Unknown database type enum requested" by tweaking config/online-migrator.php:

or .env with DOCTRINE_ENUM_MAPPING=string

Usage

Run Artisan's migrate to apply migrations online*:

*Limitations are documented below.

Preview what changes it would make:

Add PTOSC options using environment variables:

Flag migrations known to be incompatible with this tool using the built-in trait:

Use a different strategy for a single migration:

Do not combine queries for a migration when using PTOSC:

Adding foreign key with index to existing table:

Limitations

Only supports Mysql, specifically those versions supported by PTOSC v3
With PTOSC
- Adding unique indexes may cause data loss unless tables are manually checked beforehand because of how PTOSC works
- Adding not-null columns requires a default
- Renaming a column or dropping a primary key have additional risks
- Foreign key creation should be done separately from column creation or duplicate indexes may be created with slightly different naming
- Close the Schema::create() call and make a separate Schema::table() call for all FKs in the migration
With InnoDB Online DDL
- See the MySQL Online DDL documentation
- May be problematic on AWS Aurora
Stateful migrations, like those selecting then saving rows, will instead need to do one of the following:
- Use non-selecting queries like MyModel::where(...)->update(...)
- Pipe the raw SQL like \DB::statement('UPDATE ... SET ... WHERE ...');
- Use the OnlineMigratorIncompatible trait to mark the migration as incompatible

Testing

Output is verbose because passthru is used to help debug production problems. Executing as phpunit --testdox may be more readable until the verbosity can be tamed.

Contributing

Please see CONTRIBUTING for details.

Security

If you discover any security related issues, please email [email protected] instead of using the issue tracker.

Credits

Paul R. Rogers
All Contributors
Percona Team for pt-online-schema-change

License

The MIT License (MIT). Please see License File for more information.

All versions of laravel-online-migrator with dependencies

PHP Build Version

Package Version

Version v7.0.0 Release 13. Sep 2022
create-project require 0 people choosed require and
0 people choosed create-project.

Download

Download latest version of laravel-online-migrator from vendor always-open

Requires php Version ^8.0.0|^8.1.0
laravel/framework Version ^8.0|^9.0

Composer command for our command line client (download client) This client runs in each environment. You don't need a specific PHP version etc. The first 20 API calls are free. Standard composer command

The package always-open/laravel-online-migrator contains the following files

Loading the files please wait ....