MySQL的集群的安装与配置(6台机器)
具体安装与配置：1）准备工作：6台机器，IP地址分别为192.168.0.（231-236）MGM节点：192.168.0.231(232) SQL 节点：192.168.0.
具体安装与配置：
1）
准备工作：
6台机器，，IP地址分别为
192.168.0.（231-236）
MGM节点：192.168.0.231(232)
SQL 节点：192.168.0.233-234
NDBD 节点：192.168.0.235-236
）
4）配置NDBD节点：
[root@localhost mysql]# cat /etc/my.cnf
[mysqld]
ndbcluster
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
这样写是可以连接成功。不过我今天来的时候发现全部DOWN掉了。
ndb-connectstring=192.168.0.231，192.168.0.232
[mysql_cluster]
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231，192.168.0.232
[root@localhost mysql]#
5）配置SQL 节点：
[root@localhost mysql]# cat /etc/my.cnf
[mysqld]
basedir=/usr/local/mysql/
datadir=/usr/local/mysql/data/
port=3306
user=nobody
socket=/tmp/mysql.sock
ndbcluster
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231，192.168.0.232
[ndbd]
connect-string=192.168.0.235
[ndbd]
connect-string=192.168.0.236
[ndbd_mgm]
connect-string=192.168.0.231
[ndbd_mgm]
connect-string=192.168.0.232
[ndbd_mgmd]
config-file=/etc/config.ini
[mysql_cluster]
#ndb-connectstring=192.168.0.231
#ndb-connectstring=192.168.0.232
ndb-connectstring=192.168.0.231，192.168.0.232
[root@localhost mysql]#
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
Node completely evacuates from Proxmox VE and rejoins the cluster
Feb 21, 2024 pm 12:40 PM
Scenario description for nodes to completely evacuate from ProxmoxVE and rejoin the cluster. When a node in the ProxmoxVE cluster is damaged and cannot be repaired quickly, the faulty node needs to be kicked out of the cluster cleanly and the residual information must be cleaned up. Otherwise, new nodes using the IP address used by the faulty node will not be able to join the cluster normally; similarly, after the faulty node that has separated from the cluster is repaired, although it has nothing to do with the cluster, it will not be able to access the web management of this single node. In the background, information about other nodes in the original ProxmoxVE cluster will appear, which is very annoying. Evict nodes from the cluster. If ProxmoxVE is a Ceph hyper-converged cluster, you need to log in to any node in the cluster (except the node you want to delete) on the host system Debian, and run the command
How to use Docker to manage and expand multi-node clusters
Nov 07, 2023 am 10:06 AM
In today's cloud computing era, containerization technology has become one of the most popular technologies in the open source world. The emergence of Docker has made cloud computing more convenient and efficient, and has become an indispensable tool for developers and operation and maintenance personnel. The application of multi-node cluster technology is widely used based on Docker. Through multi-node cluster deployment, we can utilize resources more efficiently, improve reliability and scalability, and also be more flexible in deployment and management. Next, we will introduce how to use Docker to
Optimization method of database in PHP high concurrency environment
Aug 11, 2023 pm 03:55 PM
PHP database optimization method in high concurrency environment With the rapid development of the Internet, more and more websites and applications need to face high concurrency challenges. In this case, database performance optimization becomes particularly important, especially for systems that use PHP as the back-end development language. This article will introduce some database optimization methods in PHP high concurrency environment and give corresponding code examples. Using connection pooling In a high-concurrency environment, frequent creation and destruction of database connections may cause performance bottlenecks. Therefore, using connection pooling can
What are the common clusters in php?
Aug 31, 2023 pm 05:45 PM
Common clusters in PHP include LAMP cluster, Nginx cluster, Memcached cluster, Redis cluster and Hadoop cluster. Detailed introduction: 1. LAMP cluster. LAMP refers to a combination of Linux, Apache, MySQL and PHP. It is a common PHP development environment. In a LAMP cluster, multiple servers run the same application and are balanced through a load balancer. Requests are distributed to different servers; 2. Nginx cluster, Nginx is a high-performance web server and so on.
Server cluster implementation method in Workerman documentation
Nov 08, 2023 pm 08:09 PM
Workerman is a high-performance PHPSocket framework that allows PHP to handle asynchronous network communication more efficiently. In Workerman's documentation, there are detailed instructions and code examples on how to implement a server cluster. In order to implement a server cluster, we first need to clarify the concept of a server cluster. A server cluster connects multiple servers to a network to improve system performance, reliability and scalability by sharing loads and resources. In Workerman, you can use the following two methods
How to use MongoDB to implement data clustering and load balancing functions
Sep 19, 2023 pm 01:22 PM
How to use MongoDB to implement data clustering and load balancing functions Introduction: In today's big data era, the rapid growth of data volume has put forward higher requirements for database performance. In order to meet these requirements, data clustering and load balancing have become indispensable technical means. As a mature NoSQL database, MongoDB provides rich functions and tools to support data clustering and load balancing. This article will introduce how to use MongoDB to implement data clustering and load balancing functions, and provide specific code
How to implement distributed containers and clusters in PHP microservices
Sep 24, 2023 pm 02:28 PM
How to implement distributed containers and clusters in PHP microservices In the development of today's Internet applications and systems, microservice architecture has become a popular design pattern. In the microservice architecture, distributed containers and clusters are indispensable components. This article will introduce how to implement distributed containers and clusters in PHP microservices and provide specific code examples. 1. The concept and implementation of distributed containers Distributed containers refer to a way of deploying various components of an application on different servers and working together through network communication. exist
What Linux server cluster system? What components are included?
Feb 22, 2024 pm 07:55 PM
Linux, the full name of GNU/Linux, is a Unix-like operating system that can be used and spread freely. It is a multi-user, multi-task, multi-thread, and multi-CPU operating system based on POSIX. So what is a Linux server cluster system? What are its main components? The following is an introduction to the specific content. The Linux server cluster system is a distributed computing environment based on the Linux operating system. It is composed of multiple independent server nodes. These nodes are connected to each other through high-speed networks to collaboratively complete various computing tasks. The cluster system has high reliability, high performance and scalability, and can provide users with stable and powerful service support. Through the cluster system, servers can be effectively divided into
