MySQL sync

I have a scenario with a 'warm' standby server located on a VPS in a different datacentre. It does not need to be synced in real time as all data is transient, but it does need to be daily synced.

A console command on the Live system uses Spatie DBDumper to create a dump of certain tables into a file on an S3 bucket. Both systems have access to the same bucket. At a time after the dump was created, the standby system pulls the file from S3 and applies it to its copy.

I've pasted the two commands below. They are pretty simple to understand.

DumpDB.php

<?php

namespace App\Console\Commands;

use Illuminate\Console\Command;
use Illuminate\Support\Facades\Storage;
use League\Flysystem\MountManager;
use Spatie\DbDumper\Databases\MySql;

class DumpDb extends Command
{
    protected $signature = 'app:dumpdb';

    protected $description = 'Creates a copy of the database so that it can be picked up by the standby';

    public function __construct()
    {
        parent::__construct();
    }

    public function handle()
    {

        $filename= 'latest-db.sql';

        MySql::create()
            ->setDbName(config('database.connections.mysql.database'))
            ->setUserName(config('database.connections.mysql.username'))
            ->setPassword(config('database.connections.mysql.password'))
            ->setDumpBinaryPath(config('database.connections.mysql.dump.dump_binary_path'))
            ->includeTables(['system_user','systems','users','lookups','features','consignments', 'postcodes', 'timeanddistance', 'reports', 'sites'])
            ->dumpToFile(storage_path('app/db/' . $filename));

        $mountManager = new MountManager([
            's3' => Storage::disk('s3')->getDriver(),
            'local' => Storage::disk('local')->getDriver(),
        ]);

        Storage::disk('s3')->delete($filename);

        $mountManager->copy('local://db/'.$filename, 's3://'.$filename);

        return 0;
    }
}

PullDb.php

<?php

namespace App\Console\Commands;

use App\System;
use Illuminate\Console\Command;
use Illuminate\Support\Facades\DB;
use Illuminate\Support\Facades\File;
use Illuminate\Support\Facades\Log;
use Illuminate\Support\Facades\Storage;
use League\Flysystem\MountManager;

class PullDb extends Command
{
    protected $signature = 'app:pulldb';

    protected $description = 'fetches database copy from S3 and inserts into local database';

    public function __construct()
    {
        parent::__construct();
    }

    public function handle()
    {
        $this->info('Getting the backup.');

        $filename= 'latest-db.sql';

        //get copy of the database from server
        $mountManager = new MountManager([
            's3' => Storage::disk('s3')->getDriver(),
            'local' => Storage::disk('local')->getDriver(),
        ]);

        if(File::exists(storage_path('app/db/' . $filename))) {
            File::delete(storage_path('app/db/' . $filename));
        }

        $mountManager->copy('s3://' . $filename, 'local://db/' . $filename);

        //insert db into local database
        $this->info('Importing...');

        //run the sql script to import the database tables.
        try {
            DB::beginTransaction();
            DB::unprepared(File::get(storage_path('app/db/' . $filename)));
            DB::commit();
        } catch (\Throwable $th) {
            DB::rollBack();
            Log::error('Importing the production database from the copied file failed');
        }
                
        Log::info('successfully imported partial database from the live system');

        return 0;
    }
}