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)