Re: [Exim] Multiple MySQL databases and hosts

Startseite
Nachricht löschen
Nachricht beantworten
Autor: V. T. Mueller
Datum:  
To: Ollie Cook
CC: exim-users
Betreff: Re: [Exim] Multiple MySQL databases and hosts
On Wed, 5 Dec 2001, Ollie Cook wrote:
>  mysql_servers = set1/host1::3306/database1/user1/password1\
>                  set1/backup-host1::3306/database1/user1/password1\
>                  set2/host2::3306/database2/user2/password2\
>                  set2/backup-host2::3306/database2/user2/password2
> This would still allow for redundancy, but still cut down on the
> erroneous connections to database which have no hope of answering
> the query.


Hm. I could live with that, along with a certain amount of pain.

Again: If you encounter performance problems on host1, put in another cpu.
If you encounter disk space problems, put in disks and increase the
respective logical volume [or deal with disks, mountpoints and syslinks if
your OS is not lvm capable]. At least it appears as if triggering a little
SQL error msg does worry you you have a rather high volume site - so you
should be able to invest in hardware instead of tweaking software in a
doubtful direction.

The software's job, however is to be as simple as possible.
Experience tells us that software / site design changes provoke failures.
But I've never seen a service failing because someone added diskspace ;)

Maybe my view on this is too much HA-coloured, but at least this is what I
think.

Someone else's opinion?

Regards,
Volker
--
V. T. Mueller      Freiburg, Germany     vtmue (at) uni-freiburg.de


           "problems are just opportunities in work cloth"