"Issue 1th" Install Linux Server (DB host and ETL host)

1. Introduction to Linux

Linux such an operating system should not be unfamiliar to everyone, because it is the current background server is one of the mainstream operating system. Linux originates from POSIX and UNIX-based multi-user, multitasking, and multi-CPU operating systems.

There is more to the description of Linux than I can say. The following is from the "Baidu Encyclopedia" entry: Linux is a free-to-use and free-spread UNIX-like operating system, is a POSIX and Unix-based multiuser, multi-tasking, multi-threading and multi-CPU operating system. It can run major UNIX tools software, applications, and network protocols. It supports 32-bit and 64-bit hardware. Linux inherits the design idea of Unix as the core of network, and is a stable multi-user network operating system.

2. Choose Linux

In order to build our personal BI system, choosing the right server operating system is an essential part of this. Not only using systems developed with the BI class, but also the development of other business classes or analysis class systems. Here, we also choose to use Linux as our operating system.

There are many versions of Linux, and I chose to develop my personal BI system based on this stable version:Red Hat Enterprise Linux Server release 6.4 (Santiago)

3. Bi System host Information

To do this, after selecting the operating system, come down to install the server. I chose a VMware virtual machine to install the Linux server. Here, the installation of VMware virtual machines has a lot of relevant articles on the network, I will not repeat. Interested partners can refer to the installation tutorials on the network.

Note: When installing a VMware virtual machine, you should select "Bridge" to connect to the network, and the information about the "bridging" of VMware virtual machines can also refer to the online articles.

For convenience, we have installed only two Linux virtual machines, respectively, for the database server and ETL server. Their information is as follows:

DB Host:

Name	More information
Machine name	Db_srv
Machine IP	192.168.0.110
Highest user name	Root
Maximum user password	Oracle
General User Name	Oracle
General user Password	Oracle

ETL Host:

Name	More information
Machine name	Etl_srv1
Machine IP	192.168.0.121
Highest user name	Root
Maximum user password	Etl
General User Name	Etl
General user Password	Etl

Perhaps the attentive reader has found that when we set up ETL host information, we used ETL_SRV1 instead of etl_srv. In fact, this is done in order to facilitate the expansion of more ETL server later. In BI system, ETL server generally not only one, and this time we developed a BI system, only use one ETL server, is for development convenience. Or, in the process of development, if you encounter the need to extend the ETL server, we can name the extended ETL Server ETL_SRV2, Etl_srv3 and so on.

As for the IP address and user settings, you can set yourself according to your own personal situation. For example, when I set up IP, I use 192.168.0.XXX because the current network is a public network, and the IP address set to 192.168.1.XXX may conflict with others. Therefore, I choose to use an IP address similar to 192.168.0.XXX. Of course, my personal host's IP address is also in 192.168.1.XXX format. But the mask I use on my linux server is 255.255.0.0, so that the two-segment hosts can ping through using VMware bridging.

"Issue 1th" Install Linux Server (DB host and ETL host)