Re: [sqlite] 500 sqlites on one server machine?
Hello! В сообщении от Monday 08 September 2008 17:51:35 Daniel van Ham Colchete написал(а): > You might want to take a look at GlusterFS (www.glusterfs.org), it's a > clustered filesystem that works well with fcntl() (the locking system). > If you need a smaller latency, it will also work with infiniband. Do you know any similar FS from debian lenny packages? And do you think that GlusterFS is stable? Best regards, Alexey. ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] 500 sqlites on one server machine?
Hi, Daniel Colchete: Thank you very much, very useful information for me! regards ye On Mon, Sep 8, 2008 at 3:51 PM, Daniel van Ham Colchete <[EMAIL PROTECTED]>wrote: > ye, > > at the fifth question of the SQLite FAQ, at > http://www.sqlite.org/faq.html, it is explained why using a sqlite file > by multiple nodes over a network with a NFS filesystem is not a good > idea. I would avoid it although the FAQ does not say 'it does not work', > it only says 'it might not work'. > > You might want to take a look at GlusterFS (www.glusterfs.org), it's a > clustered filesystem that works well with fcntl() (the locking system). > If you need a smaller latency, it will also work with infiniband. > > Best regards, > Daniel Colchete > > ye wrote: > > Hi, Igor: > > Thanks for reply! > > Yes, I just noticed the sqlite data file is nothing but a empty file. > > Thanks! > > About the remote visit, if the sqlite data file is created on a NFS, will > > the remote visiting process be considered as a equal local process? > > > > regards > > ye > > > > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Ye Huang, Department of Informatics University of Fribourg / Pérolles 2 - Bld de Pérolles 90 1700 Fribourg, Switzerland e-mail: [EMAIL PROTECTED], [EMAIL PROTECTED] http://diuf.unifr.ch/people/huangy/ Office: +41 26 429 65 95 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] 500 sqlites on one server machine?
ye, at the fifth question of the SQLite FAQ, at http://www.sqlite.org/faq.html, it is explained why using a sqlite file by multiple nodes over a network with a NFS filesystem is not a good idea. I would avoid it although the FAQ does not say 'it does not work', it only says 'it might not work'. You might want to take a look at GlusterFS (www.glusterfs.org), it's a clustered filesystem that works well with fcntl() (the locking system). If you need a smaller latency, it will also work with infiniband. Best regards, Daniel Colchete ye wrote: > Hi, Igor: > Thanks for reply! > Yes, I just noticed the sqlite data file is nothing but a empty file. > Thanks! > About the remote visit, if the sqlite data file is created on a NFS, will > the remote visiting process be considered as a equal local process? > > regards > ye > > ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] 500 sqlites on one server machine?
Hi, Igor: Thanks for reply! Yes, I just noticed the sqlite data file is nothing but a empty file. Thanks! About the remote visit, if the sqlite data file is created on a NFS, will the remote visiting process be considered as a equal local process? regards ye On Mon, Sep 8, 2008 at 1:48 PM, Igor Tandetnik <[EMAIL PROTECTED]> wrote: > "ye" <[EMAIL PROTECTED]> wrote in > message > news:[EMAIL PROTECTED]<[EMAIL PROTECTED]> > > 1. Is it possible to create 500 sqlite databases on one server > > machine, on which the simulation is running. Each sqlite is supposed > > to be managed/used by one java thread. > > Yes. SQLite database is just a file. You can have as many of those files > as you want. > > > 2. Is it possible to make these 500 sqlites visible independent from > > network, with different ip/ports? Will these sqlites affect each > > other? > > SQLite has nothing to do with network. It's an embedded database. You > might be thinking of traditional client/server DBMS systems; SQLite is > not one. > > Igor Tandetnik > > > > ___ > sqlite-users mailing list > sqlite-users@sqlite.org > http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users > -- Ye Huang, Department of Informatics University of Fribourg / Pérolles 2 - Bld de Pérolles 90 1700 Fribourg, Switzerland e-mail: [EMAIL PROTECTED], [EMAIL PROTECTED] http://diuf.unifr.ch/people/huangy/ Office: +41 26 429 65 95 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
Re: [sqlite] 500 sqlites on one server machine?
"ye" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > 1. Is it possible to create 500 sqlite databases on one server > machine, on which the simulation is running. Each sqlite is supposed > to be managed/used by one java thread. Yes. SQLite database is just a file. You can have as many of those files as you want. > 2. Is it possible to make these 500 sqlites visible independent from > network, with different ip/ports? Will these sqlites affect each > other? SQLite has nothing to do with network. It's an embedded database. You might be thinking of traditional client/server DBMS systems; SQLite is not one. Igor Tandetnik ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
[sqlite] 500 sqlites on one server machine?
Hi, Dear all: I am working on creating a cluster simulation with 500 nodes. Each node is supposed to have its's own database. I am curiously about following questions: 1. Is it possible to create 500 sqlite databases on one server machine, on which the simulation is running. Each sqlite is supposed to be managed/used by one java thread. 2. Is it possible to make these 500 sqlites visible independent from network, with different ip/ports? Will these sqlites affect each other? 3. What's the total resource requirement for these 500 sqlites (memory, disk) ? 4. Is the aforementioned a good idea? If not, any alternative suggestions? Thanks a lot! Best Regards ye -- Ye Huang, Department of Informatics University of Fribourg / Pérolles 2 - Bld de Pérolles 90 1700 Fribourg, Switzerland e-mail: [EMAIL PROTECTED], [EMAIL PROTECTED] http://diuf.unifr.ch/people/huangy/ Office: +41 26 429 65 95 ___ sqlite-users mailing list sqlite-users@sqlite.org http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users