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

This article mainly introduces "what is the visual interface of ClickHouse and the method of cluster status monitoring". In the daily operation, I believe that many people have doubts about the visual interface of ClickHouse and the method of cluster status monitoring. The editor consulted all kinds of materials and sorted out simple and easy-to-use operation methods. I hope it will be helpful for you to answer the doubts of "what is the visual interface of ClickHouse and the method of cluster status monitoring?" Next, please follow the editor to study!

Introduction

Tabix supports direct connection to ClickHouse through a browser. You can access ClickHouse without installing other software. It has the following characteristics:

Highlight the syntax of the editor. Change the command to complete. Query the graphic analysis tool that the command executes. Match the option of a special case.

In addition, you can also use DBeaver to connect to ClickHouse, and this article focuses on how to use these two tools.

Method 1: do not install, directly use the browser to access

The address is https://github.com/tabixio/tabix. Open the link below in the browser

Http://ui.tabix.io/

After entering the link, the interface is as follows:

Here, the default user name is default, the password is not required, and the login url is the address of the ClickHouse Server to be accessed, and the default port number is 8123. After logging in, the interface is as follows:

Execute the query statement:

Click the DRAW button for visual display:

Click the Metrics&Processes at the top right to view the query process and cluster status:

Mode 2: embedded mode

Modify the configuration file: / etc/clickhouse-server/config.xml:

This section of the configuration in the original configuration file has been commented out. Just release the comments:

]] >

Then restart server, browser access: http://ckserverhost:8123, the address is the address of ClickHouse Server.

After logging in, it is similar to the previous operation.

The official website provides a variety of ways to install tabix. If you are interested, please refer to the official website https://tabix.io/doc/Install/.

Here's an IDE tool that connects to ClickHouse.

Method 3: use DBeaver

In this article, the basic use of DBeaver is introduced in the article on the development of auxiliary artifacts-- DBeaver. If you are interested, you can take a look back. It's easy to connect to ClickHouse using DBeaver, but pay attention to the driver of ClickHouse-jdbc, and it's best not to use the driver that you download by default. For download of the driver, see the following address:

Https://jar-download.com/?search_box=clickhouse-jdbc

Open DBeaver, create a new connection, and select ClickHouse.

Click to edit driver settings to add driver

Test connection

After the connection is successful, the interface is as follows, and you can query and test.

At this point, the study on "what is the visual interface of ClickHouse and the method of cluster status monitoring" is over. I hope to be able to solve your doubts. The collocation of theory and practice can better help you learn, go and try it! If you want to continue to learn more related knowledge, please continue to follow the website, the editor will continue to work hard to bring you more practical articles!

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.