How can I use the application delivery technology to optimize the Oracle database?

In recent years, Oracle database systems have become increasingly favored by ctos. With their excellent data delivery capabilities and the operational capabilities of CEO Larry lison, the powerful and complex Oracle database has been favored by Fortune 500 companies. It is a group of software products centered on distributed databases provided by Oracle. It is currently the most popular CLIENT/SERVER) or one of the databases in the B/S architecture. For example, Silver Stream is a database-based middleware.

So, even though the Oracle database is already very powerful, is there still room for optimization to improve application performance? The answer is yes. Feng Xiaojie, R & D Director of the emerging application delivery company Taiyi Xingchen in China, said that at the database level, by deploying application delivery products between application servers and databases, the efficiency and reliability of the entire business can be further improved.

Feng Xiaojie pointed out that in an application environment, all servers use and manage the same database to distribute the workload of each server. The hardware requires at least two servers, A shared storage device and two types of software are required. One is cluster software and the other is RAC components in the Oracle database. In addition, the operating systems on all servers should be the same type of OS. When a client sends a request to a listener of a service, the server sends the request to the RAC component of the Local Machine for processing, it may also be sent to the RAC component of another server for processing. After the request is processed, RAC accesses the backend shared storage device through the cluster software.

Therefore, at the database level, by deploying application delivery products between the application server and the database, the efficiency and reliability of the entire business can be improved. Of course, this requires application delivery products to provide intelligent traffic management and high reliability for oracle-based applications. For example, applications have formed a T-Force application delivery platform and can use advanced health check algorithms, application delivery can replace the application server to check the status of the database server, uninstall the server pressure, and direct traffic to other available resources when the resource is unavailable or when the load is large; through session tracking, maintain the session status between the client and the server, thus improving the application access speed.

Deployment instance of T-Force T1

(1) create a health check

This step mainly creates a health check for the oracle server. You can create a default health check. T1 supports layer-3 and layer-7 Health Check (only ICMP health check is supported for node nodes, for oracle http server Applications, you can also configure http, https, LDAP, and other types of health checks ).

(2) create a pool

In this step, create a resource list for Server Load balancer. Here, multiple oracle resource groups (a combination of server IP addresses and service ports) are created ).

(3) create a tcp profile

This step is used to create the profile of the tcp layer. For database services, it is mainly the Established_time parameter, that is, the persistent connection.

(4) create a virtual server

This step is used to create a virtual service corresponding to oracle. The function is to provide Server Load balancer for service instances of the same application to implement unified external services, distribute requests internally to multiple oracle application instances.

(5) Redundant Structure Configuration Synchronization

For redundant devices, synchronize the configuration of the master device (the configuration created in step 1-4) to the redundant device.