Thalasar Ventures

Based on past surveys, we know that the database Server When the selection has the following five principles: high-performance, high reliability, high scalability, security and manageability, etc.. In fact, a different database program on the server hardware requirements are different. Starting from this issue, we will focus on the most popular of several databases (Oracle/DB2/MySQL, etc.), analyze their specific needs and the server hardware market solutions.

For any enterprise, departmental-level database is already important and indispensable IT One-group, while most of these databases are produced by the Oracle Database software . Therefore, we first of all the latest on the Oracle Database 11gR2 on the server needs to do a simple analysis.

1, Oracle 11g database server component on the requirements of

Oracle 11gR2 support for unstructured data, the binary XML storage efficiency and significantly improved the speed of XML index increased by 15 times than before. On the other hand, Oracle added the results of server and client caching technology makes PL / SQL performance tripled, JAVA performance increased by 11 times. But all this means that the original equipment has been insufficient to carry the new version of the database caused performance. Experienced Oracle database administrators are aware that when dealing with Oracle products, the entire upgrade process is not only a need to upgrade to the latest version of the software and hardware upgrades are needed at the same time.

Since Oracle 11gR2 with RAC (Real Application Clusters) technology, the database can be distributed to a number of servers deployed in order to avoid make up a single server efficiency and ensure redundancy. But on the one hand the database synchronization and management problems, on the other hand also the quality of their professional DBA raised the additional demand. In contrast, administrators are more willing to use virtualization technology to deploy Oracle database, which can be better disaster recovery, fast backup, portability, performance and business continuity. This also brings the demand on the database server: virtual high-performance, Memory Large capacity and good reliability.

However, under normal circumstances, most IT departments, or follow the piece of “iron law”, that is, system design life cycle (SDLC), the existing technology or to maintain, unless the maintenance costs exceeded the cost of replacement products. We are experts in the post-face interviews with Oracle database, also found that upgrading the server when they are The first consideration is cost, performance and stability will only be considered after .

Question of cost, it is necessary that each procurement costs and operating costs, which are more and more seriously by corporate IT departments. Procurement cost point of view, is naturally more expensive RISC platforms, x86 platform occupied the unique low-cost high-performance advantages. On the other hand, the operating cost perspective, RISC environment because of their closed-source and proprietary platforms, the need for labor costs, operation and maintenance, software solutions require additional spending, while x86 platform as an open platform environment and general features , at lower cost.

This regard, is not surprising that many key business is moving from RISC + UNIX platform migration to the X86 + Linux platform. But the x86 platform has been the impression in performance RISC platforms are not as powerful, but also the stability of people’s criticism. What exactly is this?

Find More Oracle Articles