The Clickhouse server logs are often useful in diagnosing issues and understanding how clients are interacting with Clickhouse. They are however fairly low level and detailed out of the box. At this stage therefore, it is worth reducing the logging level to only show warnings and errors as opposed to Continue Reading
Read MongoDB Data From ClickHouse
In this article, you will learn how to read your data from ClickHouse which is stored in MongoDB. MongoDB engine is read-only table engine which allows to read data (SELECT queries) from remote MongoDB collection. Engine supports only non-nested data types. INSERT queries are not supported. First, you have to create a table Continue Reading
Apache ZooKeeper Installation On Linux
Installing Apache ZooKeeper on Ubuntu 1. Updating system repositories We need to make our system repositories up to date in order to avoid running into different errors later during installation. sudo apt update && apt upgrade -y 2. Install Java runtime Apache ZooKeeper requires java to run because it is Continue Reading
Couchbase User Automation On Linux
In this article, you will examine how to manage couchbase user operations with an automation via bash script. !/bin/bash v1=$1 v2=$2 while : do echo “###################” echo “1. Get Users Information” echo “2. Current User’s Roles List” echo “3. Change Password” echo “4. List All Roles” echo “5. Grant Role Continue Reading
Orphan Record Check On MongoDB
Run the command below after switch database. use test; db.collname.find( { }, { _id: 1, _id: 0 } ).hint( { _id: 1 } ).explain(true) “chunkSkips” : 0, check the chunkskips row. If its greater than 0 that means there are some orphan records on mongodb. —— Clear Orphan var dbName: Continue Reading
How To Merge Chunks On MongoDB
There is a script that for merge chunks on mongodb use config // dbName: Set this to the database name// collection: Set this to the collection you want to merge chunks in// keyPattern: Set this to the key pattern, ie { “_id” : “hashed” }// sleepValue: How long to sleep Continue Reading
MongoDB Enable Sharding
Enable Sharding In order to shard a collection in mongodb, you need to set up a structure in accordance with the following criterias. Note: There is no rollback sharding process before mongodb version 5.0. The sharding key should be based on an index consisting of the commonly used query filter Continue Reading
Oracle 19c Enterprise Manager Database Express Not Working – Solving
To performance monitoring, administrators commonly use Enterprise Manager Database Express. If you are not able to access Enterprise Manager Database Express it might be there is no port number set, you wallet file has no permisson of 600, listener does not working or your browser do not have flash player. Continue Reading
Oracle 19 Installation On Linux
I am going to install oracle 19c on oracle linux. You can check oracle linux installation article from here; http://www.cansayin.com/2019/11/16/oracle-linux-7-5-installation-and-configuration/ First set the host in /etc/hosts file. Write your ip address and the hostname vi /etc/hosts 192.168.154.132 localhost.localdomain localhost Then install required packages before database installation. Some of the packages Continue Reading
Couchbase Server Upgrade On Linux
Upgrade Couchbase Server is quite simple. You can upgrade your couchbase server with a few steps .I am going to upgrade my server from 6.0 to 6.5. Couchase allows directly upgrade from 6.0 to 6.5.If you want to upgrade from previous versions, you have to upgrade previous paths before upgrade Continue Reading