yugabyte 做为hasura graphql-engine的pg数据引擎
阅读原文时间:2023年07月10日阅读:1

今天看了下yugabyte 的更新 ,ysql 基本可以生产可用,刚好测试了下与hasura graphql-engine的集成,发现很不错,可以直接运行

  • docker-compose

version: '2'

services:

graphql-engine:

image: hasura/graphql-engine:v1.0.0-beta.6

ports:

- "8080:8080"

environment:

  HASURA\_GRAPHQL\_DATABASE\_URL: postgres://postgres@yb-tserver2:5433/postgres

  HASURA\_GRAPHQL\_ENABLE\_CONSOLE: "true" # set to "false" to disable console

  HASURA\_GRAPHQL\_ENABLED\_LOG\_TYPES: startup, http-log, webhook-log, websocket-log, query-log

yb-master:

  image: yugabytedb/yugabyte:latest

  container\_name: yb-master-n1

  command: \[ "/home/yugabyte/bin/yb-master", 

            "--fs\_data\_dirs=/mnt/disk0,/mnt/disk1", 

            "--master\_addresses=yb-master-n1:7100", 

            "--replication\_factor=1"\]

  ports:

  - "7000:7000"

  environment:

    SERVICE\_7000\_NAME: yb-master

yb-tserver:

  image: yugabytedb/yugabyte:latest

  container\_name: yb-tserver-n1

  command: \[ "/home/yugabyte/bin/yb-tserver", 

            "--fs\_data\_dirs=/mnt/disk0,/mnt/disk1",

            "--start\_pgsql\_proxy", 

            "--tserver\_master\_addrs=yb-master-n1:7100"\]

  ports:

  - "9042:9042"

  - "6379:6379"

  - "5433:5433"

  - "9000:9000"

  environment:

    SERVICE\_5433\_NAME: ysql

    SERVICE\_9042\_NAME: ycql

    SERVICE\_6379\_NAME: yedis

    SERVICE\_9000\_NAME: yb-tserver

  depends\_on:

  - yb-master

yb-tserver2:

  image: yugabytedb/yugabyte:latest

  container\_name: yb-tserver-n2

  command: \[ "/home/yugabyte/bin/yb-tserver", 

            "--fs\_data\_dirs=/mnt/disk0,/mnt/disk1",

            "--start\_pgsql\_proxy", 

            "--tserver\_master\_addrs=yb-master-n1:7100"\]

  ports:

  - "9043:9042"

  - "6380:6379"

  - "5434:5433"

  - "9001:9000"

  environment:

    SERVICE\_5433\_NAME: ysql

    SERVICE\_9042\_NAME: ycql

    SERVICE\_6379\_NAME: yedis

    SERVICE\_9000\_NAME: yb-tserver

  depends\_on:

  - yb-master

  • 初始化ysql

docker-compose exec yb-master bash -c "YB_ENABLED_IN_POSTGRES=1 FLAGS_pggate_master_addresses=yb-master-n1:7100 /home/yugabyte/postgres/bin/initdb -D /tmp/yb_pg_initdb_tmp_data_dir -U postgres"

  • 启动

docker-compose up -d

  • 创建测试数据库

CREATE TABLE users (name text, pass text, id int, primary key (id));

  • 访问效果

目前官方在运行的时候都添加了遥测功能,这个选项可以禁用,但是实际中可能会因为网络的问题造成启动问题,hasura 目前的变化还是挺大的

https://docs.yugabyte.com/latest/releases/

手机扫一扫

移动阅读更方便

阿里云服务器
腾讯云服务器
七牛云服务器

你可能感兴趣的文章