Am 14.03.2011 09:02, schrieb Urban, Frank (GS-ITR):
> Im only a user of Sqlgrey not a developer.
ok was just a question
> But how should it work if you will send the data to several write hosts?
that shouldnt care sqlgrey in first case
> Make no sense. Or are you using a master-master replication on the sql database servers?
> Its possibel that this works in Version 1.8. Didn't checked this.
replication is mysql stuff , there is no direct logical connect to
applications, they should work by its own
i.e.
the application should give some failure if it cant write/read to a db
host whatever if you use 1 or hundred of them, in failure case sqlgrey
should use then the working one automatic
but ok for now i will look in the newest sqlgrey code
read on 2 db hosts maybe enough for me
>
> -----Original Message-----
> From: Robert Schetterer [mailto:ro...@sc...]
> Sent: Monday, March 14, 2011 8:53 AM
> To: sql...@li...
> Subject: Re: [Sqlgrey-users] fallback mysql server
>
> Am 14.03.2011 07:27, schrieb Urban, Frank (GS-ITR):
>> Hi,
>> as far as I know only for a reading in Version 1.7.
>>
>> read_hosts = 192.168.125.1,192.168.125.2
>
> sorry does this mean there is only one db host for write but an option
> to have 2 hosts for reading?
>
> and if so what does sqlgrey do if the write host dissapear?
> is there enough logic coded that there is no desaster output in that
> case ...?
>>
>> Greetings
>>
>> Frank
>>
>> -----Original Message-----
>> From: Robert Schetterer [mailto:ro...@sc...]
>> Sent: Sunday, March 13, 2011 8:52 AM
>> To: sql...@li...
>> Subject: [Sqlgrey-users] fallback mysql server
>>
>> Hi,
>> is there the option to use a fallback
>> database server
>>
>> i.e like
>>
>> db_host = 192.168.125.1 192.168.125.2
>>
>>
>
>
--
Best Regards
MfG Robert Schetterer
Germany/Munich/Bavaria
|
