Laravel 8 Change database connection globally in the runtime

Question

My requirement is pretty simple and I found a lot of solutions, but none of them is working for me.

I have two MySQL databases, one where all write operations will happen and there is a replica of this database, which is read-only. I am creating a middleware where if a request is GET, it should use read-only database otherwise main databases.

I already have tried these:

DB::disconnect();
Config::set('database.default', 'mysql_readonly');
DB::reconnect('mysql_readonly');


Config::set('database.default', 'mysql_readonly');
DB::purge('mysql_readonly');


DB::disconnect();
Config::set('database.default', 'mysql_readonly');
DB::connection('mysql_readonly');

None of the solutions is working.

Laravel Version: 8.59.0
PHP Version: 8.0.10

Instead of "right operations" you mean "write operations"?

James Z
– James Z

2021-10-22 18:52:21 +00:00
Commented Oct 22, 2021 at 18:52 — James Z
– James Z, Commented Oct 22, 2021 at 18:52
Yes, typo error. @JamesZ

Sunny Kumar
– Sunny Kumar

2021-10-23 05:53:28 +00:00
Commented Oct 23, 2021 at 5:53 — Sunny Kumar
– Sunny Kumar, Commented Oct 23, 2021 at 5:53

Sunny Kumar · Accepted Answer · 2021-10-25 13:45:50Z

1

I found the working solution.

$readOnlyConfig = config('database.connections.mysql_readonly');
Config::set('database.connections.mysql', $readOnlyConfig);
DB::purge();

answered Oct 25, 2021 at 13:45

Sunny Kumar

5541 gold badge12 silver badges37 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

ceejayoz Over a year ago

Yep, that'll do it. I really wish they'd picked a different function name than purge, because it's a little terrifying the first couple times.

Collectives™ on Stack Overflow

Laravel 8 Change database connection globally in the runtime

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related