Home Database Mysql Tutorial 使用client配置来控制DB2 pureScale的工作负载等特性

使用client配置来控制DB2 pureScale的工作负载等特性

Jun 07, 2016 pm 05:54 PM
client db2 control Configuration

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 集群成员负载信息列表

DB2 pureScale 集群采用了动态的工作负载均衡分发机制,而不是传统的固定轮转 (Round Robin) 的方式。传统的固定轮转的工作负载均衡分发机制如下图所示,假如集群中一共有四个成员节点,因此每个成员节点被分配了 25% 的来自客户端应用的请求。假如每个来自客户端应用的请求对数据库资源的需求是相同的或相似的,那么这种方式是有效的。但实际的生产环境中往往每个客户端过来的请求是不一样的,假设被分配到 Member 0 上的客户端应用请求中有一个是某部门领导在查看销售报表时发起的,该操作中查询非常复杂,将访问大量的数据和消耗大量的服务器资源。如图二所示,这种固定轮转的分发机制将导致 Member 0 上压力异常的大,尽管同一时刻集群中其他的节点上的系统资源仍然很富裕。

图 2. 普通的工作负载均衡分发机制
普通的工作负载均衡分发机制

Statement of this Website
The content of this article is voluntarily contributed by netizens, and the copyright belongs to the original author. This site does not assume corresponding legal responsibility. If you find any content suspected of plagiarism or infringement, please contact admin@php.cn

Hot AI Tools

Undresser.AI Undress

Undresser.AI Undress

AI-powered app for creating realistic nude photos

AI Clothes Remover

AI Clothes Remover

Online AI tool for removing clothes from photos.

Undress AI Tool

Undress AI Tool

Undress images for free

Clothoff.io

Clothoff.io

AI clothes remover

AI Hentai Generator

AI Hentai Generator

Generate AI Hentai for free.

Hot Article

R.E.P.O. Energy Crystals Explained and What They Do (Yellow Crystal)
2 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Repo: How To Revive Teammates
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌
Hello Kitty Island Adventure: How To Get Giant Seeds
4 weeks ago By 尊渡假赌尊渡假赌尊渡假赌

Hot Tools

Notepad++7.3.1

Notepad++7.3.1

Easy-to-use and free code editor

SublimeText3 Chinese version

SublimeText3 Chinese version

Chinese version, very easy to use

Zend Studio 13.0.1

Zend Studio 13.0.1

Powerful PHP integrated development environment

Dreamweaver CS6

Dreamweaver CS6

Visual web development tools

SublimeText3 Mac version

SublimeText3 Mac version

God-level code editing software (SublimeText3)

The working principle and configuration method of GDM in Linux system 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

The perfect combination of PyCharm and PyTorch: detailed installation and configuration steps 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

Understand Linux Bashrc: functions, configuration and usage 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

MyBatis Generator configuration parameter interpretation and best practices 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.

How to configure workgroup in win11 system 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

Control Center not working in iPhone: Fix Control Center not working in iPhone: Fix Apr 17, 2024 am 08:16 AM

Imagine an iPhone without a functioning Control Center. You can't, right? If the buttons on the Control Center don't work properly, you won't be able to use your iPhone properly. The main idea of ​​Control Center is to easily access certain features directly from anywhere on your phone. In this case, these solutions will help to resolve the issue on your phone. Fix 1 – Use a Cloth to Clean Your Phone Sometimes the upper part of the display gets dirty from regular use. This may cause the Control Center to not function properly. Step 1 – Take a soft, clean microfiber cloth and clean the top half of your iPhone screen. You can also use any screen cleaning solution. Step 2 – Make sure to remove any dust, oil, or anything else from your phone’s display. After clearing phone screen

Flask installation and configuration tutorial: a tool to easily build Python web applications 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 configure and install FTPS in Linux system 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

See all articles