Re: [exim] Different MySQL connections for different jobs

Mike Cardwell wrote:

*snip*

Overlooked something here...

>
> I did consider configuring it in such a way that we have:
>
> hide mysql_servers = slavedetails : masterdetails
>
> When it tries to write to the slave it could fail, and then attempt the
> write to the master, which then replicates back to the slave. That's not
> a very tidy solution though.
>

Actually it might be, even as-is.

IF you use a different table-name in the master (or set of same) than name(s)
you export to the slave (same data), AFAIK it will skip the slave 'coz the
called tables do not match.

> I'd rather choose the db connection explicitly than exim to try them
> in order until one works...
>

Worth a try?

I'm not able to test easily right now.

Bill