[Request] Implement automated read/write connections in Eloquent

[ipalaus]

For those we use master/slave connections in our applications it will be cool to have some way we can setup so Eloquent auto-detects it.

There is various scenarios on how this can be implemented but a basic SELECT => slave connection, INSERT, DELETE, UPDATE => master will be fantastic.

Thanks!

[JavierMartinz]

+1

[mitchellvanw]

+1

[bencorlett]

+1

[taylorotwell]

Frankly I think this is already fairly easy:

User::on('connection-name')->where('foo', 1)->get();

Baking throughout each and every insert throughout the framework would be tedious, and I think it is pretty manageable by the application.

[philsturgeon]

@taylorotwell: When I proposed this feature to you a few months ago you suggested it would be a feature you'd consider for 4.1. This was fair enough, because its not a fundamental feature and I can imagine other things are of a higher priority, but other people are asking for the same thing. I don't think its as easy as you suggest to implement in applications, but if the feature was implemented then usage would be as simple as changing your config to this:

'connections' => [
    'mysql' => [
        'read' => [
            'driver'   => 'mysql',
            'host' => 'slave-server',
            'database' => 'kapture',
            'username' => 'kapture',
            'password' => 'password',
            'prefix' => '',
            'charset'  => 'utf8',
            'collation'  => 'utf8_unicode_ci',
        ],
        'write' => [
            'driver'   => 'mysql',
            'host' => 'primary-server',
            'database' => 'kapture',
            'username' => 'kapture',
            'password' => 'password',
            'prefix' => '',
            'charset'  => 'utf8',
            'collation'  => 'utf8_unicode_ci',
        ]
    ],
],

This would make it amazingly easy for a ORMed up Laravel application to suddenly scale up their entire architecture without having to recode their entire application. I could switch Kapturefrom using one database server to using a Read-only Replica on RDS and use the primary server for slower writes.

I'd really like this feature to be re-opened, even if its not worked on straight away. Somebody else might want to add it as a pull request if they get the time - but an outright "no" doesn't help anyone.

[taylorotwell]

Re-opening so that Phil doesn't hit me at Laracon. I really will consider it further down the line for things like 4.1.

[philsturgeon]

:D

Phil Sturgeon

On Friday, 25 January 2013 at 10:02, Taylor Otwell wrote:

Re-opening so that Phil doesn't hit me at Laracon. I really will consider it further down the line for things like 4.1.

—
Reply to this email directly or view it on GitHub (#5 (comment)).

[ipalaus]

Thanks :)

[taylorotwell]

This needs to be discussed further in terms of configuration... What if you have multiple read slaves? Multiple write servers? What would the configuration look like? Someone who is actually doing or needs this in production please contribute to these questions.

[maximebeaudoin]

We will need something like this in production soon. I'll discuse this with my team and give you some feeback and, hopefully, with great ideas :)

[philsturgeon]

Didn't we completely work out the entire plan for this already on Skype?

Sent from my iPhone

On Jun 1, 2013, at 9:13 PM, Taylor Otwell notifications@github.com wrote:

This needs to be discussed further in terms of configuration... What if you have multiple read slaves? Multiple write servers? What would the configuration look like? Someone who is actually doing or needs this in production please contribute to these questions.

—
Reply to this email directly or view it on GitHub.

[taylorotwell]

We need more input than just us :)

On Jun 1, 2013, at 8:59 PM, Phil Sturgeon notifications@github.com wrote:

Didn't we completely work out the entire plan for this already on Skype?

Sent from my iPhone

On Jun 1, 2013, at 9:13 PM, Taylor Otwell notifications@github.com wrote:

This needs to be discussed further in terms of configuration... What if you have multiple read slaves? Multiple write servers? What would the configuration look like? Someone who is actually doing or needs this in production please contribute to these questions.

—
Reply to this email directly or view it on GitHub.
—
Reply to this email directly or view it on GitHub.