mongodb-dba-workshop

Exercise in Advanced Topics for Database Administrator

0 Preparation

  1. สมัครและสร้าง Cluster บน Mongo Atlas

1. Improving Performance

  1. Single Field Indexes
  2. Sub-document Indexes
  3. Multi-keys Indexes
  4. Compound Indexes
  5. Compound Indexes with Sort
  6. Compound Indexes with ESR
  7. Wildcard Indexes
  8. Partial Indexes
  9. Sparse Indexes

2. Advanced Log Monitoring

  1. Access log on self-managed MongoDB
  2. Monitoring slow queries
  3. Verbosity level
  4. Log rotation

3. MongoDB Database Tools

  1. mongodump
  2. mongorestore
  3. mongostat
  4. mongotop
  5. bsondump
  6. GridFS

5. Selt-Managed Security MongoDB

  1. Network Security
  2. Authentication
  3. Authorization
  4. Auditing