使用client配置来控制DB2 pureScale的工作负载等特性
DB2 pureScale 增加了很多新功能帮助用户更好地管理数据。DB2 pureScale Feature 可以使用多个成员为同一数据库服务。工作负载均衡（workload balancing）是其重要的特性之一，并且需要特定 DB2 Client 版本的支持。本文主要介绍如何使用 client 配置来控制 D
DB2 pureScale 是 IBM 专门针对 OLTP 工作负载类型的推出的集群技术，集成了持续可用，高扩展性以及对应用透明三大特性，可以为用户提供不间断的服务以及无风险的横向扩展能力以满足业务增长需求。因此 DB2 pureScale 也成为面向 OLTP 业务类型的最佳集群解决方案。
图 1. DB2 pureScale 系统概览
在一个 DB2 pureScale 集群中，采用共享数据的架构，同一时刻集群中的多个数据库成员节点可以同时对外提供数据库服务。而 DB2 pureScale 的工作负载均衡技术，正是实现 DB2 pureScale 集群的持续可用性，高扩展性和应用透明性的保障。DB2 pureScale 集群只有充分利用每个成员的处理能力，将来自应用程序端的数据库服务请求均衡的分布在集群中的各个成员节点上，才能使应用获得最大的工作吞吐量和最小的响应时间。
通常情况下，连接到 DB2 pureScale 数据库集群的客户端应用无需知道自己实际连接的是哪一个成员，以及某一特定的工作负载被分发到哪个成员节点上。所有的这一切对应用程序都是透明的，而且一旦某一成员节点发生故障，该成员节点上的连接和工作负载可以很快的被转移到其他正常的成员节点上继续执行。如果 DB2 pureScale 集群中有新的成员节点恢复或加入，新加入的成员节点可以立刻分担之前运行在其它成员上节点上的工作负载。
DB2 pureScale 集群成员负载信息列表
DB2 pureScale 集群采用了动态的工作负载均衡分发机制，而不是传统的固定轮转 (Round Robin) 的方式。传统的固定轮转的工作负载均衡分发机制如下图所示，假如集群中一共有四个成员节点，因此每个成员节点被分配了 25% 的来自客户端应用的请求。假如每个来自客户端应用的请求对数据库资源的需求是相同的或相似的，那么这种方式是有效的。但实际的生产环境中往往每个客户端过来的请求是不一样的，假设被分配到 Member 0 上的客户端应用请求中有一个是某部门领导在查看销售报表时发起的，该操作中查询非常复杂，将访问大量的数据和消耗大量的服务器资源。如图二所示，这种固定轮转的分发机制将导致 Member 0 上压力异常的大，尽管同一时刻集群中其他的节点上的系统资源仍然很富裕。
图 2. 普通的工作负载均衡分发机制
Hot AI Tools
Undresser.AI Undress
AI-powered app for creating realistic nude photos
AI Clothes Remover
Online AI tool for removing clothes from photos.
Undress AI Tool
Undress images for free
Clothoff.io
AI clothes remover
Video Face Swap
Swap faces in any video effortlessly with our completely free AI face swap tool!
Hot Article
Hot Tools
Notepad++7.3.1
Easy-to-use and free code editor
SublimeText3 Chinese version
Chinese version, very easy to use
Zend Studio 13.0.1
Powerful PHP integrated development environment
Dreamweaver CS6
Visual web development tools
SublimeText3 Mac version
God-level code editing software (SublimeText3)
Hot Topics
1387
52
The perfect combination of PyCharm and PyTorch: detailed installation and configuration steps
Feb 21, 2024 pm 12:00 PM
PyCharm is a powerful integrated development environment (IDE), and PyTorch is a popular open source framework in the field of deep learning. In the field of machine learning and deep learning, using PyCharm and PyTorch for development can greatly improve development efficiency and code quality. This article will introduce in detail how to install and configure PyTorch in PyCharm, and attach specific code examples to help readers better utilize the powerful functions of these two. Step 1: Install PyCharm and Python
The working principle and configuration method of GDM in Linux system
Mar 01, 2024 pm 06:36 PM
Title: The working principle and configuration method of GDM in Linux systems In Linux operating systems, GDM (GNOMEDisplayManager) is a common display manager used to control graphical user interface (GUI) login and user session management. This article will introduce the working principle and configuration method of GDM, as well as provide specific code examples. 1. Working principle of GDM GDM is the display manager in the GNOME desktop environment. It is responsible for starting the X server and providing the login interface. The user enters
Understand Linux Bashrc: functions, configuration and usage
Mar 20, 2024 pm 03:30 PM
Understanding Linux Bashrc: Function, Configuration and Usage In Linux systems, Bashrc (BourneAgainShellruncommands) is a very important configuration file, which contains various commands and settings that are automatically run when the system starts. The Bashrc file is usually located in the user's home directory and is a hidden file. Its function is to customize the Bashshell environment for the user. 1. Bashrc function setting environment
How to configure workgroup in win11 system
Feb 22, 2024 pm 09:50 PM
How to configure a workgroup in Win11 A workgroup is a way to connect multiple computers in a local area network, which allows files, printers, and other resources to be shared between computers. In Win11 system, configuring a workgroup is very simple, just follow the steps below. Step 1: Open the "Settings" application. First, click the "Start" button of the Win11 system, and then select the "Settings" application in the pop-up menu. You can also use the shortcut "Win+I" to open "Settings". Step 2: Select "System" In the Settings app, you will see multiple options. Please click the "System" option to enter the system settings page. Step 3: Select "About" In the "System" settings page, you will see multiple sub-options. Please click
How to configure and install FTPS in Linux system
Mar 20, 2024 pm 02:03 PM
Title: How to configure and install FTPS in Linux system, specific code examples are required. In Linux system, FTPS is a secure file transfer protocol. Compared with FTP, FTPS encrypts the transmitted data through TLS/SSL protocol, which improves Security of data transmission. In this article, we will introduce how to configure and install FTPS in a Linux system and provide specific code examples. Step 1: Install vsftpd Open the terminal and enter the following command to install vsftpd: sudo
MyBatis Generator configuration parameter interpretation and best practices
Feb 23, 2024 am 09:51 AM
MyBatisGenerator is a code generation tool officially provided by MyBatis, which can help developers quickly generate JavaBeans, Mapper interfaces and XML mapping files that conform to the database table structure. In the process of using MyBatisGenerator for code generation, the setting of configuration parameters is crucial. This article will start from the perspective of configuration parameters and deeply explore the functions of MyBatisGenerator.
Flask installation and configuration tutorial: a tool to easily build Python web applications
Feb 20, 2024 pm 11:12 PM
Flask installation and configuration tutorial: A tool to easily build Python Web applications, specific code examples are required. Introduction: With the increasing popularity of Python, Web development has become one of the necessary skills for Python programmers. To carry out web development in Python, we need to choose a suitable web framework. Among the many Python Web frameworks, Flask is a simple, easy-to-use and flexible framework that is favored by developers. This article will introduce the installation of Flask framework,
How to install and configure DRBD on CentOS7 system? Tutorial on implementing high availability and data redundancy!
Feb 22, 2024 pm 02:13 PM
DRBD (DistributedReplicatedBlockDevice) is an open source solution for achieving data redundancy and high availability. Here is the tutorial to install and configure DRBD on CentOS7 system: Install DRBD: Open a terminal and log in to the CentOS7 system as administrator. Run the following command to install the DRBD package: sudoyuminstalldrbd Configure DRBD: Edit the DRBD configuration file (usually located in the /etc/drbd.d directory) to configure the settings for DRBD resources. For example, you can define the IP addresses, ports, and devices of the primary node and backup node. Make sure there is a network connection between the primary node and the backup node.
