Sync remote database to a local database or vice-versa

Note this requires remote MySQL connection to sync the database, and that need to be defined in database.php

Install the package.
Note: This extension works in Laravel 8 and above.

composer require khaleejinfotech/laravel-db-sync

You can publish the config file with:

php artisan vendor:publish --provider="Khaleejinfotech\LaravelDbSync\LaravelDbSyncServiceProvider" --tag="laravel-db-sync"

Set the remote database credentials in your config/database.php file

'connections' => [
    ...
    
    'mysql_remote' => [
        'driver' => 'mysql',
        'url' => env('DATABASE_URL'),
        'host' => env('DB_HOST', '127.0.0.1'),
        'port' => env('DB_PORT', '3306'),
        'database' => env('DB_DATABASE', 'forge'),
        'username' => env('DB_USERNAME', 'forge'),
        'password' => env('DB_PASSWORD', ''),
        'unix_socket' => env('DB_SOCKET', ''),
        'charset' => 'utf8mb4',
        'collation' => 'utf8mb4_unicode_ci',
        'prefix' => '',
        'prefix_indexes' => true,
        'strict' => true,
        'engine' => null,
        'options' => extension_loaded('pdo_mysql') ? array_filter([
            PDO::MYSQL_ATTR_SSL_CA => env('MYSQL_ATTR_SSL_CA'),
        ]) : [],
    ],
    
    ...
],

To observe changes in records and to sync with remote/local database you must use Syncable to your model, by default this package uses its own observer, but you can replace it with your own having the same code of this observer and your custom logics.

You can replace the observer class from the config/laravel-db-sync.php file.

...
'observer_class' => \Khaleejinfotech\LaravelDbSync\Observers\ModelObserver::class,
...

Note: observer method will only be triggered on eloquent model.

You can also create a base model with use Syncable and can extend your child models, in this case if you ever wanted to ignore a certain model(s) you can ignore them by specifying in the config/laravel-db-sync.php file like this:

...
'ignore_models' => [
    // Models to be ignored if sync booted in base model.
    User::class,
],
...

After setting up connections in the config/database.php file you must have to add connection names where the data has to be synced.

'targets' => [
    // database connection names
    'mysql_remote',
],

Note: Please specify only remote connections here else it may cause data duplication or may fall into an error.

If a model handle files then in the configuration file the columns of the model should be defined so that the files can be synced to the local/remote servers.

...
    /*\App\Models\Model::class => [
        [
            'column_name' => 'photo',
            'remote_disks' => [
                // remote disks locations from filesystem config file.
                'ftp'
            ],
            'local_disk' => 'public',
            'upload_path_local' => 'folder',
            'upload_path_remote' => 'folder',
        ]
    ],*/
...

This will create job for each record that need to be synced.

php artisan sync:local

After that you need run the queue

php artisan queue:work

This will create job for each record that need to be synced.

php artisan sync:remote

After that you need run the queue

php artisan queue:work

Suggestion: configure scheduler for above commands to automate synchronization.