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?
- Slides: 33