(三)presto集成Mysql

叁歲伎倆 2022-12-22 04:38 183阅读 0赞

# 一、集成之前 #

## 1、启动mysql ##

service mysql start

## 2、登录mysql并查看相关信息 ##

[root@master bin]# mysql -u root -p
    Enter password: 
    Welcome to the MySQL monitor.  Commands end with ; or \g.
    Your MySQL connection id is 79
    Server version: 5.6.47 MySQL Community Server (GPL)
    
    Copyright (c) 2000, 2020, Oracle and/or its affiliates. All rights reserved.
    
    Oracle is a registered trademark of Oracle Corporation and/or its
    affiliates. Other names may be trademarks of their respective
    owners.
    
    Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.
    
    mysql> show databases;
    +--------------------+
    | Database           |
    +--------------------+
    | information_schema |
    | hive               |
    | ke                 |
    | mysql              |
    | performance_schema |
    | test               |
    +--------------------+
    6 rows in set (0.03 sec)
    mysql>

# 二、集成Mysql #

## 1、创建mysql.properties ##

在presto所有节点/opt/softWare/presto/ln\_presto/etc/catalog下创建mysql.properties文件

connector.name=mysql
    connection-url=jdbc:mysql://192.168.230.21:3306?useUnicode=true&characterEncoding=UTF-8&useSSL=false&autoReconnect=true&failOverReadOnly=false
    connection-user=root
    connection-password=123456

## 2、重启presto ##

所有节点重启presto

./launcher restart

## 3、presto连接mysql ##

**test为mysql中的一个库；**

![watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5al9raW5n_size_16_color_FFFFFF_t_70][]

[watermark_type_ZmFuZ3poZW5naGVpdGk_shadow_10_text_aHR0cHM6Ly9ibG9nLmNzZG4ubmV0L2h5al9raW5n_size_16_color_FFFFFF_t_70]: /images/20221120/3e58b2926c9649e2a4b25c711c195701.png