Mongo DB for the SQL DBA Where does

Mongo. DB for the SQL DBA

Where does the name Mongo. DB come from?

• Operations DBA w local software company • Worked with SQL Server versions 7 – 2014 (2016 soon) • Worked in small (<10), large (>5000) , financial, manufacturing, software dev and e-commerce companies • Work with Mongo. DB v 3. 4 • B. S. in Nuclear Medicine Technology Email: Metal. DBA@gmail. com Twitter: @Saalmann

• • What is Mongo. DB Why use Mongo. DB Why not use Mongo. DB Installation of Mongo. DB Creating database, collections and documents Queries in Mongo. DB Backups & Restores Robomongo

What does Mongo. DB Looks like?

Mongo. DB is an open source database that uses a document-oriented data model Classified as a No. SQL database program, Mongo. DB uses JSONlike documents

A human-readable, plain text format for expressing structured data with support in many programming languages

BSON is a binary representation of JSON documents, it contains more data types than JSON.

SQL Server Mongo. DB Database Table Collection Row Document Column Field Index Partition Sharding Clustering Replica. Set Joining Linking & Embedding

Why use Mongo. DB? • You must store unstructured data • You have a very high write load (without transactions) • You need to handle more reads & writes than a single server can handle • You need a solution that can easily scale-out(sharding) • You work with tables with very inconsistent schemas • You need high availability solution built-in (Replica. Sets) • You need high performance (most of the data is stored in ram) • You need built in geospatial functions

No support for transactions Limited support for joins • No support for triggers Document size limit (16 mb) Your data is relational You don’t want duplicate data.

NO Know your data Know your application

Ahmad Drshen Personal blog : www. adrshen. com Over 15 years of Information Technology experience with the last 12 years focused on mastering the Microsoft SQL Server platform including Power BI , Data Science algorithms and Mongo. DB. Trained with industry known SQL gurus Paul Randel, Kimberly L. Tripp, Jonathan Kehayias, Glenn Berry and Brent Ozar Twitter adrshen Linkedin : adrshen Industries served, financial, banking, mortgage, retail, healthcare & insurance

Download community edition at https: //www. mongodb. com/download-center Prerequisites or Requirement https: //docs. mongodb. com/manual/tutorial/install-mongodb-on-windows/ Robo 3 T- a user friendly studio to work with mongo databases and collections https: //robomongo. org/ Mongo Compass --analyze and understand the contents of your collections https: //docs. mongodb. com/compass/current/

Component Set Binaries Server mongod. exe Router mongos. exe Client mongo. exe Monitoring Tools mongostat. exe, mongotop. exe Import. Export. Tools mongodump. exe, mongorestore. exe, mongoexport. exe, mongoimport. exe Miscellaneous. Tools bsondump. exe, mongofiles. exe, mongooplog. exe, mongoperf. exe monoreplay. exe , mongoldap. exe

Backup & Restore Demo

Mongo. DB Backup & Restore https: //adrshen. com/2017/08/01/all-about-mongobackups-restore/

Mongo. DB Monitoring Demo

Questions?