Ops Jumpstart: Admin 101

Achille Brighton

2

0 – 100 in 45 mins

1) What is MongoDB?

2) What's so specialabout administering it?

What is MongoDB?

4

db-engines.com/ranking

5

{ "name" : "James Bond", "age" : 42, "address" : [ { "city" : "London", "country": "UK" }, { "city" : "Nassau/Bahamas", "country" : "US" } ] }

Storing Documents: JSON

6

db.persons.find ({ "name" : "James Bond" })

db.persons.find ({ "age" : { "$gt" : 40 } })

db.persons.update ({ "name" : "James Bond" }, { "$inc" : "age" })

Expressive Query Language

7

Replication

PRIMARY

SECONDARY SECONDARY

DRIVER

APPLICATION

8

Sharding

SHARD0

SHARD1

SHARD2

SHARD3

ROUTERmongos DRIVER

APPLICATION

C

C C

9

Sharding & Replication

ROUTERmongos DRIVER

APPLICATION

C

C C

P

S S

P

S S

P

S S

P

S S

10

MongoDB in a Nutshell

• A document store: more complex data than relational• Query language is just about as expressive as SQL• Much greater focus on scalability

– replication (high availability)– sharding (volume and throughput)

What's so specialabout administering it?

12

DBA Tasks for MongoDB

• There are no schemas• Indexes are more important than in relational DBs• Responsibility for security • Likely dealing with a lot of servers

– monitoring– backup– deployment

13

14

MongoDB Cloud Manager

• Comprehensive, web-based management solution– modules for monitoring, backup, automation

• Cloud Manager– we run it for you– enhances interaction with MongoDB tech support

• OpsManager (on prem)– you run it yourself– all under your control, nothing leaves your network

15

Monitoring

16

Backup

• Registers itself as a hidden replica,works cluster-wide

• Snapshot every six hours,plus oplog, thuspoint-in-time restore

• Requires 3-4x original storage for typical retention policy

• Can do 100s of GB/day over the net

• On-prem version available for enterprise customers

17

Automation

• Deploy, configure and controlMongoDB on your own hardware

• Create complex configurationswith dozens, hundreds of serversin seconds

• Orchestrate complex tasks such as version upgrades, change of storage engine

• Each server runs an autonomous automation agent

18

Summary

• Paradigm shift in databases is happening

• MongoDB is extremely attractive to modern application development: complex data structures, huge volume

• For DBAs, some things are different, some things stay the same: no schemas, but many servers

• Know as much as you can!

Thank you.

Questions?