DB/MongoDB - Revision history

Pio2pio: /* Failover PRIMARY */

2022-04-22T12:37:35Z

Failover PRIMARY

← Older revision		Revision as of 14:37, 22 April 2022
Line 207:		Line 207:
	rs0:PRIMARY> rs.status(); # verify, the reconfiguration take around 8-12 seconds		rs0:PRIMARY> rs.status(); # verify, the reconfiguration take around 8-12 seconds
	</source>		</source>

			= ReplicaSet Voting =
			* [https://stackoverflow.com/questions/15597372/voting-in-mongodb voting-in-mongodb]

2022-04-14T08:52:54Z

Operational MongoDb queries

@@ Line 48: / Line 48: @@
 rs.status()                  # show current replica set status
 printjson(db.serverStatus()) # server status
 </source>

2022-04-14T08:32:34Z

Connect

← Older revision		Revision as of 10:32, 14 April 2022
Line 34:		Line 34:

	# Connect via kubectl exec		# Connect via kubectl exec
	kubectl -n mongo exec -it mongodb-0 -- mongo -u MONGODB_USERNAME -p $MONGODB_PASSWORD --eval "rs.conf()"		kubectl -n mongo exec -it mongodb-0 -- mongo -u $MONGODB_USERNAME -p $MONGODB_PASSWORD --eval "rs.conf()"
	</source>		</source>

2022-04-14T08:32:25Z

Connect

← Older revision		Revision as of 10:32, 14 April 2022
Line 24:		Line 24:
	MongoDB version 4		MongoDB version 4
	<source lang=bash>		<source lang=bash>
	~~kubectl -n mongo exec -it mongodb-0 -- mongo -u root -p $PASSWORD --eval "rs.conf()"~~

	MONGODB_USERNAME=root		MONGODB_USERNAME=root
	MONGODB_PASSWORD=password1		MONGODB_PASSWORD=password1

	mongosh mongodb://${MONGODB_USERNAME}:${MONGODB_PASSWORD}@mongodb.mynamespace:27017/mydatabase?replicaSet=rs0		mongosh mongodb://${MONGODB_USERNAME}:${MONGODB_PASSWORD}@mongodb.mynamespace:27017/mydatabase?replicaSet=rs0
	Connecting to: mongodb://<credentials>@mongodb.mynamespace:27017/mydatabase?replicaSet=rs0&appName=mongosh+1.3.1		Connecting to: mongodb://<credentials>@mongodb.mynamespace:27017/mydatabase?replicaSet=rs0&appName=mongosh+1.3.1
Line 33:		Line 32:
	Using Mongosh: 1.3.1		Using Mongosh: 1.3.1
	rs0 [primary] mydatabase>		rs0 [primary] mydatabase>

			# Connect via kubectl exec
			kubectl -n mongo exec -it mongodb-0 -- mongo -u MONGODB_USERNAME -p $MONGODB_PASSWORD --eval "rs.conf()"
	</source>		</source>

2022-04-14T08:30:59Z

Connect

2022-04-14T08:30:49Z

Connect

← Older revision		Revision as of 10:30, 14 April 2022
Line 22:		Line 22:

	= Connect =		= Connect =
			MongoDB version 4
	<source lang=bash>		<source lang=bash>
	~~# mongo version 4~~
	kubectl -n mongo exec -it mongodb-0 -- mongo -u root -p $PASSWORD --eval "rs.conf()"		kubectl -n mongo exec -it mongodb-0 -- mongo -u root -p $PASSWORD --eval "rs.conf()"

	# ~~mongo~~ version 5		MONGODB_USERNAME=root
			MONGODB_PASSWORD=password1
			mongosh mongodb://${MONGODB_USERNAME}:${MONGODB_PASSWORD}@mongodb.mynamespace:27017/mydatabase?replicaSet=rs0
			Connecting to: mongodb://<credentials>@mongodb.mynamespace:27017/mydatabase?replicaSet=rs0&appName=mongosh+1.3.1
			Using MongoDB: 4.4.6
			Using Mongosh: 1.3.1
			rs0 [primary] mydatabase>
			</source>


			# MongoDB version 5
			<source lang=bash>
	mongocli <...>		mongocli <...>
	</source>		</source>

2022-04-14T08:16:59Z

mongocli

← Older revision		Revision as of 10:16, 14 April 2022
Line 6:		Line 6:
	# Install generic tools		# Install generic tools
	DEBIAN_FRONTEND=noninteractive apt install -yq dnsutils iproute2 iputils-ping iputils-tracepath net-tools netcat procps curl wget		DEBIAN_FRONTEND=noninteractive apt install -yq dnsutils iproute2 iputils-ping iputils-tracepath net-tools netcat procps curl wget
	# Install ~~mongo cli~~		# Install mongocli
	apt-get install gnupg -yy		apt-get install gnupg -yy
	wget -qO - https://www.mongodb.org/static/pgp/server-5.0.asc \| apt-key add -		wget -qO - https://www.mongodb.org/static/pgp/server-5.0.asc \| apt-key add -
Line 13:		Line 13:
	apt-get update		apt-get update
	apt-get install -y mongocli		apt-get install -y mongocli
			mongocli <...>

			# Install mongo shell - version 4.x
			wget https://downloads.mongodb.com/compass/mongodb-mongosh_1.3.1_amd64.deb
			dpkg -i mongodb-mongosh_1.3.1_amd64.deb
			mongosh <...>
	</source>		</source>

2022-04-14T08:02:32Z

Connect

← Older revision		Revision as of 10:02, 14 April 2022
Line 16:		Line 16:

	= Connect =		= Connect =
			<source lang=bash>
			# mongo version 4
			kubectl -n mongo exec -it mongodb-0 -- mongo -u root -p $PASSWORD --eval "rs.conf()"

			# mongo version 5
			mongocli <...>
			</source>

	= Operational MongoDb queries =		= Operational MongoDb queries =

2022-04-14T07:30:10Z

Operational MongoDb queries

← Older revision		Revision as of 09:30, 14 April 2022
Line 14:		Line 14:
	apt-get install -y mongocli		apt-get install -y mongocli
	</source>		</source>

			= Connect =


	= Operational MongoDb queries =		= Operational MongoDb queries =

2022-03-31T20:09:54Z

Passwords management

← Older revision		Revision as of 22:09, 31 March 2022
Line 23:		Line 23:

	= Passwords management =		= Passwords management =
	All write operation like a password change must be run on a PRIMARY cluster member.		All write operation like a password change must be run on a PRIMARY cluster member. Each database in Mongo cluster has its own set of users.

	<source lang=bash>		<source lang=bash>