How to use non-default DB connection with eloquent in Laravel
Categorized as Laravel
When you use the Laravel eloquent models on a non-default database connection, the default database transaction will not work. You have to specify the DB connection type before opening the transaction.
// Update users and posts
DB::connection('mysql_2')->transaction(function () {
\App\Models\User::query()->update([...]);
\App\Models\Post::query()->update([...]);
}, 5);