If you have data in a text file, you can easily upload them to one or more tables in a database.

In MySQL database (or MariaDB), using “load data infile” command, you can upload data from a text file to tables.

The load data infile command provides several flexible options to load various formats of data from text file to tables.
[continue reading…]

Even if you are a developer, or Linux sysadmin, sometimes you might still end-up dealing with Oracle database in your organization.

One of the essential Oracle DBA task is to manage the tablespace.

This tutorial covers everything that you need to know to effectively manage both your tablespaces and datafiles in an Oracle database.
[continue reading…]

If you are running Apache zookeeper in your infrastructure, you should set it up to run in a cluster mode. Zookeeper cluster is called as ensemble.

For a cluster to be always up and running, majority of the nodes in the cluster should be up. So, it is always recommended to run zookeeper cluster in odd number of servers. For example, cluster with 3 nodes, or cluster with 5 nodes, etc.

In this tutorial, we’ll setup zookeeper cluster with 3 node setup on the following servers: node1, node2, and node3.
[continue reading…]

Jenkins is an open source automation server, which will help you to automate the application deployment in your infrastructure.

From Jenkins, for deployment, you can connect to any kind of source code control system, and pull the source, build it, and deploy it automatically to one or more servers.

In this tutorial, we’ll explain how you can create a new Jenkins Job, and connect it to a Git repository to pull the source code for building.
[continue reading…]

In this tutorial, we would write an example C program that will create a file which will serve as producer of testing data.

In another words, we will create an application in C, and your task is to input the number of clusters, number of dots for each of those clusters, and then to generate random numbers that are in those clusters.

The output file generated by this program can then be used by other programs as sample data.

A while back, I tried to write a simple weather prediction program, but I had no real life data to apply my algorithm and try out my application. Sometimes, it is very hard to generate the data that are required to test your application. That was the motivation for me to write some simple program like this, which will give you some idea on writing your own program to generate test data.
[continue reading…]

What is virtualization?

In simple terms, virtualization is a simulated platform or environment on top of a host node, which is quite abstract for an user.

These simulated virtual environment can be an operating systems, or some development environment, etc.

This gives us the ability to efficiently use the hardware resources of the host node.
[continue reading…]

Q: On one of our server, the webserver is not setup to support SSLv2 or SSLv3. Both are disabled on the server side. It supports only TLSv1. How can I get curl to work from both command line, and from inside my PHP code?

A: In most case, curl will automatically pick the correct protocol and connect to it. But, you can also specify a specific protocol to use for curl command. In this example, you have to instruct CURL to use TLSv1, as explained in this tutorial.
[continue reading…]