Apache Drill is SQL Query Engine for Hadoop, NoSQL, Cloud Storage and file systems including HBase, MongoDB, MapR-DB, HDFS, MapR-FS, Amazon S3, Azure Blob Storage, Google Cloud Storage, Swift, NAS and local files. As example, we can join a collection in MongoDB with a directory of event logs in Hadoop. Apache Drill features JSON data model which enables queries on complex and nested data. Drill … [Read more...]
Configure Fail2Ban With Mod Security And Other Filters
This guide better to said to be continuation of IPtables Basic 3 and installing Mod Security. In this guide we will discuss around how to configure Fail2Ban with Mod Security & some other filters on Apache server to protect from PHP and other exploits. We are taking it granted that, from new user you are now somewhat used with Fail2Ban. Configure Fail2Ban With Mod Security … [Read more...]
mysqlcheck : Check, Repair, Optimize MySQL Tables
Previously we talked about MyISAM and Innodb, that has importance in this context. mysqlcheck is a command line utility to check, repair, optimize MySQL Tables. mysqlcheck offers an efficient way to perform maintenance of the database tables. mysqlcheck checks, repairs, optimizes MySQL tables within the database. mysqlcheck intended to be used when the mysqld server is running. mysqlcheck executes … [Read more...]
Setup SFTP Without Shell Access For WordPress, Cloud Server
Normally we have a common security setup for the servers which we described on our guide on basic server setup and ensuring security. Paid web hosting control panels like cPanel usually have either no shell but FTP or SFTP access or limited shell access. Often we need to host account on vps or cloud server where it is desired to have a setup sftp without shell access for WordPress Like cPanel. We … [Read more...]
Cheap Cloud & Virtual Servers For Running Apache Big Data Tools
Wikipedia uses OVH. These days which were once known as "Low End Box" has been a cost effective but powerful platform to test, deploy things which can be done on servers. We have a list of Big Data tutorials and list of Apache Big Data tools. Here are some points for selecting correct servers for running Apache Big Data tools. As we clearly said before - there are some positive and negative points … [Read more...]
Install, Configure Brotli On Apache, WordPress, W3TC
Previously we talked about Brotli compression in context of Nginx web server. Here is an all in one guide to install, configure Brotli on Apache, WordPress, W3TC running on Ubuntu 16.04 on dedicated server, cloud server instance. In order to follow this guide, you need SSH access and HTTPS/SSL/TLS to be active on your server/website. You can perform the steps on production server with running … [Read more...]
How To Perform Security Audits On Ubuntu 16.04 (With Lynis)
Security audit in our case is am automatic technical assessment of our server and web applications in the context of security by performing security vulnerability scans, reviewing application and operating system access controls some softwares or scripts. At the ens, we will gather a software generated audit report. Here is how to perform security audits on Ubuntu 16.04 with Lynis and other tools … [Read more...]
Install Apache Spark on Ubuntu Single Cloud Server With Hadoop
We can clarify the so called Big Data related softwares as Batch-only framework which includes Apache Hadoop, Stream-only frameworks which includes Apache Storm, Apache Samza and Hybrid framework which includes Apache Spark and Apache Flink. Apache Hadoop can be considered a processing framework with MapReduce as its default processing engine. Apache Spark can hook into Hadoop to replace … [Read more...]
Day to Day Commands For Server : Cloud Server Administration
There is difference between the way we administer a cloud server and dedicated server. Here Are Useful, Regularly Updated Day to Day Commands For Server, This is Specially Written For Cloud Server Administration or VPS Instance. The difference between a cloud server and dedicated server from point of administration is mostly one higher level of access, backup strategies, no way to blow away … [Read more...]
Securing FTP Tutorial : Part 1
In case you are relatively new around server administration or security, we will suggest to read the IPTables series - IPTables Basics Tutorial Part 1, IPTables Basics Tutorial Part 2, IPTables Basics Tutorial Part 3. Otherwise it will be meaningless to secure only FTP. Securing FTP Tutorial is an Important Series of Guide to Secure Your Cloud Server or Virtual Server. This guide is not for … [Read more...]
Steps to Install NextCloud on Cloud Server (Nginx, Redis Cache)
NextCloud is like your own Dropbox. Possibly you know about OwnCloud. That OwnCloud's founder have quit to start up a new fork and a new company called NextCloud. OwnCloud had 2 types of softwares - free and paid. NextCloud is different than OwnCloud at some points, has no paid software but paid hosting. Here Are the Steps to Install NextCloud on Cloud Server With Nginx Server, Redis Cache, 2 FA, … [Read more...]