Learning by Doing

Assuming we have a replicate set started as such, please refer to article 1  or article 2 to see how to configure a replica set if you haven't already done so and still have issues. Output of ps -ef | grep mongod root     20706     1  0 15:09 ?        00:00:01 mongod --port 31111 --replSet biDemo --dbpath /data/mongodb/demo1 --logpath /data/mongodb/demolog/1.log --fork  root     20943     1  0 15:10 ?        00:00:01 mongod --port 31112 --replSet biDemo --dbpath /data/mongodb/demo2 --logpath /data/mongodb/demolog/2.log --fork root     21101     1  0 15:11 ?        00:00:01 mongod --port 31113 --replSet biDemo --dbpath /data/mongodb/demo3 --logpath /data/mongodb/demolog/3.log --fork  Log into primary and add user, you will need at least one admin user to start and administer mongod with authentication enabled MongoDB Ente...

Often time when we want to quickly spin up a demo mongodb replica set, we would simply use the localhost:port to specify the nodes assuming all members are on the same server. Here is an quick example why that's not a good practice Here is the output of my current rs.status() MongoDB Enterprise biDemo:PRIMARY> conf= rs.conf() {         "_id" : "biDemo",         "version" : 5,         "protocolVersion" : NumberLong(1),         "members" : [                 {                         "_id" : 0,                         "host" : "localhost:31111",                         "arbiterOnly" : false,                         "b...

This is a quick guide for GoldenGate replication within the same database from one schema to another. Dblogin and add checkpoint table GGSCI > dblogin userid ggs_owner, password ggs_owner GGSCI > add checkpointtable ggg.chk extract parameter file: es1.prm GGSCI > edit param es1 vi mode EXTRACT es1 SETENV (ORACLE_SID=orcl) SETENV (ORACLE_HOME="/a01/app/oracle/product/11.2.0/dbhome_1") userid ggg, password ggg EXTTRAIL /gg_01/app/goldengate/product/12.1.0/dirdat/ea WILDCARDRESOLVE DYNAMIC EOFDELAY 5 TABLE S1.T1; TABLE S2.T2; replicat parameter file: rs1.prm GGSCI > edit param rs1 vi mode REPLICAT rs1 ASSUMETARGETDEFS SETENV (ORACLE_SID=orcl) SETENV (ORACLE_HOME="/a01/app/oracle/product/11.2.0/dbhome_1") REPERROR (-1, IGNORE) REPERROR (1403, IGNORE) userid ggg, password ggg dboptions nosuppresstriggers HANDLECOLLISIONS MAP S1.T1, TARGET S2.T1; MAP S1.T2, TARGET S2.T2; Configure extract process: GGSCI > ADD EXTRACT ES1, TRAN...

In this post I am working with mongodb 3.4.6 on Redhat 7.x This was supposed to be a super straight forward exercise for me as I had done it a few times in the past and I'd never really encountered any issue until today. I started the mongod service as such, and I verified the process is running Note: every node in this exercise started the same way, same data mount, log mount, same port, etc. [root@msdlva-dsnopm02 apps]# mongod --port 30000 --dbpath /apps/data --logpath /apps/log/appDBlog.log & [root@msdlva-dsnopm02 apps]# ps -ef | grep mongod root 12854 23282 6 08:31 pts/0 00:00:00 mongod --port 30000 --dbpath /apps/data --logpath /apps/log/appDBlog.log root 12880 23282 0 08:32 pts/0 00:00:00 grep --color=auto mongod Then I logged into this node by issuing and started working on adding replica set member [root@msdlva-dsnopm02 apps]# mongo --port 30000 MongoDB shell version v3.4.6 connecting to: mongodb://127.0.0.1:30000/ MongoDB server version: 3....