By Abhishek Ghosh May 31, 2019 11:36 pm Updated on May 31, 2019

Fix : Hard Disk Full of MySQL Log Files, MySQL Failing to Start

Server hard disk full is quite common matter, especially on the cloud servers. Usual disk space allocated on common RAM size cloud server instance is 30-40GB. Bigger websites easily eat up 10GB space for the media files. System files including running applications take more than 10GB. And for WordPress, full hard disk will result showing up the infamous "Error Establishing a Database Connection" … [Read more...]

By Abhishek Ghosh April 19, 2019 4:34 pm Updated on April 19, 2019

How to Connect Apache Kafka With MQTT

This is not a step by step guide with commands. This is a guide to get started moving from generic Kafka to Confluent Inc's Kafka, Connectors and ready to consume one GitHub repository. Initially it will appear that with the easiness we installed Apache Kafka and MQTT Server, with same easiness we can connect Apache Kafka with MQTT. There are actually many things to learn, think. MQTT is a … [Read more...]

By Abhishek Ghosh March 28, 2019 4:47 am Updated on March 28, 2019

How to Send Data from Arduino to MySQL Database

In our recent past discussions, we have send data from ESP32 Arduino to IBM Watson IoT by either using MQTT or by using HTTP POST. In the same way, we have discussed how with CouchDB we can send data from ESP32 Arduino. Also, we have discussed different types of cloud database for IoT. MySQL is widely used database for PHP driven web applications. We can send data from Arduino, ESP32 to MySQL … [Read more...]

By Abhishek Ghosh March 24, 2019 11:07 am Updated on March 24, 2019

How to Install CouchDB on Ubuntu Cloud Server

Here Are the Steps to How to Install CouchDB on Ubuntu Cloud Server With root Access as Single Node. Data can be ported from Cloudant to CouchDB. There is CouchDB, CouchIO, CouchOne, Couchbase, Couchbase Server, Couchbase Mobile, Couchbase Lite, CouchApps, BigCouch, Touchbase, Membase, Memcached, MemcacheDB. All are different but are related in a way not obvious from the names alone. First, there … [Read more...]

By Abhishek Ghosh March 14, 2019 6:18 pm Updated on March 14, 2019

WordPress Security : Apache2 Module to Log HTTP POST Method

Earlier we discussed about the HTTP POST method. Technically We Should Log HTTP Request Methods. Here is How to Apache Module to Log HTTP POST Method, As Example For WordPress Installation. After examination of few weeks log, we can block the malicious HTTP POST requests. This guide is for those who have installed Apache HTTPD server using our method. We say `apache2` instead of … [Read more...]

By Abhishek Ghosh March 11, 2019 6:01 pm Updated on March 11, 2019

How to Install Mosquitto MQTT Broker/Server on Ubuntu Cloud Server

Here is How To How to Install Mosquitto MQTT Broker/Server on Ubuntu Cloud Server So That You Need Not to Depend on Third Party MQTT Broker. To connect to a command line on your server instance you will need to use SSH with `root` privilege. Update, upgrade and install the required packages from Ubuntu repo : # sudo apt update sudo apt install mosquitto # install the … [Read more...]

By Abhishek Ghosh March 2, 2019 7:40 pm Updated on March 2, 2019

Analyzing Unexpected Shutdown of Ubuntu Cloud Server

Ideally one should everyday login to Ubuntu server running WordPress like software. Public internet has been dangerous and hackers known to perform various kind of practice. It is not great get astonished by an unexpected shutdown of cloud server in clueless manner. Overheating a common issue for the dedicated servers while cloud Server instances commonly have the issue of operating system … [Read more...]

By Abhishek Ghosh February 24, 2019 12:08 pm Updated on February 24, 2019

Why MySQL Auto Restart Failing in WordPress Cloud Server

Why MySQL Auto Restart Failing in WordPress Cloud Server Despite Your Efforts of Trying Various Optimization and Scripts to Auto-Restart? We already talked around fixing Error Establishing a Database Connection in WordPress, Autostart MySQL After a Crash, other MySQL fixes for Ubuntu and latest fixes for Ubuntu 18.04. Various updates on the part of different software partially force us to discover … [Read more...]

By Abhishek Ghosh December 26, 2018 9:52 am Updated on December 26, 2018

How To Install Apache Phoenix (SQL on HBase)

We talked about Apache Phoenix in our previous guides and articles such as How To Install Apache HBase and List of Apache Projects For Big Data. Apache Phoenix is a massively parallel, relational database engine supporting OLTP for Hadoop using Apache HBase as store. Phoenix provides a JDBC driver that cleverly hides the noSQL store in front enabling the users to create, delete, and alter SQL … [Read more...]