You are viewing a plain text version of this content. The canonical link for it is here.
Posted to derby-dev@db.apache.org by "Jørgen Løland (JIRA)" <ji...@apache.org> on 2007/11/01 09:23:50 UTC
[jira] Created: (DERBY-3169) Add documentation for replication
Add documentation for replication
---------------------------------
Key: DERBY-3169
URL: https://issues.apache.org/jira/browse/DERBY-3169
Project: Derby
Issue Type: Improvement
Components: Documentation
Affects Versions: 10.4.0.0
Reporter: Jørgen Løland
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12566743#action_12566743 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Thanks, Myrna -- sorry, I should have done that myself.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "V.Narayanan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12584642#action_12584642 ]
V.Narayanan commented on DERBY-3169:
------------------------------------
In mentioning "Unlogged operations" we have nothing wrong considering that
we have kept with similar usage in the documentation for online backup here
http://db.apache.org/derby/docs/10.2/adminguide/cadminhubbkup01.html
But, I tried to search for whether unlogged operations were documented somewhere is Derby, but
failed to find a place where the list of unlogged operations were documented.
When a user looks at our documentation he might think what an unlogged operation is
We have two options
1) Create a place in the derby documentation where we mention what an unlogged operation is
(not sure if it is there already) and link it to this page.
2) Maybe we could mention the list of unlogged operations in this documentation
I personally prefer 1) because I feel it will act as a common reference point for the people who search for
this keyword in both online backup and replication. If this is already there we might want to re-direct the
user to that link.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12581401#action_12581401 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
The latest doc patch looks very good. It makes perfect sense to commit it as it is and make incremental updates later. +1 to commit.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Derby Info: [Patch Available]
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Assigned: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reassigned DERBY-3169:
--------------------------------
Assignee: Kim Haase
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12580265#action_12580265 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
>I've seen some JIRA comments on other issues that propose additional things that may need to be documented -- like a SYSCS_UTIL.SYSCS_PREPARE_REPLICATION procedure, for example. Please let me know when/if further changes are necessary.
Of course (and I'm amazed that that discussion didn't go below your radar :) ) The appropriate action for DERBY-3533 has not been decided upon yet, but if the current suggestion is used, the doc-changes will be minimal.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Attachment: rrefattribstartmaster.html
DERBY-3169-6.diff
Attaching DERBY-3169-6.diff to fix the problem that breaks the docs build. My apologies!
The svn stat command produces this output:
M src/ref/rrefattribstartmaster.dita
Also attaching the HTML output file. rrefattribstartmaster.html, which in this case is not very helpful.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
Re: [jira] Updated: (DERBY-3169) Add documentation for replication
Posted by Dyre Tjeldvoll <Dy...@Sun.COM>.
Kim Haase wrote:
> Thanks for the info, Dan -- I will study it. Rick Hillegas had asked me
> for some information so he could set up an apache.org account for me (I
> guess this would be separate from my JIRA login), so I've been waiting
> to hear back on that before I went any further.
Yes, you do need an Apache account, (and it is different form your Jira
account), before you can commit fixes. I would suggest taking some time
to familiarize yourself with your Apache account, creating and uploading
keys, and so on. At least I had to that... :)
Dyre
Re: [jira] Updated: (DERBY-3169) Add documentation for replication
Posted by Kim Haase <Ca...@Sun.COM>.
Thanks for the info, Dan -- I will study it. Rick Hillegas had asked me
for some information so he could set up an apache.org account for me (I
guess this would be separate from my JIRA login), so I've been waiting
to hear back on that before I went any further.
Kim
Daniel John Debrunner wrote:
> Kim Haase (JIRA) wrote:
>
>> I haven't yet learned how to commit, so someone else would need to do
>> this.
>
> Seems like a good time to learn then!
>
> http://wiki.apache.org/db-derby/DerbyCommitHowTo
>
> Dan.
Re: [jira] Updated: (DERBY-3169) Add documentation for replication
Posted by Daniel John Debrunner <dj...@apache.org>.
Kim Haase (JIRA) wrote:
> I haven't yet learned how to commit, so someone else would need to do this.
Seems like a good time to learn then!
http://wiki.apache.org/db-derby/DerbyCommitHowTo
Dan.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Attachment: DERBY-3169-5.zip
DERBY-3169-5.diff
Thanks, Jørgen, for the comment. Here are new diff and zip files with the one-word change (DERBY-3169-5.diff and DERBY-3169-5.zip). I wonder if it would make sense to commit these now, without resolving the issue, just so any subsequent changes could be incremental? (I haven't yet learned how to commit, so someone else would need to do this.)
I can see that implementing the SYSCS_UTIL.SYSCS_PREPARE_REPLICATION procedure would require only a new file in the Reference Manual and some changes to the "Starting and running replication" topic of the Admin Guide.
There was also something in the comments to DERBY-3552 about a possible need for documentation concerning jar files, but I don't quite understand this issue yet so I'm not sure what would be involved.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12578902#action_12578902 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Thanks very much for the comments from 2/25 and 3/10, Jørgen -- they are very clear and helpful. I've been incorporating them, except for the information on the new configurable properties. I have some questions about these:
1) Are they in the functional spec, or will they be? I can't find them in v 10 but I may not be looking in the right place.
2) Is it correct to assume these belong among the Derby properties listed in the Tuning Guide? In that case, I will add some topics to that book for them and will create cross-references where appropriate, to and from the other books.
3) You don't mention any defaults for minLogShippingInterval and maxLogShippingInterval -- are there any?
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Attachment: DERBY-3169-3.stat
DERBY-3169-4.zip
DERBY-3169-4.diff
Here's another version of the docs that includes the new properties for the Tuning Guide in addition to the Reference Manual attributes and the Admin Guide documentation. Everything is as up to date as I can make it.
The stat file looks like this:
A src/adminguide/cadminreplicstop.dita
A src/adminguide/cadminreplicstartrun.dita
M src/adminguide/derbyadmin.ditamap
A src/adminguide/cadminreplicsecurity.dita
A src/adminguide/cadminreplicfailover.dita
A src/adminguide/cadminreplicfailures.dita
A src/adminguide/cadminreplication.dita
A src/ref/rrefattribstopslave.dita
A src/ref/rrefattribstartmaster.dita
A src/ref/rrefattribstartslave.dita
A src/ref/rrefattribstopmaster.dita
A src/ref/rrefattribslaveport.dita
M src/ref/refderby.ditamap
A src/ref/rrefattribfailover.dita
A src/ref/rrefattribslavehost.dita
A src/tuning/rtunproperlogbuffersize.dita
M src/tuning/ctunproper22250.dita
M src/tuning/tuningderby.ditamap
A src/tuning/rtunproperminlogshippinginterval.dita
A src/tuning/rtunpropermaxlogshippinginterval.dita
A src/tuning/rtunproperverbose.dita
I should mention that in the "Derby properties" topic with the table of all the properties (ctunproper22250.html) I have taken the liberty of fixing some table entries so that empty cells don't show up with an apostrophe in the PDF and HTML book files. (I inserted a non-breaking space, " ", into empty entries.)
I've seen some JIRA comments on other issues that propose additional things that may need to be documented -- like a SYSCS_UTIL.SYSCS_PREPARE_REPLICATION procedure, for example. Please let me know when/if further changes are necessary.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12576944#action_12576944 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Hi Kim,
A few more comments now that the 10.4 branch has been cut:
* The system privileges did not make it into 10.4 (see funcspec v 10)
* The funcspec v10 contains a new failure handling scenario: 'slave crashes'.
* We have decided to use slaveHost and slavePort attribute names (were: slavehost and slaveport) for uniformity.
* The default replication port has been changed from 8001 to 4851 - this port number was given to us by IANA.
* There are now four configurable properties for replication:
- derby.replication.verbose -> true/false - whether or not replication messages are written to log (default: true)
- derby.replication.logBufferSize -> the size of the replication log buffers in bytes. These buffers store the log on the master side while waiting to be shipped to the slave. There are a total of 10 such buffers. Large buffers increase the memory usage but reduces the chance that the buffer gets full (in turn increasing response time for transactions on master, as described in funcspec "Handling failure scenarios - The master Derby instance is not able to send log to the slave at the same pace as log is generated..."). Default: 32768 (32KB). Minimum value: 8192 (8 KB), maximum value: 1048576 (1 MB)
- derby.replication.minLogShippingInterval -> the shortest interval between two consecutive log shipments
- derby.replication.maxLogShippingInterval -> the longest interval between two consecutive log shipments (a "soft" guarantee that the slave will not deviate more than this amount of millis from the master)
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12570663#action_12570663 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
I did some experiments with replication on a Derby server with the security manager enabled. The security policy file has to be modified to allow the master-slave network connection. I think this needs to be documented as well:
Permission needed in the master policy file (for derby.jar):
permission java.net.SocketPermission "<slaveHost>:<slavePort>", "connect,resolve";
Permission needed in the slave policy file (for derby.jar):
permission java.net.SocketPermission "<slaveHost>", "accept,resolve";
(replace slaveHost and slavePort with what is specified in the slaveHost and slavePort options.)
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12580295#action_12580295 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Patch 4 looks very good. I have only one minor comment:
adminguide/cadminreplicfailover.html
Change "slave" to "master" on this line: You perform failover from the master system. To do so, you connect to the database on the slave system using the failover=true connection URL attribute.
Thank you very much for all the great work, Kim!
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "V.Narayanan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12580430#action_12580430 ]
V.Narayanan commented on DERBY-3169:
------------------------------------
Thank you for the excellent work you have been doing for replication
documentation Kim.
>I can see that implementing the SYSCS_UTIL.SYSCS_PREPARE_REPLICATION procedure would
>require only a new file in the Reference Manual and some changes to the "Starting and
>running replication" topic of the Admin Guide.
You are correct in your estimation of the work required to document this stored procedure.
This procedure would be involved only during replication startup and its presence in the
Reference manual in the stored procedures section, and, the Admin guide section for starting
and running replication should suffice
>There was also something in the comments to DERBY-3552 about a possible need for
>documentation concerning jar files, but I don't quite understand this issue yet so I'm not
>sure what would be involved.
There are two possibilities
1) Write documentation saying that, if jars need to be installed when replication is running for
the database the user will have to manually copy the jar files to the slave.
2) Disable jar file operations during replication, in which case we will have to document saying that
users cannot perform jar operations when replication is running.
I am inclined towards 1) because it gives more flexibility to the user, but I was hoping to get some more
inputs from the community in the coming days on this, which is why I have left it open.
-----------------------------------------------------------------------------------------------------------------
An example for installing a jar file would be like this
ij> CALL SQLJ.install_jar
('myStuff.jar', 'APP.MyStuffJar', 0);
ij> CALL SYSCS_UTIL.SYSCS_SET_DATABASE_PROPERTY
('derby.database.classpath', 'APP.MyStuffJar');
I found this example here http://wiki.apache.org/db-derby/DerbySQLroutines
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12579366#action_12579366 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
You are right - I forgot to put the configurable properties into the funcspec. I'll update the funcspec in a day or two. In the mean time:
2: Yes, I would say so. Good suggestion
3: defaults - minLogShippingInterval: 100 milliseconds, maxLogShippingInterval: 5000 millis (i.e. 5 seconds)
Note however that min <= (max/10) since a higher min value would ruin the soft guarantee for maximum slave deviation. The reason is that there are 10 replication log buffers.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12572086#action_12572086 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Hi Kim,
The documentation looks really great! A few minor comments/suggestions:
Admin guide:
------------
* Replicating databases
- Suggestion: "In Derby, you *start* replicating databases by..."
- No sharing -> Shared Nothing. The proposed text looks better,
but "Shared Nothing" is a well-known term in distributed
computing.
* Stopping replication
- this page does not mention the stopSlave command, which can
be used to shutdown the slave database after the connection
with the master has been lost. Is this intentional? I don't
see stopSlave any other place in the admin guide.
* Forcing a failover:
- Mention that failover must be performed on the master Derby
instance if the replication network connection is up? The
slave will only accept this command after loosing the
connection with the master. I see that this is specified in
the reference manual, so I'm not sure if it belongs here.
Reference guide:
----------------
* startSlave, end of first paragraph: Missing sentence following "See"
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12558750#action_12558750 ]
Kim Haase commented on DERBY-3169:
----------------------------------
You're right about the typo in the failover example -- can you tell I was cutting and pasting?
Thanks very much for the feedback. I'm happy to hold off on further work now that I know the basic structure is okay. I see that things are changing still and will keep an eye out for more spec updates.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12571177#action_12571177 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Sorry, I just realized that the revised diff and zip files don't incorporate the policy file information you described yesterday, since it isn't in the functional spec and that's what I was working from. I'll need to add it to the cadminreplicsecurity.html topic. You could start reviewing what I have so far, though, if you wish.
Also, I realized that the addition of some more exception codes that indicate success but don't return a connection means that a statement in the Getting Started guide is now incorrect. I may as well fix that as part of this bug rather than hang yet another issue off this one.
Another patch will follow.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12555613#action_12555613 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Thanks a lot for the functional spec, Jorgen. It is so well written and organized that it will be fairly easy to adapt for the documentation. As suggested in the spec, the documentation will be in two different manuals:
Admin Guide: Conceptual overview and descriptions of tasks (in Part Two, Derby Administration Guide, after "Backing up and restoring databases"
Reference Manual: Writeups on connection URL attributes used as replication commands:
startMaster
stopMaster
startSlave
stopSlave
failover
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12569864#action_12569864 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Hi Kim,
I think the new funcspec (v9) on DERBY-2872 contains all the functionality that will be included in the 10.4 version of replication. One minor detail: I'm still not sure if the system privilege for replication will make it.
Please let me know if anything is unclear in the new funcspec.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12558621#action_12558621 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Hi Kim,
The documentation is clear and well written, and I think you are on the right track. I wonder if the second example in Reference manual - failover should say "failover" instead of "stop slave" though...
I think it would be good to wait a little bit before writing more because the functionality still changes. For instance, the Reference manual on startSlave says that a connection is not returned to the caller. This is no longer true (I know - it says so in the func spec), and I expect more details like this to emerge.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Attachment: DERBY-3169-2.stat
DERBY-3169-3.zip
DERBY-3169-3.diff
Attaching DERBY-3169-3.diff, DERBY-3169-3.zip, and DERBY-3169-2.stat, which differ from the previous versions only by including changes to the Admin Guide topic on replication and security, and on adding changes to a Getting Started guide file that describes exceptions.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "V.Narayanan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12584993#action_12584993 ]
V.Narayanan commented on DERBY-3169:
------------------------------------
>I agree that something should probably be done about documenting unlogged operations.
>The current version of the backup file you mention,
>http://db.apache.org/derby/docs/dev/adminguide/cadminhubbkup01.html, describes two
>unlogged operations. How many more are there?
I know of three unlogged operations kim
1) Creation of indexes
http://db.apache.org/derby/docs/dev/ref/rrefsqlj20937.html
2) Bulk import operations
http://db.apache.org/derby/docs/dev/tools/ctoolsimport16245.html
3) Installation of Jars
http://db.apache.org/derby/docs/dev/devguide/cdevdeploy23812.html
>If these are the only ones, we could leave the documentation where it is and refer people to
>this topic.
I am OK with doing this.
If we create a separate documentation page for this, we could list all the operations there
and point them to the corresponding documentation link for each operation.
For example if we take import there are quite a few import procedures, we could probably
list them all and point them to the corresponding documentation links.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Attachment: rrefattribstartmaster.html
cadminreplicstartrun.html
DERBY-3169-7.diff
Attaching DERBY-3169-7.diff and the corresponding output files, rrefattribstartmaster.html and cadminreplicstartrun.html. This patch adds the information about unlogged operations described in DERBY-3551 and the information about installed jar files described in DERBY-3552.
Both modified topics include the information about unlogged operations; rrefattribstartmaster.html also adds a little more information to the introductory paragraph (similar to the introductory paragraph for the startSlave attribute -- see http://db.apache.org/derby/docs/dev/ref/rrefattribstartslave.html), which provides some context for the information.
The information about installed jar files is in cadminreplicstartrun.html.
Please let me know if any changes are needed.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12584268#action_12584268 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Committed DERBY-3169-6.diff to docs trunk at revision 643515.
Merged it to 10.4 docs branch and committed it at revision 643525.
This should fix the broken docs build, caused by incorrect capital letters in an xref element in src/ref/rrefattribstartmaster.dita.
Additional changes to content will follow that will need to be reviewed.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539385 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Thank you, Laura, for pointing out the need for this issue, and thank you, Jorgen, for filing it. I can take this one on, based on the principle that the docs are ordinarily produced by the same group that's doing the development. If you (or someone else!) would like to do it, though, feel free to reassign it.
I notice that the functional spec now says, "The NetworkServerControl commands will be added to the reference guide, and a replication chapter will be added to the administrator guide." I don't think the reference guide actually covers any of the NetworkServerControl commands -- they are entirely covered by the Admin Guide, as far as I can tell. Please let me know if I've missed something. But I think we can document this feature entirely in the Admin Guide.
The functional spec currently says, "The following commands will be supported, although the actual syntax may change." When the syntax is definite, Jorgen, could you please update the spec to indicate that?
Thanks very much.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12579588#action_12579588 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Thanks very much, Jørgen. I'm working on the new topics for the Tuning Guide, and I have a few more followup questions.
Which log are replication messages written to -- the derby.log file, or the transaction log file that gets shipped from the master to the slave? I'm guessing the derby.log file.
Also, just to clarify -- when you say "min <= (max/10)" does that mean that it is the responsibility of the user to make sure that the min value is less than or equal to a tenth of the max value? What would happen if the user set the minLogShippingInterval to 2500 without also changing the maxLogShippingInterval? I am guessing that this would be allowed but would result in bad performance -- is that right?
Are these properties system-wide or database-wide, or can they be either? See http://db.apache.org/derby/docs/dev/tuning/ctunproper51399.html for definitions of these terms.
Are these properties dynamic or static? See http://db.apache.org/derby/docs/dev/tuning/ctunsetprop824615.html for definitions of these terms.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-3169.
------------------------------
Resolution: Fixed
Derby Info: (was: [Patch Available])
Committed DERBY-3169-7.diff to docs trunk at revision 644015.
Merged to 10.4 to docs branch at revision 644029.
I think this should be all the doc changes for this issue, so I'm resolving it. For any further changes we can file another issue. Thanks to all of you for the great spec and the helpful explanations.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12539538 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Thank you very much for assigning to this issue, Kim!
I guess you are right that we only need to document replication in the Admin Guide. I'll make sure the func spec is updated with definite command syntax as soon as possible.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12580468#action_12580468 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Thanks very much, Narayanan -- that should give me enough to work with when the decision is made. I'll stay tuned.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12579758#action_12579758 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Sorry for the ambiguity in the property description. Replication messages are written to derby.log. If min > (max/10), derby will set min = max/10. In your example, min would be set to 500 since the default of max is 5000.
The properties are currently system-wide and static - this will hopefully change in the next Derby release.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Derby Info: [Patch Available]
Marking Patch Available again to flag the latest changes.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Myrna van Lunteren (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Myrna van Lunteren updated DERBY-3169:
--------------------------------------
Derby Info: (was: [Patch Available])
I understand from the comments that this patch is not ready for commit because the functionality is still changing; so I'm switching off patch available.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Attachment: DERBY-3169-2.zip
DERBY-3169-2.diff
Attaching DERBY-3169-2.diff and DERBY-3169-2.zip, which I think incorporate all the updates to the functional spec between version 8 and version 9.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Closed: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase closed DERBY-3169.
----------------------------
Closing issue that was resolved several months ago.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.1.3
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.1.3
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Reopened: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase reopened DERBY-3169:
------------------------------
Actually, I meant to keep this issue open rather than resolving it -- there are a couple more minor changes left to make. Sorry for the noise.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel#action_12553942 ]
Jørgen Løland commented on DERBY-3169:
--------------------------------------
Sorry about the long delay on this issue, Kim.
I just attached v8 of the funcspec on DERBY-2872, and the syntax of the commands should now be final. Note that all commands are now issued through connection url attributes, not as CLI to NetworkServerControl.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Attachment: DERBY-3169.stat
DERBY-3169.zip
DERBY-3169.diff
Attaching DERBY-3169.diff, DERBY-3169.zip, and DERBY-3169.stat, with new topics documenting the replication features described in DERBY-2872. The new Admin Guide topics are as follows, in their TOC order:
A src/adminguide/cadminreplication.dita
A src/adminguide/cadminreplicstartrun.dita
A src/adminguide/cadminreplicstop.dita
A src/adminguide/cadminreplicfailover.dita
A src/adminguide/cadminreplicsecurity.dita
A src/adminguide/cadminreplicfailures.dita
I made the Admin Guide topics all concept topics because the material is really conceptual rather than step-by-step task information.
The new Reference Manual topics are as follows (in TOC/alphabetical order):
A src/ref/rrefattribfailover.dita
A src/ref/rrefattribslavehost.dita
A src/ref/rrefattribslaveport.dita
A src/ref/rrefattribstartmaster.dita
A src/ref/rrefattribstartslave.dita
A src/ref/rrefattribstopmaster.dita
A src/ref/rrefattribstopslave.dita
In my previous list I'd forgotten about slaveHost and slavePort.
There is no hurry to review and commit these, since I believe the functionality is still being worked on. But it would be helpful to know if these are on the right track. There are probably many improvements that can be made as well as corrections.
Thanks again, Jørgen, for the excellent spec and helpful answers.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Updated: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase updated DERBY-3169:
-----------------------------
Derby Info: [Patch Available]
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12584672#action_12584672 ]
Kim Haase commented on DERBY-3169:
----------------------------------
Thanks for the okay on the changes, Narayanan.
I agree that something should probably be done about documenting unlogged operations. The current version of the backup file you mention, http://db.apache.org/derby/docs/dev/adminguide/cadminhubbkup01.html, describes two unlogged operations. How many more are there? If these are the only ones, we could leave the documentation where it is and refer people to this topic.
Ideally, though, we should have a separate topic for the list of unlogged operations, especially if there are more to describe -- if you could file a JIRA issue, that would be great. There are a few possible places to put it:
Under the topic http://db.apache.org/derby/docs/dev/adminguide/tadminlogfile.html in the Admin Guide. This is under "Derby Network Server advanced topics", though. The unlogged operations list would probably apply to both the embedded and Network Server modes.
Under the topic http://db.apache.org/derby/docs/dev/devguide/cdevdvlp25889.html in the Developer's Guide. This, however, is under "Derby embedded basics" -- so it has the same problem as the other topic.
I wouldn't put it under cadminhubbkup01.html, because that's nested about 5 deep already. And it's too advanced a topic for the Getting Started guide even if that guide had a topic about the log already (it doesn't).
So anything we did would probably involve a bit of rethinking and reorganizing somewhere.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Resolved: (DERBY-3169) Add documentation for replication
Posted by "Kim Haase (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:all-tabpanel ]
Kim Haase resolved DERBY-3169.
------------------------------
Resolution: Fixed
Fix Version/s: 10.4.0.0
Derby Info: (was: [Patch Available])
Committed revision 641923 to docs trunk.
Committed revision 641931 to 10.4 docs branch.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Commented: (DERBY-3169) Add documentation for replication
Posted by "V.Narayanan (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12584625#action_12584625 ]
V.Narayanan commented on DERBY-3169:
------------------------------------
Thank you for the follow-up on 3551 and 3552 Kim!
The changes in the patch DERBY-3169-7.diff and the corresponding output files look good.
+1 for a commit.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Fix For: 10.4.0.0
>
> Attachments: cadminreplicstartrun.html, DERBY-3169-2.diff, DERBY-3169-2.stat, DERBY-3169-2.zip, DERBY-3169-3.diff, DERBY-3169-3.stat, DERBY-3169-3.zip, DERBY-3169-4.diff, DERBY-3169-4.zip, DERBY-3169-5.diff, DERBY-3169-5.zip, DERBY-3169-6.diff, DERBY-3169-7.diff, DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip, rrefattribstartmaster.html, rrefattribstartmaster.html
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.
[jira] Issue Comment Edited: (DERBY-3169) Add documentation for
replication
Posted by "Jørgen Løland (JIRA)" <ji...@apache.org>.
[ https://issues.apache.org/jira/browse/DERBY-3169?page=com.atlassian.jira.plugin.system.issuetabpanels:comment-tabpanel&focusedCommentId=12558621#action_12558621 ]
jorgenlo edited comment on DERBY-3169 at 1/14/08 7:01 AM:
---------------------------------------------------------------
Hi Kim,
The documentation is clear and well written, and I think you are on the right track. I wonder if the second example in Reference manual - failover should say "failover" instead of "stop slave" though...
I think it would be good to wait a little bit before writing more because the functionality still changes.
was (Author: jorgenlo):
Hi Kim,
The documentation is clear and well written, and I think you are on the right track. I wonder if the second example in Reference manual - failover should say "failover" instead of "stop slave" though...
I think it would be good to wait a little bit before writing more because the functionality still changes. For instance, the Reference manual on startSlave says that a connection is not returned to the caller. This is no longer true (I know - it says so in the func spec), and I expect more details like this to emerge.
> Add documentation for replication
> ---------------------------------
>
> Key: DERBY-3169
> URL: https://issues.apache.org/jira/browse/DERBY-3169
> Project: Derby
> Issue Type: Improvement
> Components: Documentation
> Affects Versions: 10.4.0.0
> Reporter: Jørgen Løland
> Assignee: Kim Haase
> Attachments: DERBY-3169.diff, DERBY-3169.stat, DERBY-3169.zip
>
>
--
This message is automatically generated by JIRA.
-
You can reply to this email to add a comment to the issue online.