How to list MongoDB connections - client ip and port

Question: How can I list client ip , port and connection ID of connections to MongoDB? I want to connect through the MongoDB command line and extract this information as I'm testing some HA failover scenarios. Answer: There's a few different ways to extract the MongoDB connection details - for example you can use netstat. But from the command line - this syntax will report the details required db.currentOp(true).inprog.forEach(function(d){if(d.client)print(d.client, d.connectionId)}) Example output - clientip:port clientid: 127.0.0.1:55552 4668364 10.120.xxx.xxx:60942 4668363 10.120.xxx.xxx:60924 4668357 Read More on MongoDB How to read MongoDB system log file MongoDB cheatsheet Read more →

bash: /home/myuser/.ssh/authorized_keys: No such file or directory

Question: When I type in cat ~/.ssh/authorized_keys to a RHEL 7 server I get the following message: cat: /root/.ssh/authorized_keys: No such file or directory I'm going through the process of setting up a SSH to create a connection between BART and client Potgresql servers - to backup Postgresql databases. How can I fix this issue? Answer:You need to create the ssh directory for the first time and create the authorized keys file. Create the .ssh directory. First check if actually already exists mkdir ~/.ssh Set the right permissions for the new .ssh directory. Very important step chmod 700 ~/.ssh Create... Read more →

How to load csv data with quotes and ENCLOSED BY into MariaDB table

Question : I have a csv file , with 1 million rows and would like to import into a MariaDB table.I'm importing successfully but having a problem with a row where the "," is within a double quote. Example row: GenerationX,Rufus,Johnny,"Chat hype, Power crazy" i.e instead of getting 4 columns , I'm getting 5 , because the comma within the 4th column is splitting the data Could you give me an example of how to load the data and maintain the data integrity ? Answer: When loading data into a MariaDB table the optional : ENCLOSED BY can help you.... Read more →

MariaDB /tmp file filling with MAD file

Question: I've received an alert from a RHEL server with MariaDB installed. The alert refers to a MAD file filling the /tmp drive . What is going on? and how can I fix the mysql MAD file filling the /tmp drive? Answer: This is a common problem when under certain circumstances - CREATE & ALTER statements executed on InnoDB tables create a temporary table in mysql's tmpdir. To find out the current value check my.cnf or use SHOW VARIABLES LIKE "TMPDIR During the data load phase MariaDB creates a temporary table in /tmp - which consequently fills the /tmp The... Read more →

Quick access to MariaDB Cheatsheet

Quick access to MariaDB commands I use on a daily basis including connection, DDLs of various database objects, backups , port numbers and other useful metadata details --connect to a MariaDB through command line mysql --user=myuser --password=mypw --port=myportnumber --host=myservername --find data directory select @@datadir --MariaDB port number used SHOW GLOBAL VARIABLES LIKE 'PORT'; --backup mysqldump -u myun -p database_name > /mariadb/backups/mydb171117.sql Note: you'll be prompted for the password --list indexes SHOW INDEX FROM mytable; --drop index DROP idx1 ON MYTABLE --list tables show tables; --list views SHOW FULL TABLES IN database_name WHERE TABLE_TYPE LIKE 'VIEW'; --list databases show databases; --list... Read more →