(2) Broker / Warehouse Installation

Broker Installation

Add a broker node to the coordinator node. Multi-broker node registration is possible.

The deployer node must be installed on the server in advance.
Once the deployer node is installed, there is no setting by connecting to the server as all work can be done on the coordinator node.
The first registered node becomes the leader broker, and the additional registered node becomes the follower broker.

# Add broker node.                                 
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --add-node="192.168.0.84:5301"	\ 
		--node-type=broker --deployer="192.168.0.84:5201" --port-no="5656" 			\
		--home-path="/home/machbase/broker" --package-name=machbase
 
# Run broker node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --startup-node="192.168.0.84:5301"

Option Items	Description	Example
--add-node	Specifies the node name to be added as "IP: PORT". The PORT value is set to the CLUSTER_LINK_PORT_NO value.	192.168.0.84:5301
--node-type	Specifies the node type. There are four types: coordinator, deployer, broker, and warehouse.	broker
--deployer	Register the deployer node information of the server to be installed.	192.168.0.84:5201
--port-no	Specifies 'machbased' port. The Broker specifies a default value of 5656. This port is used when connecting to client and machsql.	5656
--home-path	Specifies the path to install. Specifies /home/machabse/broker in machbase account	/home/machabse/broker
--package-name	Sets the package name specified when package was added.	machbase

Index

Delete Broker

Remove the broker node from the Coordinator node.

# Delete broker node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --remove-node="192.168.0.84:5301"

Shut Down / Stop Broker

There is a way to shut down / kill the broker node on the Coordinator node.

# Terminate broker node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --shutdown-node="192.168.0.84:5301"
 
# Stop broker node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --kill-node="192.168.0.84:5301"

Alternatively, you can shut down / kill the process directly from the server where the broker is installed.

# Terminate broker node.
$MACHBASE_HOME/bin/machadmin -s
 
# Stop broker node.
$MACHBASE_HOME/bin/machadmin -k

Warehouse Installation

Install the active node and the standby node from the Coordinator node.

They will be installed through a pre-installed deployer.

Group 1 Installation

Install the first Warehouse Group1 node.

# Install group1 warehouse.                          
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --add-node="192.168.0.83:5401"	\
		--node-type=warehouse --deployer="192.168.0.83:5201" --port-no="5400" 		\
		--home-path="/home/machbase/warehouse_g1" --package-name=machbase 			\
		--replication="192.168.0.83:5402"  --group="group1" --no-replicate
 
# Run installed node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --startup-node="192.168.0.84:5401"

Option Items	Description	Example
--add-node	Specifies the node name to be added as "IP: PORT". The PORT value is set to the CLUSTER_LINK_PORT_NO value.	192.168.0.84:5401
--node-type	Specifies the node type. There are four types: coordinator, deployer, broker, and warehouse.	warehouse
--deployer	Registers the deployer node information of the server to be installed.	192.168.0.84:5201
--port-no	Specifies the working port of 'machbased'. Since the value was set to 5656 on the Broker, a different port must be specified if it is installed on the same server. The warehouse port number is set as 5400. This port is used when connecting to client and machsql.	5400
--home-path	Specifies the path to install. To distinguish the groups, set them in order of warehouse_g1, g2, g3.	/home/machbase/warehouse_g1
--package-name	Sets the package name specified when adding the package.	machbase
--replication	Specifies the node in charge of replication as "IP: PORT". The port value is set to the warehouse port number 5402.	192.168.0.84:5402
--group	Specifies the Group name.	group1
--no-replicate	Specifies whether to replicate data when adding a node if there is warehouse data in the group.
--set-group-state	Specifies the state of the group as normal and readonly. Normal is read, write / readonly is read only

Add Node to Group 1

Add another node to Warehouse Group1.

# Add warehouse node to group1.               
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --add-node="192.168.0.84:5401"	\
		--node-type=warehouse --deployer="192.168.0.84:5201" --port-no="5400" 		\
		--home-path="/home/machbase/warehouse_g1" --package-name=machbase 			\
		--replication="192.168.0.84:5402" --group="group1" --no-replicate
 
# Run installed node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --startup-node="192.168.0.84:5401"

