Mongodb - Revision history

M: /* Upgrade */

2025-01-30T22:04:44Z

Upgrade

← Older revision		Revision as of 22:04, 30 January 2025
Line 43:		Line 43:

	The problem is... mongo devs are TOO LAZY to write the code to auto-update. So you have to follow their stupid little instructions, which basically involve moving through upgrade steps across specific versions. And each version requires a bunch of apt foo. It SUCKS and MAKES ME SAD. It is utterly shameful.		The problem is... mongo devs are TOO LAZY to write the code to auto-update. So you have to follow their stupid little instructions, which basically involve moving through upgrade steps across specific versions. And each version requires a bunch of apt foo. It SUCKS and MAKES ME SAD. It is utterly shameful.

			Basic instructions are [https://www.mongodb.com/docs/v8.0/tutorial/install-mongodb-on-ubuntu/ here].

	=== Upgrade 3.6 to 4.0 ===		=== Upgrade 3.6 to 4.0 ===

M: /* Ubuntu */

2023-08-09T14:38:54Z

Ubuntu

← Older revision		Revision as of 14:38, 9 August 2023
Line 272:		Line 272:
	=== Ubuntu ===		=== Ubuntu ===
	6:		6:
	# remove 5 (it will keep databases)		# remove 5 (it will keep databases??)
	sudo apt remove mongodb-org		sudo apt remove mongodb-org
	# then remove apt sources.list.d file		# then remove apt sources.list.d file

M: /* Ubuntu */

2023-08-09T14:37:09Z

Ubuntu

← Older revision		Revision as of 14:37, 9 August 2023
Line 272:		Line 272:
	=== Ubuntu ===		=== Ubuntu ===
	6:		6:
	# remove 5		# remove 5 (it will keep databases)
	sudo apt remove mongodb-org		sudo apt remove mongodb-org
	# then remove apt sources.list.d file		# then remove apt sources.list.d file

M: /* Ubuntu */

2023-08-09T14:36:55Z

Ubuntu

← Older revision		Revision as of 14:36, 9 August 2023
Line 272:		Line 272:
	=== Ubuntu ===		=== Ubuntu ===
	6:		6:
			# remove 5
			sudo apt remove mongodb-org
			# then remove apt sources.list.d file

	# add key		# add key
	curl -fsSL https://pgp.mongodb.com/server-6.0.asc \| \		curl -fsSL https://pgp.mongodb.com/server-6.0.asc \| \
Line 285:		Line 289:
	mh-install-mongodb (NEEDS WORK)		mh-install-mongodb (NEEDS WORK)

	~~Manually~~:		5:
	wget -qO - https://www.mongodb.org/static/pgp/server-5.0.asc \| sudo apt-key add -		wget -qO - https://www.mongodb.org/static/pgp/server-5.0.asc \| sudo apt-key add -
	echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu focal/mongodb-org/5.0 multiverse" \| sudo tee /etc/apt/sources.list.d/mongodb-org-5.0.list		echo "deb [ arch=amd64,arm64 ] https://repo.mongodb.org/apt/ubuntu focal/mongodb-org/5.0 multiverse" \| sudo tee /etc/apt/sources.list.d/mongodb-org-5.0.list

M: /* Ubuntu */

2023-08-08T20:21:40Z

Ubuntu

← Older revision		Revision as of 20:21, 8 August 2023
Line 272:		Line 272:
	=== Ubuntu ===		=== Ubuntu ===
	6:		6:
			# add key
			curl -fsSL https://pgp.mongodb.com/server-6.0.asc \| \
			sudo gpg -o /usr/share/keyrings/mongodb-server-6.0.gpg \
			--dearmor
			# add apt repo
	echo "deb [ arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-6.0.gpg ] https://repo.mongodb.org/apt/ubuntu jammy/mongodb-org/6.0 multiverse" \| sudo tee /etc/apt/sources.list.d/mongodb-org-6.0.list		echo "deb [ arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-6.0.gpg ] https://repo.mongodb.org/apt/ubuntu jammy/mongodb-org/6.0 multiverse" \| sudo tee /etc/apt/sources.list.d/mongodb-org-6.0.list
			# install
	sudo apt-get update		sudo apt-get update
	sudo apt-get install -y mongodb-org		sudo apt-get install -y mongodb-org


	script:		script:

M: /* Ubuntu */

2023-08-08T20:18:07Z

Ubuntu

← Older revision		Revision as of 20:18, 8 August 2023
Line 271:		Line 271:

	=== Ubuntu ===		=== Ubuntu ===
			6:
			echo "deb [ arch=amd64,arm64 signed-by=/usr/share/keyrings/mongodb-server-6.0.gpg ] https://repo.mongodb.org/apt/ubuntu jammy/mongodb-org/6.0 multiverse" \| sudo tee /etc/apt/sources.list.d/mongodb-org-6.0.list
			sudo apt-get update
			sudo apt-get install -y mongodb-org


			script:
	mh-install-mongodb (NEEDS WORK)		mh-install-mongodb (NEEDS WORK)

M at 14:02, 8 August 2023

2023-08-08T14:02:50Z

← Older revision		Revision as of 14:02, 8 August 2023
Line 23:		Line 23:

	==== Turn on profiling ====		==== Turn on profiling ====
	~~You can~~ adjust the max size of the profiler data~~, here it is expanded~~ to 10MB:		Typically you'd want level 1 (all queries slower than the "slowms" setting, which defaults to 100ms). We adjust the max size of the profiler data to 10MB:
	db.setProfilingLevel(0); db.system.profile.drop(); db.createCollection("system.profile", {capped: true, size: 10 * 1024 * 1024}); db.setProfilingLevel(1);		db.setProfilingLevel(0); db.system.profile.drop(); db.createCollection("system.profile", {capped: true, size: 10 * 1024 * 1024}); db.setProfilingLevel(1); db.getProfilingStatus();

	==== View profiler results ====		==== View profiler results ====
	Set the min ms you want. Note that 100ms is the default "slowms" value for level-1 profiling (you won't see any profiling for anything faster than that unless you change settings or use level-2 (everything)).		Set the min ms you want. Note that 100ms is the default "slowms" value for level-1 profiling (you won't see any profiling for anything faster than that unless you change settings or use level-2 (everything)).
	db.system.profile.find({ "millis": { $gt: 100 } }, { millis: NumberInt(1), "query": NumberInt(1), "command": 1 }).sort({ millis: -1 })		db.system.profile.find({ "millis": { $gt: 100 } }, { millis: NumberInt(1), "query": NumberInt(1), "command": 1 }).sort({ millis: -1 })

			Here you can view all full COLLSCANs. First, reset profiling to level 2 to profile ALL queries. Then check this and fix em even on small collections, to ensure all lookups are optimized with an index:
			db.system.profile.find({"planSummary":{$eq:"COLLSCAN"}, "op" : {$eq:"query"}}).sort({millis:-1});

	== Run a script or statement from command line ==		== Run a script or statement from command line ==

M at 13:58, 8 August 2023

2023-08-08T13:58:39Z

@@ Line 17: / Line 17: @@
 * To remove all documents that do not have a range of values:
   db.inventory.remove( { type : { $nin: ["Apple", "Mango"] } } )
 == Run a script or statement from command line ==

M: /* Notes */

2022-08-15T22:31:21Z

Notes

@@ Line 230: / Line 230: @@
                      })
                      printjson(rs.reconfig(cfg));
 I still don't understand how any sane automatic failover is supposed to work.  Stupid mongo.

M: /* Convert a single node to a replica set */

2022-08-15T22:25:06Z

Convert a single node to a replica set

← Older revision		Revision as of 22:25, 15 August 2022
Line 206:		Line 206:
	# MBM enable replication		# MBM enable replication
	replication:		replication:
	replSetName: ~~esrs1~~		replSetName: myrs1
	# -----------------------		# -----------------------