Couchbase

[davidkhala]

Partner

Enablement

• https://www.couchbase.com/academy/

Distributor

• https://sva.com.hk/

[davidkhala]

• how to migrate from MongoDB
  • With CLI and IDE Plugins - Link
  • MongoDB Device Sync (Realm) to Capella App Services - Link
  • Using MOLO17 Gluesync - Link
• Trigger

[davidkhala]

Edge Server install

• https://docs.couchbase.com/couchbase-edge-server/current/get-started/install.html

[davidkhala]

Capella

• Terraform module
• API

[davidkhala]

Indexing Options

• Simple
• Composite
• Array
• Functional
• Memory-Only or On-Disk
• top-level or sub-document
• Replica index

[davidkhala]

Eventing / Trigger

• Triggered on document updates and deletes
• Available in REST API (Admin API) port 8096
• 不能npm install 外部包

[davidkhala]

Analytic

• Shadow-copy of data to offload query workload
• Integrate by ODBC/JDBC

[davidkhala]

在node准备加入cluster的时候，我们需要给node指定其中将要提供的一个到多个服务(Data|Query|Index|...)

因此Capella虽然是托管数据库，但是也是严重需要DBA的

[davidkhala]

Within each Bucket are 1024 vBuckets

• 写死的Sharding，2 node cluster就分割成各自512 vBuckets
• 按Document key的hash排序切割
• 自动：不需要DBA了解参与，也不能控制

[davidkhala]

Poor Quality Training

• cluster.bucket 不需要await
• 来自Section 5.3. Using SQL++/N1QL With Code and Scope Object

[davidkhala]

• 是否可以不设index的情况下直接join
  • 不可以，除非是join documents via document keys

[davidkhala]

Why

[davidkhala]

Document attributes to be included in the index are chosen by the Architect

[davidkhala]

https://docs.couchbase.com/cloud/search/run-searches.html#advanced-search-settings

[davidkhala]

[davidkhala]

• Compete with SQL MI / postgreSQL / Azure Cosmos