Buy Percona ServicesBuy Now!

MongoDB Administration Checklist for MySQL DBAs

 | June 1, 2016 |  Posted In: MongoDB, MySQL

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
Alexander Rubin

Alexander joined Percona in 2013. Alexander worked with MySQL since 2000 as DBA and Application Developer. Before joining Percona he was doing MySQL consulting as a principal consultant for over 7 years (started with MySQL AB in 2006, then Sun Microsystems and then Oracle). He helped many customers design large, scalable and highly available MySQL systems and optimize MySQL performance. Alexander also helped customers design Big Data stores with Apache Hadoop and related technologies.

Leave a Reply