[Sqlgrey-users] fallback mysql server

[Robert Schetterer]

Hi,
is there the option to use a fallback
database server

i.e like

db_host = 192.168.125.1 192.168.125.2

[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

Greetings

Frank

-----Original Message-----
From: Robert Schetterer [mailto:***@schetterer.org]
Sent: Sunday, March 13, 2011 8:52 AM
To: sqlgrey-***@lists.sourceforge.net
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

[Robert Schetterer]

Post by 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 ...?

Post by Urban, Frank (GS-ITR)
Greetings
Frank
-----Original Message-----
Sent: Sunday, March 13, 2011 8:52 AM
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

[Urban, Frank (GS-ITR)]

Im only a user of Sqlgrey not a developer.
But how should it work if you will send the data to several write hosts?
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.

-----Original Message-----
From: Robert Schetterer [mailto:***@schetterer.org]
Sent: Monday, March 14, 2011 8:53 AM
To: sqlgrey-***@lists.sourceforge.net
Subject: Re: [Sqlgrey-users] fallback mysql server

Post by 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 ...?

Post by Urban, Frank (GS-ITR)
Greetings
Frank
-----Original Message-----
Sent: Sunday, March 13, 2011 8:52 AM
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

[Robert Schetterer]

Post by Urban, Frank (GS-ITR)
Im only a user of Sqlgrey not a developer.

ok was just a question

Post by Urban, Frank (GS-ITR)
But how should it work if you will send the data to several write hosts?

that shouldnt care sqlgrey in first case

Post by Urban, Frank (GS-ITR)
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

Post by Urban, Frank (GS-ITR)
-----Original Message-----
Sent: Monday, March 14, 2011 8:53 AM
Subject: Re: [Sqlgrey-users] fallback mysql server

Post by 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 ...?

Post by Urban, Frank (GS-ITR)
Greetings
Frank
-----Original Message-----
Sent: Sunday, March 13, 2011 8:52 AM
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