Developers zone > CUBRID Tools Wiki > CUBRID Manager > CUBRID Manager Manual > CUBRID Manager Reference > CUBRID Manager Advanced Usage

CUBRID Manager Advanced Usage

12.1. Host Group Management

Host groups can make hosts display clearly when where are lots of hosts needed to manage.

Hide or Show Groups

Users can choose hide or show the host group by menu as follows:

Item menu : show host only and hide the group nodes.
Group menu : show the group nodes.

Open Groups Settings Dialog

Use Group Settings… above to open the group management dialog as follows:

Buttons Top UP Down Bottom are responsible to adjust the display order of group.

And buttons Add… Edit… will open a new dialog to add or edit a group.

Add, Edit Group Nodes of Hosts

Button Add will open a new group dialog to let users input the new group's name and children hosts.

Left area of the dialog is a list of current hosts which is not in current group and right area is a list of current group’s children hosts.

Button > will move the selected in the left to right and >> will move all of the left to right;

Button < will move the selected in right to left and << will all of the right to left.

Delete Group

Select a group to be deleted and push the button Delete.

Note: the Default Group can not be deleted and edited, it store the hosts which is not in other groups.

Drag Group

Users can drag several host nodes to another group node or change the display order of host nodes of current group node.

Users can also change the display order of host nodes when group nodes are hidden.

12.2. Configuring Background Operations in Multiple-Host Environment

If you manage databases in several hosts by using Add Host, databases can be configured for background operations. For example, if you want to execute a query to a database in host B while doing backup for a database in host A, the database backup operation, which generally takes a long time, can be configured to be executed as a background operation. The database operations that can be run in the background are as follows:

Database related : Create Database, Unload/Load Database, Backup/Restore Database, Rename Database, Copy Database, Optimize Database, Compact Database, Check Database
Table related : Import/Export, Delete All Records, Update data by changing constraints from NULL to NOT NULL
Volume : Add Volume

12.3. OID Navigator

It is used to search data by OIDs.

You can run the OID Navigator by right-clicking a database or inside the Result pane of the Query editor and then selecting OID Navigator. Note that this function is activated only while the database server is running; this is deactivated while the server is not running.

12.4. Easy HA

Notice

Linux and CUBRID version 2008 R2.2 or later must be installed on the equipment to be used as the master and the slave nodes. CUBRID HA does not support Windows operating system.

Specifications of Configuring the CUBRID HA Equipment

	CUBRID Version	OS
For master nodes	CUBRID 2008 R2.2 or later	Linux
For slave nodes	CUBRID 2008 R2.2 or later	Linux

Preparation

Install CUBRID server on master and slave server,Then create same database both server.

Setting HA parameters use Easy HA wizard

Login both hosts.
Select one host,then select "Easy HA wizard..." on the context menu.
Input host parameters on host parameters page.

Select the other host.

Input the host computer-name. (The host name is important, please check it carefully).

Select same databases both hosts which will be used for HA.

4. Setting cubrid.conf parameters.

It will add necessary parameters by default. You also can modify it.

5. Setting cubrid_ha.conf parameters.

It will add necessary parameters by default. You also can modify it.

6. Setting parameters confirm.

This page display all the parameters which are will be add/modify/delete.

Configure hosts information

Edit /etc/hosts file as prompt message.

Add host info to /etc/hosts files both servers. The content is “host address” “host name” (e.g. 10.34.64.149 NC-PL-DEV001). (If host address is “localhost” or “127.0.0.1”, please replace it by real address).