Re: [Sqlgrey-users] fallback mysql server

[Robert S. <ro...@sc...>]

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