Shulou(Shulou.com)06/01 Report--

I. description

A 3-node PXC cluster is used in the production environment, and the external access port is 3306 by default. It is usually required to modify the port. We assume that port 3311 is the external access port.

II. Operation process

Modify PXC cluster application access port 3306 to 3311, first operate on the first node, then the second node, and then the last three nodes, in turn, without affecting the online business. Vi my.cnfport=3311 shuts down the database shutdown; starts the database mysqld_safe-defaults-file=/etc/my.cnf & check the status to verify that the modification is successful mysql > show status like 'wsrep_incoming_addresses' +-- +-- + | Variable_name | Value +- -+-- + | wsrep_incoming_addresses | 196.55.7.35 3311196.55.7.33 Soviet 3311196.55.7.34 -+-- + 1 row in set (0.00 sec) mysql > show variables like 'port' +-+-+ | Variable_name | Value | +-+-+ | port | 3311 | +-+-+ 1 row in set (0.01sec)

Welcome to subscribe "Shulou Technology Information " to get latest news, interesting things and hot topics in the IT industry, and controls the hottest and latest Internet news, technology news and IT industry trends.