Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Jim Starkey
On 9/25/2014 3:43 PM, Dimitry Sibiryakov wrote: > 25.09.2014 21:27, Leyne, Sean wrote: >> Installing on physical server means that you have a single point of failure. > Modern storage systems claim that they have no single point of failure, > BTW. Some of > them even allows two or more servers

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Leyne, Sean
>Modern storage systems claim that they have no single point of failure, > BTW. Some of them even allows two or more servers to be attached. I know, I have bought a couple of those systems in the past. >But all this is pointless because Firebird server itself is a SPoF. True, but that

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Leyne, Sean
> 25.09.2014 21:58, Leyne, Sean wrote: > > All changes are written to disk first > >Which one in, say, ten nodes cluster? A cluster share always has an elected/nominated primary node (set per share/resource). The non-primary nodes can service all requests but write requests are re-direct

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Dimitry Sibiryakov
25.09.2014 21:58, Leyne, Sean wrote: > All changes are written to disk first Which one in, say, ten nodes cluster? > Further, all that is required for a write operation is to send a message > which invalidates the cache object when the write happens. The propogation > of the changed data ca

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Leyne, Sean
> 25.09.2014 21:27, Leyne, Sean wrote: > > Having a SQL/FB running in VM on a HA VM cluster connected to HA disk > storage cluster provides a high level of resiliency, with multiple failures > necessary in order for functionality to be lost. > >I wonder how they manage synchronization betwee

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Dimitry Sibiryakov
25.09.2014 21:27, Leyne, Sean wrote: > Installing on physical server means that you have a single point of failure. Modern storage systems claim that they have no single point of failure, BTW. Some of them even allows two or more servers to be attached. But all this is pointless because Fi

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Dimitry Sibiryakov
25.09.2014 21:27, Leyne, Sean wrote: > Having a SQL/FB running in VM on a HA VM cluster connected to HA disk storage > cluster provides a high level of resiliency, with multiple failures necessary > in order for functionality to be lost. I wonder how they manage synchronization between nodes

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Leyne, Sean
> 25.09.2014 18:25, Leyne, Sean wrote: > > I am not aware of SQL Server running on SMB anything other than SMB v3. > It would be far too dangerous. > >If a server supports SMB3, it means that it has Windows inside, because > Samba doesn't support SMB3 yet. So, I wonder what can preventing an

[Firebird-devel] [FB-Tracker] Created: (CORE-4559) Random exception SQL error code = -502 - Invalid cursor declaration using fb embedded from a service - bad cursor GUID

2014-09-25 Thread Francesco Pucino (JIRA)
Random exception SQL error code = -502 - Invalid cursor declaration using fb embedded from a service - bad cursor GUID -- Key: CORE-4559 URL: http:

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Dimitry Sibiryakov
25.09.2014 18:25, Leyne, Sean wrote: > I am not aware of SQL Server running on SMB anything other than SMB v3. It > would be far too dangerous. If a server supports SMB3, it means that it has Windows inside, because Samba doesn't support SMB3 yet. So, I wonder what can preventing anyone fro

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Leyne, Sean
> > Jiri Could you do some tests on a smb 3 share with Firebird ? > > I don't have a device with SMB3 support or Windows 2012 machine. I can > install it to VM, but that's not going to show valuable data, I think. To truly test SMB 3 you would need to create a MS cluster, which will require a

Re: [Firebird-devel] MS SQL over SMB2

2014-09-25 Thread Leyne, Sean
> > I do not see SMB 2 as an appropriate for use for database functions. > > I was confused by SMB2/2.1 as well. I thought it might be good to investigate > what they are doing (preventing problems, how the share is opened, ...). I am not aware of SQL Server running on SMB anything other than S

[Firebird-devel] [FB-Tracker] Created: (CORE-4558) FB 2.5.3 Superserver Dies when client disconnected abnormally

2014-09-25 Thread Sergey Maslikov (JIRA)
FB 2.5.3 Superserver Dies when client disconnected abnormally - Key: CORE-4558 URL: http://tracker.firebirdsql.org/browse/CORE-4558 Project: Firebird Core Issue Type: Bug