MongoDB Administration Checklist for MySQL DBAs

MongoDB Administration Checklist for MySQL DBAs

PREVIOUS POST
NEXT POST

In this blog, I discuss a MongoDB administration checklist designed to help MySQL DBAs.

If you are MySQL DBA, starting MongoDB administration is not always an easy transition. Although most of the concepts and even implementation are similar, the commands are different. The following table outlines the typical MySQL concepts and DBA tasks (on the left) to corresponding MongoDB ones (on the right). If you happen to be a MongoDB DBA and want to learn MySQL administration, you can use the same table looking from right to left.

I’ve also created a webinar, MongoDB administration for MySQL DBA, that explains the above concepts. You can download the slides to use as a reference.

Don’t forget about our upcoming event Community Open House for MongoDB in New York, June 30, 2016. There will be technical presentations and sessions from key members of the MongoDB open source community. This event is free of charge and open to all.

Architecture: Basic Concepts

Replication:

MySQL_MongoDB_replication

Sharding:

MySQL_MongoDB_sharding

 

Day-to-day operations

 

MySQL: SELECT

MongoDB: FIND

MySQL: Schema

MongoDB: Flexible Schema

MySQL: Config file

MongoDB:

MySQL: databases

MongoDB: Databases

MySQL: Storage Engines

MongoDB: Storage Engines

MySQL: Processlist

MongoDB: CurrentOp()

MySQL: Grants

MongoDB: createUser

MySQL: Index

MongoDB: Index

MySQL: Add Index

MongoDB: Create Index

MySQL: Explain

MongoDB: Explain

MySQL: Alter Table

MongoDB: Flexible schema

MySQL: Slow Query Log

MongoDB: Profiling

MySQL: Percona Toolkit

MongoDB: Mtools

mlogvis_example

MySQL 5.7: GIS

MongoDB 3.2: GIS

MySQL: Backup

  • Backup: mysqldump -A > dump.sql, restore: mysql < dump.sql
  • Stop replication slave, copy files
  • Percona XtraBackup

MongoDB: Backup

  • Backup: mongodump, restore mongorestore
  • Stop replica, copy files
  • Percona HotBackup for TokuMX only
PREVIOUS POST
NEXT POST

Share this post

Leave a Reply