Option Items	Description	Example
--add-node	Specifies the node name to be added as "IP: PORT". The PORT value is set to the CLUSTER_LINK_PORT_NO value.	192.168.0.84:5401
--node-type	Specifies the node type. There are four types: coordinator, deployer, broker, and warehouse.	warehouse
--deployer	Registers the deployer node information of the server to be installed.	192.168.0.84:5201
--port-no	Specifies the working port of 'machbased'. Since the value was set to 5656 on the Broker, a different port must be specified if it is installed on the same server. The warehouse port number is set as 5400. This port is used when connecting to client and machsql.	5400
--home-path	Specifies the path to install. To distinguish the groups, set them in order of warehouse_g1, g2, g3.	/home/machabse/warehouse_g1
--package-name	Sets the package name specified when adding the package.	machbase
--replication	Specify the node in charge of replication as "IP: PORT". The port value is set to the warehouse port number 5402.	192.168.0.84:5402
--group	Specifies the Group name.	group1
--no-replicate	Specifies whether to replicate data when adding a node if there is warehouse data in the group.
--set-group-state	Specifies the state of the group as normal and readonly. Normal is read, write / readonly is read only

Group 2 Installation

Install the second Warehouse Group2 node.

# Install group1 warehouse.                          
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --add-node="192.168.0.84:5411"	\
		--node-type=warehouse --deployer="192.168.0.84:5201" --port-no="5410" 		\
		--home-path="/home/machbase/warehouse_g2" --package-name=machbase 			\
		--replication="192.168.0.84:5412"  --group="group2" --no-replicate
 
# Run installed node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --startup-node="192.168.0.84:5411"

Option Items	Description	Example
--add-node	Specifies the node name to be added as "IP: PORT". The PORT value is set to the CLUSTER_LINK_PORT_NO value.	192.168.0.84:5411
--node-type	Specifies the node type. There are four types: coordinator, deployer, broker, and warehouse.	warehouse
--deployer	Registers the deployer node information of the server to be installed.	192.168.0.84:5201
--port-no	Specifies the working port of 'machbased'. Since the value was set to 5656 on the Broker, a different port must be specified if it is installed on the same server. The warehouse port number is set as 5410. This port is used when connecting to client and machsql.	5410
--home-path	Specifies the path to install. To distinguish the groups, set them in order of warehouse_g1, g2, g3.	/home/machbase/warehouse_g2
--package-name	Sets the package name specified when adding the package.	machbase
--replication	Specifies the node in charge of replication as "IP: PORT". The port value is set to the warehouse port number 5412.	192.168.0.84:5412
--group	Specifies the Group name.	group2
--no-replicate	Specifies whether to replicate data when adding a node if there is warehouse data in the group.
--set-group-state	Specifies the state of the group as normal and readonly. Normal is read, write / readonly is read only

Add Node to Group 2

Add another node to Warehouse Group2.

# Add warehouse node to group1.               
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --add-node="192.168.0.83:5411"	\
		--node-type=warehouse --deployer="192.168.0.83:5201" --port-no="5410" 		\
		--home-path="/home/machbase/warehouse_g2" --package-name=machbase 			\
		--replication="192.168.0.83:5412" --group="group2" --no-replicate
 
# Run installed node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --startup-node="192.168.0.83:5411"

Option Items	Description	Example
--add-node	Specifies the node name to be added as "IP: PORT". The PORT value is set to the CLUSTER_LINK_PORT_NO value.	192.168.0.83:5411
--node-type	Specifies the node type. There are four types: coordinator, deployer, broker, and warehouse.	warehouse
--deployer	Registers the deployer node information of the server to be installed.	192.168.0.83:5201
--port-no	Specifies the working port of 'machbased'. Since the value was set to 5656 on the Broker, a different port must be specified if it is installed on the same server. The warehouse port number is set as 5400. This port is used when connecting to client and machsql.	5410
--home-path	Specifies the path to install. To distinguish the groups, set them in order of warehouse_g1, g2, g3.	/home/machbase/warehouse_g2
--package-name	Sets the package name specified when adding the package.	machbase
--replication	Specifies the node in charge of replication as "IP: PORT". The port value is set to the warehouse port number 5412.	192.168.0.83:5412
--group	Specifies the Group name.	group2
--no-replicate	Specifies whether to replicate data when adding a node if there is warehouse data in the group.
--set-group-state	Specifies the state of the group as normal and readonly. Normal is read, write / readonly is read only

Delete Warehouse

Delete the warehouse node from the Coordinator node.

# Delete warehouse node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --remove-node="192.168.0.83:5401"

Shut Down / Stop Warehouse

There is a way to shut down / kill the warehouse node at the Coordinator node.

# Terminate warehouse node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --shutdown-node="192.168.0.83:5401"
 
# Stop warehouse node.
$MACHBASE_COORDINATOR_HOME/bin/machcoordinatoradmin --kill-node="192.168.0.83:5401"

Otherwise, the process can be shut down / killed directly from the server where the warehouse is installed.

# Terminate warehouse node.
$MACHBASE_HOME/bin/machadmin -s
 
# Stop warehouse node.
$MACHBASE_HOME/bin/machadmin -k

Manual (English)