MongoDB Version Upgrade 3.4 to 3.6

-

Upgrade of Mongo 3.4 to 3.6

Please follow below steps to upgrade from Mongo 3.4 to 3.6

Pre-requisites:


1.       Make sure your Mongo version running on Mongo 3.4
2.       Connect to Mongo Shell and run the below command on the Primary Node
a.       db.adminCommand( { setFeatureCompatibilityVersion: "3.4" } )
POC:PRIMARY> db.adminCommand( { setFeatureCompatibilityVersion: "3.4" } )
{ "ok" : 1 }
POC:PRIMARY>
3.       Make sure you have the Mongo 3.6 binaries ready

Upgrade Procedure:


1.       Stop the Mongod service on one of the secondary node
Sudo /etc/init.d/monogd stop
2.       Un-tar the Mongo.3.6.tz file to a location
[root@dfwlncmgdb-06 kolguk01]# tar -xvf mongodb-linux-x86_64-rhel62-3.6.3.tgz
3.        Replace the Mongo binaries present in the /usr/bin location with the Mongo 3.6 binaries
yes | cp -rf /home/kolguk01/mongodb-linux-x86_64-rhel62-3.6.3/bin/* /usr/bin/
4.       Make changes to the mongod configuration file, add a new parameter bindIpAll
vi /etc/mongod.conf
#override port
net:
port: 27018
#bindIp: 151.138.21.74 #IP address of the node
bind_ip_all=true

5.       Start the Mongod Process
Sudo /etc/init.d/monogd start

6.       Connect to the Mongo shell and verify the version
[root@dfwlncmgdb-04 kolguk01]# mongo --port 27018 --host dfwlncmgdb-04
MongoDB shell version v3.6.3
connecting to: mongodb://dfwlncmgdb-04:27018/
MongoDB server version: 3.6.3
7.       Wait until the node be in sync with Primary

Once the node becomes secondary; follow the same steps on other secondary and then finally do it on the Primary.


Comments

Post a Comment

Popular posts from this blog

Netezza Commands

-
Table Size  select tablename, used_bytes/pow(1024,4) as used_TB   from _v_table_storage_stat  where tablename  in (  select tablename from _v_table where tablename not like  '_VT_%' and tablename not like '_T_%'); Objects owned by a user: select o.objname, d.database, oc.classname, u.usename from _t_object o, _t_user u, _t_object_classes oc, _v_database d where u.usename='username' and u.usesysid=o.objowner and o.objclass=oc.objclass and o.objdb=d.objid; Tip: Use NZ_HELP to get   syntax of all commands Like -    nz_help | grep grant [nz@dfw86inzb-04 ~]$ nz_help | grep grant nz_db_group_access_listing           To show what groups have been granted access to what databases. nz_db_user_access_listing            To show what users have been granted access to what databases. nz_ddl_grant_group    ...
Read more

MS SQL Server Tips

-
Image
Unable to Shrink the DataFile If you are unable to shrink the datafile then try the following Error :  File ID 3 of database ID 8 cannot be shrunk as it is either being shrunk by another process or is empty. DBCC execution completed. If DBCC printed error messages, contact your system administrator. Solution:   Add at least 2-3 MB to the data file and start shrinking again. Index Fragmentation Level SELECT distinct dbschemas.[name] as 'Schema', dbtables.[name] as 'Table',  dbindexes.[name] as 'Index', indexstats.avg_fragmentation_in_percent, indexstats.page_count, i.rowcnt as 'totalrows' FROM sys.dm_db_index_physical_stats (DB_ID(), NULL, NULL, NULL, NULL) AS indexstats INNER JOIN sys.tables dbtables on dbtables.[object_id] = indexstats.[object_id] INNER JOIN sys.schemas dbschemas on dbtables.[schema_id] = dbschemas.[schema_id] INNER JOIN sys.indexes AS dbindexes ON dbindexes.[object_id] = indexstats....
Read more
-
Maintenacne Plan creation USE [msdb] GO DECLARE @sqlInstance varchar(20) SET @sqlInstance = '$(instanceName)' DECLARE @BackUpSubPlan sysname SET @BackUpSubPlan = 'Back Up Database Task' DECLARE @BackUpJobName sysname SET @BackUpJobName = 'System databases.' + @BackUpSubPlan DECLARE @ChkDbSubPlan sysname SET @ChkDbSubPlan = 'Check Database Integrity Task' DECLARE @ChkDbJobName sysname SET @ChkDbJobName = 'System databases.' + @ChkDbSubPlan DECLARE @RebuildIndexSubPlan sysname SET @RebuildIndexSubPlan = 'Rebuild Index Task' DECLARE @RebuildIndexJobName sysname SET @RebuildIndexJobName = 'System databases.' + @RebuildIndexSubPlan DECLARE @UpdStatsSubPlan sysname SET @UpdStatsSubPlan = 'Update Statistics Task' DECLARE @UpdStatsJobName sysname SET @UpdStatsJobName = 'System databases.' + @UpdStatsSubPlan DECLARE @HistClnSubPlan sysname SET @HistClnSubPlan = 'History Cleanup Task' ...
Read more