Re: [sqlite] Safe to use SQLite over a sketchy network?
On 26/09/2019 15:30, Keith Medcalf wrote: -Original Message- From: sqlite-users On Behalf Of Gary R. Schmidt Sent: Wednesday, 25 September, 2019 23:13 To: sqlite-users@mailinglists.sqlite.org Subject: Re: [sqlite] Safe to use SQLite over a sketchy network? On 26/09/2019 15:00, Jens Alfke wrote: On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote: There are not, to my knowledge, any client/server database systems that will work properly if the database resides on a network filesystem (meaning remote multi-access). The "client" is remote from the "server" because the "client" and "server" use some sort of IPC mechanism (of which a network is an example) so that the "client" can send commands to and receive responses from the "server". Well, obviously. “Client/server” means databases like MySQL or Oracle. No one would run those with the server using a networked file system. I might have dreamt it, but NetAPP had an add-on for Oracle, quite probably still do, that enhanced performance and behaviour when used for storage. Not sure if it was applied to the server or the NAS, possibly both, but it was an Oracle-recommended solution for large storage requirements. [Top-posting fixed.] > > That is remote block storage, not a remote filesystem. Remote block > storage just has a "longer wire" going to the block storage. iSCSI, > for example, will let you put your block storage anywhere, even in > orbit. The filesystem, however, still resides on the local computer. > No, it was over NFS, and while it could be used to give Oracle a "raw partition," it was intended to be used as a file-system that could be managed by the NAS, and allowed for the files to accessed by more than one Oracle server instance. This was before we got Oracle RAC, I should mention. Cheers, GaryB-) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Safe to use SQLite over a sketchy network?
That is remote block storage, not a remote filesystem. Remote block storage just has a "longer wire" going to the block storage. iSCSI, for example, will let you put your block storage anywhere, even in orbit. The filesystem, however, still resides on the local computer. >-Original Message- >From: sqlite-users On >Behalf Of Gary R. Schmidt >Sent: Wednesday, 25 September, 2019 23:13 >To: sqlite-users@mailinglists.sqlite.org >Subject: Re: [sqlite] Safe to use SQLite over a sketchy network? > >On 26/09/2019 15:00, Jens Alfke wrote: >> >>> On Sep 24, 2019, at 3:48 PM, Keith Medcalf >wrote: >>> >>> There are not, to my knowledge, any client/server database systems >that will work properly if the database resides on a network filesystem >(meaning remote multi-access). The "client" is remote from the "server" >because the "client" and "server" use some sort of IPC mechanism (of >which a network is an example) so that the "client" can send commands to >and receive responses from the "server". >> >> Well, obviously. “Client/server” means databases like MySQL or Oracle. >No one would run those with the server using a networked file system. >> >I might have dreamt it, but NetAPP had an add-on for Oracle, quite >probably still do, that enhanced performance and behaviour when used for >storage. > >Not sure if it was applied to the server or the NAS, possibly both, but >it was an Oracle-recommended solution for large storage requirements. > > Cheers, > GaryB-) >___ >sqlite-users mailing list >sqlite-users@mailinglists.sqlite.org >http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Safe to use SQLite over a sketchy network?
On 26/09/2019 15:00, Jens Alfke wrote: On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote: There are not, to my knowledge, any client/server database systems that will work properly if the database resides on a network filesystem (meaning remote multi-access). The "client" is remote from the "server" because the "client" and "server" use some sort of IPC mechanism (of which a network is an example) so that the "client" can send commands to and receive responses from the "server". Well, obviously. “Client/server” means databases like MySQL or Oracle. No one would run those with the server using a networked file system. I might have dreamt it, but NetAPP had an add-on for Oracle, quite probably still do, that enhanced performance and behaviour when used for storage. Not sure if it was applied to the server or the NAS, possibly both, but it was an Oracle-recommended solution for large storage requirements. Cheers, GaryB-) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Safe to use SQLite over a sketchy network?
> On Sep 24, 2019, at 3:48 PM, Keith Medcalf wrote: > > There are not, to my knowledge, any client/server database systems that will > work properly if the database resides on a network filesystem (meaning remote > multi-access). The "client" is remote from the "server" because the "client" > and "server" use some sort of IPC mechanism (of which a network is an > example) so that the "client" can send commands to and receive responses from > the "server". Well, obviously. “Client/server” means databases like MySQL or Oracle. No one would run those with the server using a networked file system. —Jens ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] SSL: cannot connect to host www3.sqlite.org:443 (Connection refused)
Hello Richard ! It's the second day that this is happening ! Cheers ! ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] Safe to use SQLite over a sketchy network?
On 25/09/2019 15:36, Rowan Worth wrote: On Wed, 25 Sep 2019 at 12:58, Simon Slavin wrote: When I first learned the SQLite had problems with Network File Systems I read a ton of stuff to learn why there doesn't seem to be a Network File Systems that implements locking properly. Still, I wonder why someone working on a Linux network file system, or APFS, or ZFS, hasn't done it. I'm not sure what your definition of "locking properly" is or when your research was done, but POSIX advisory locks¹ work just fine on linux over nfs (since at least v3) and lustre. ¹ That's the F_SETLK/F_GETLK/F_SETLKW commands via the fcntl() syscall, which is also sqlite's default locking mechanism under UNIX. I don't see it as that much of a problem, I've been locking database-type files over NFS/RFS/DECNET since the 1980s, and SMB since the 1990s. Now, there have been a *lot* of crappy implementations of NFS out there, probably the crappiest currently in use is the Linux version, but it is better than it used to be (I wonder if sharing a file system still causes the entire NFS server to re-start), and let's not mention the reasoning behind, "Why should we drop back to NFSv3 if the NFSv4 initiation fails?" Although I have had to convince a few people of the right /way/ to take out a lock... Cheers, GaryB-) ___ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users