You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@james.apache.org by rc...@apache.org on 2020/10/26 02:55:11 UTC

[james-project] 08/11: JAMES-3430 Document migration for MessageV3 table

This is an automated email from the ASF dual-hosted git repository.

rcordier pushed a commit to branch master
in repository https://gitbox.apache.org/repos/asf/james-project.git

commit 3aa16fd9a0f3b08935036d5d78af0bfc97a22cbb
Author: Benoit Tellier <bt...@linagora.com>
AuthorDate: Tue Oct 20 17:04:24 2020 +0700

    JAMES-3430 Document migration for MessageV3 table
---
 CHANGELOG.md                                       |  1 +
 .../distributed/operate/cassandra-migration.adoc   |  2 ++
 src/site/xdoc/server/config-cassandra.xml          | 12 ++++++++++
 upgrade-instructions.md                            | 26 ++++++++++++++++++++++
 4 files changed, 41 insertions(+)

diff --git a/CHANGELOG.md b/CHANGELOG.md
index 790db3d..596bcc0 100644
--- a/CHANGELOG.md
+++ b/CHANGELOG.md
@@ -27,6 +27,7 @@ The format is based on [Keep a Changelog](http://keepachangelog.com/en/1.0.0/)
 - JAMES-3263 Optimize RecipientRewriteTable::getMappingsForType
 - JAMES-3176 Rewritte MDN parsing with Parboiled scala (avoid asm library dependency clash within the Distributed Server)
 - JAMES-3194 Rely on DTOConverter in TaskRoute
+- JAMES-3430 Restructure message properties storage within Cassandra Mailbox. See upgrade instructions.
 
 ### Deprecated
 - HybridBlobStore. This will be removed after 3.6.0 release. Introduced to fasten small blob access, its usage could be
diff --git a/docs/modules/servers/pages/distributed/operate/cassandra-migration.adoc b/docs/modules/servers/pages/distributed/operate/cassandra-migration.adoc
index 617ddc4..357553e 100644
--- a/docs/modules/servers/pages/distributed/operate/cassandra-migration.adoc
+++ b/docs/modules/servers/pages/distributed/operate/cassandra-migration.adoc
@@ -23,5 +23,7 @@ to mailboxPathV2 table relying on a composite primary key.
 handy for things like mail aliases (I want to list aliases rewritting things to bob). Without this projection table being available,
 (ie we rely on schema version 6 or less) such information is obtained through a full table scan, unoptimized. From schema version 7,
 the optimized projection can safely be used.
+* *From V7 to V8* : Add UID_VALIDITY to mailboxPath table in order not to mandate mailbox table reads.
+* *From V8 to V9* : Adopt a more compact representation for message properties.
 
 The xref:distributed/operate/guide.adoc#_updating_cassandra_schema_version[Operator guide] further details the migration process.
\ No newline at end of file
diff --git a/src/site/xdoc/server/config-cassandra.xml b/src/site/xdoc/server/config-cassandra.xml
index a8e2470..d779602 100644
--- a/src/site/xdoc/server/config-cassandra.xml
+++ b/src/site/xdoc/server/config-cassandra.xml
@@ -257,6 +257,18 @@
 
     </subsection>
 
+    <subsection name="From V7 to V8">
+
+      <p>Add UID_VALIDITY to mailboxPath table in order not to mandate mailbox table reads.</p>
+
+    </subsection>
+
+    <subsection name="From V8 to V9">
+
+      <p>Adopt a more compact representation for message properties.</p>
+
+    </subsection>
+
   </section>
 
 </body>
diff --git a/upgrade-instructions.md b/upgrade-instructions.md
index a040c31..3ba7aef 100644
--- a/upgrade-instructions.md
+++ b/upgrade-instructions.md
@@ -20,6 +20,32 @@ Change list:
  - [mailqueue.size.metricsEnabled now defaults to false](#mailqueuesizemetricsenabled-now-defaults-to-false)
  - [LDAP users repository connection pool now defaults to false](#ldap-users-repository-connection-pool-now-defaults-to-false)
  - [Swift support has been dropped](#swift-support-has-been-dropped)
+ - [Cassandra Schema update to V8](#cassandra-schema-update-to-v8)
+ - [Cassandra Schema update to V9](#cassandra-schema-update-to-v9)
+
+### Cassandra Schema update to V9
+
+Date 20/10/2020
+
+JIRA: https://issues.apache.org/jira/browse/JAMES-3430
+
+Concerned product: Distributed James
+
+Adopt a more compact representation for message properties. This improves performance of the Cassandra mailbox.
+
+In order to benefit from this work, you need to [upgrade to the latest schema version](https://github.com/apache/james-project/blob/master/src/site/markdown/server/manage-webadmin.md#upgrading-to-the-latest-version).
+
+### Cassandra Schema update to V8
+
+Date 13/10/2020
+
+JIRA: https://issues.apache.org/jira/browse/JAMES-3409
+
+Concerned product: Distributed James
+
+Add UID_VALIDITY to mailboxPath table in order not to mandate mailbox table reads. This improves performance of the Cassandra mailbox.
+
+In order to benefit from this work, you need to [upgrade to the latest schema version](https://github.com/apache/james-project/blob/master/src/site/markdown/server/manage-webadmin.md#upgrading-to-the-latest-version).
 
 ### Swift support has been dropped
 


---------------------------------------------------------------------
To unsubscribe, e-mail: notifications-unsubscribe@james.apache.org
For additional commands, e-mail: notifications-help@james.apache.org