db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From James A Craig/O/VCU <crai...@vcu.edu>
Subject Re: Distributed databases
Date Thu, 22 Sep 2005 14:55:44 GMT
<FONT face="Default Sans Serif,Verdana,Arial,Helvetica,sans-serif" size=2><DIV>Thank
you for the fast response. I was looking to set it up so that it was a single database with
table 1 on node 1, table 2 on node 2, etc. But if I'm reading what you said correctly, this
isn't possible. I was reading a book that dealt with doing this and I wanted to try it out
in practice (it didn't go into any details with actually doing it). However it sounds like
Derby will not let me do this. Is there a database system out there that will let me do this?</DIV><DIV>&nbsp;</DIV><DIV>However
I really like Derby thus far and John thank you for the article. Between it and using the
manual I've been able to get started.</DIV><DIV>&nbsp;</DIV><DIV>James<BR></DIV><FONT
color=#990099>-----Oystein.Grovlen@Sun.COM (Øystein Grøvlen) wrote: -----<BR><BR></FONT><blockquote
style="PADDING-RIGHT: 0px; PADDING-LEFT: 5px; MARGIN-LEFT: 5px; BORDER-LEFT: #000000 2px solid;
MARGIN-RIGHT: 0px">To: Derby Discussion &lt;derby-user@db.apache.org&gt;<BR>From:
Oystein.Grovlen@Sun.COM (Øystein Grøvlen)<BR>Date: 09/22/2005 05:07AM<BR>Subject:
Re: Distributed databases<BR><BR><FONT face="Default Monospace,Courier New,Courier,monospace"
size=2  >&gt;&gt;&gt;&gt;&gt; "JAC" == James A Craig/O/VCU &lt;craigja@vcu.edu&gt;
writes:<BR><BR>&nbsp; &nbsp;JAC&gt; Hi, I'm fairly new to Derby but
I was curious if its possible<BR>&nbsp; &nbsp;JAC&gt; to use it in a distributed
setup. I currently have a small<BR>&nbsp; &nbsp;JAC&gt; cluster and want
to set it up so that I have a distributed<BR>&nbsp; &nbsp;JAC&gt; database
on it using Derby. So my questions are:<BR><BR>&nbsp; &nbsp;JAC&gt;
&nbsp;<BR><BR>&nbsp; &nbsp;JAC&gt; 1) Is this possible?<BR><BR>It
is a bit unclear to me what you mean by using it in a distributed<BR>setup. &nbsp;Do
you just want to access the database from all nodes of the<BR>cluster, or do you actually
want for performance reasons a single<BR>distributed database which runs on all nodes.
&nbsp;The first part is<BR>possible and is called a network server, the latter is
not. &nbsp;The rest<BR>of my answers will assume that you want to be able to access
a<BR>single-node database server from other nodes.<BR><BR>&nbsp; &nbsp;JAC&gt;
2) Is there a resource that shows me how to do this? (the<BR>&nbsp; &nbsp;JAC&gt;
&nbsp; &nbsp;manuals don't seem to explain how to do this)<BR><BR>This
is explained in the Derby Server and Administration Guide.<BR><BR>&nbsp; &nbsp;JAC&gt;
3) From what I've read it seems like I need to use the DB2<BR>&nbsp; &nbsp;JAC&gt;
&nbsp; &nbsp;driver to do this<BR>&nbsp; &nbsp;JAC&gt; (like I've
said, I've found very little info on the subject<BR>&nbsp; &nbsp;JAC&gt;
of setting up a distributed database). Is this even remotely<BR>&nbsp; &nbsp;JAC&gt;
on base?<BR><BR>This was true for the first Derby release. &nbsp;The latest
release comes<BR>with an open-source JDBC driver.<BR><BR>&nbsp; &nbsp;JAC&gt;
4) Does anyone know of any decent tutorials when it comes to<BR>&nbsp; &nbsp;JAC&gt;
&nbsp; &nbsp;Derby? I haven't<BR>&nbsp; &nbsp;JAC&gt; found anything
that great thus far.<BR><BR>&nbsp; &nbsp;JAC&gt; 5) Can I use ij to
manipulate a distributed database? How do I do this?<BR><BR>Yes, ij can connect
to a network server if you specify an URL<BR>containing hostname and port number.<BR><BR>&nbsp;
&nbsp;JAC&gt; 6) Is there a way to setup one using ij?<BR><BR>There are
scripts that may be used to start a network server.<BR><BR>-- <BR>Øystein<BR><BR></FONT></blockquote><br></FONT>
View raw message