Database Systems – Blog by Jay Mutkawoa (Nitin)

Securing MySQL traffic with Stunnel in a jail environment on CentOS

Post Author By Nitin J Mutkawoa
Post Date October 31, 2017
Post Comment 2 comments

Stunnel is a program by Michal Trojnara that allows you to encrypt arbitrary TCP connections inside SSL. Stunnel can also allow you to secure non-SSL aware daemons and protocols (like POP, IMAP, LDAP, etc) by having Stunnel provide the encryption, [Read More…]

Database Systems Linux Application Linux System Security

How i optimised my WordPress website ?

Post Author By Nitin J Mutkawoa
Post Date January 1, 2017
Post Comment 0 comments

Some days back, I was brewing up some plans to optimize my website source codes, HTTP headers, latency, and other security aspects. I had to carry out some analysis and research using some tools available on the internet. I should [Read More…]

Database Systems Security

Introducing MariaDB MaxScale 2.0 – Webinar

Post Author By Nitin J Mutkawoa
Post Date October 6, 2016
Post Comment 0 comments

Today, I attended a webinar conference on MariaDB MaxScale carried out by Roger Bodamer at 10.00 AM PDT. That was really interesting and I strongly feel the future of system and database administrators are going to be enhanced with this technology. [Read More…]

Database Systems

MySQL Binlogs Analysis for data loss

Post Author By Nitin J Mutkawoa
Post Date September 2, 2016
Post Comment 0 comments

Some days back, I encountered a server where it happens that some data was altered in the database. A quick report can be generated with the mysqlbinlog command. The MySQL bin logs contains “events” that describe database changes such as [Read More…]

Database Systems Linux System

Messing around PL/Tcl on PostgreSQL

Post Author By Nitin J Mutkawoa
Post Date July 4, 2016
Post Comment 0 comments

Some days back, i was having an issue whilst activating the PL/Tcl extension/language on PostgreSQL. Luckily, it was possible with the help from Mauricio Cortes, a guy from the Facebook group PostgreSQL Server. Let’s first see what is TCL package. “PL/Tcl [Read More…]