I use SQLite over GPFS , but in DELETE (which I think is the default) mode. Not WAL mode. No issues with locking, except performance when accessing concurrently from multiple nodes. As others pointed out, this has to do with the overhead due to lock requests. GPFS must coordinate with many nodes. My observation is that when concurrent access is from a few nodes, the performance is OK even though number of nodes is always the same. Thus, GPFS coordinates in some smart way only between nodes actively involved.
One reason I do not use mySQL with its more efficient network access is that sys admin must set it up. With SQLite, I am independent. In addition, in my SQL there are authentication issues to be dealt with. I rely on GPFS file access permissions (access control list, ACL) to regulate access to database. I heard about BeadrockDB, which internally uses SQLite and provides network access with replication. I have not tried it and do not know what is involved. Roman ________________________________ From: sqlite-users <sqlite-users-boun...@mailinglists.sqlite.org> on behalf of Richard Hipp <d...@sqlite.org> Sent: Saturday, January 11, 2020 8:59 PM To: SQLite mailing list <sqlite-users@mailinglists.sqlite.org> Subject: Re: [sqlite] Test failures on GPFS CAUTION: This email comes from an external source; the attachments and/or links may compromise our secure environment. Do not open or click on suspicious emails. Please click on the “Phish Alert” button on the top right of the Outlook dashboard to report any suspicious emails. On 1/11/20, J. King <jk...@jkingweb.ca> wrote: > > WAL mode does not work over the network, so the test failures are presumably > to be expected. > WAL mode should work on a network filesystem, as long as all of the clients are on the same host computer, and as long as mmap()-ing the *-shm file gives all the clients shared memory. Dunno if GPFS does that or not, though. Maybe not. Or, maybe not reliably. -- D. Richard Hipp d...@sqlite.org _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org https://nam04.safelinks.protection.outlook.com/?url=http%3A%2F%2Fmailinglists.sqlite.org%2Fcgi-bin%2Fmailman%2Flistinfo%2Fsqlite-users&data=02%7C01%7Croman.fleysher%40einsteinmed.org%7Cba1544a0f3584e8a077008d7970309d8%7C9c01f0fd65e040c089a82dfd51e62025%7C0%7C1%7C637143911624961155&sdata=udLAzknx7zL4yHzQk8ZPQI8mAWltFusqvcb%2FW31XuaY%3D&reserved=0 _______________________________________________ sqlite-users mailing list sqlite-users@mailinglists.sqlite.org http://mailinglists.sqlite.org/cgi-bin/mailman/listinfo/sqlite-users
