Is there any alternative for Elasticsearch

Community Support Server Deployment
,
1

Hi I don’t want to use elastic search because of security issues, so is there any alternative for elastic search that we can use it with temporal.

3

Opensearch should be a drop-in replacement.
Since server version 1.20, SQL db is another option for advanced visibility.

4

Hi @tihomir
So if we use SQL DB for advanced visibility we don’t have to use elastic search then?
currently I was using docker-compose-mysql-es.yml So in this if I don’t want to use elastic search what all changes I have to do?

version: “3.5”
services:
elasticsearch:
container_name: temporal-elasticsearch
environment:
- cluster.routing.allocation.disk.threshold_enabled=true
- cluster.routing.allocation.disk.watermark.low=512mb
- cluster.routing.allocation.disk.watermark.high=256mb
- cluster.routing.allocation.disk.watermark.flood_stage=128mb
- discovery.type=single-node
- ES_JAVA_OPTS=-Xms256m -Xmx256m
- xpack.security.enabled=false
image: elasticsearch:${ELASTICSEARCH_VERSION}
networks:
- temporal-network
ports:
- 9200:9200
volumes:
- /var/lib/elasticsearch/data
mysql:
container_name: temporal-mysql
environment:
- MYSQL_ROOT_PASSWORD=root
image: mysql:${MYSQL_VERSION}
networks:
- temporal-network
ports:
- 3306:3306
volumes:
- /var/lib/mysql
temporal:
container_name: temporal
depends_on:
- mysql
- elasticsearch
environment:
- DB=mysql
- MYSQL_USER=root
- MYSQL_PWD=root
- MYSQL_SEEDS=mysql
- DYNAMIC_CONFIG_FILE_PATH=config/dynamicconfig/development-sql.yaml
- ENABLE_ES=true
- ES_SEEDS=elasticsearch
- ES_VERSION=v7
image: temporalio/auto-setup:${TEMPORAL_VERSION}
networks:
- temporal-network
ports:
- 7233:7233
volumes:
- ./dynamicconfig:/etc/temporal/config/dynamicconfig
labels:
kompose.volume.type: configMap
temporal-admin-tools:
container_name: temporal-admin-tools
depends_on:
- temporal
environment:
- TEMPORAL_CLI_ADDRESS=temporal:7233
image: temporalio/admin-tools:${TEMPORAL_VERSION}
networks:
- temporal-network
stdin_open: true
tty: true
temporal-ui:
container_name: temporal-ui
depends_on:
- temporal
environment:
- TEMPORAL_ADDRESS=temporal:7233
- TEMPORAL_CORS_ORIGINS=http://localhost:3000
image: temporalio/ui:${TEMPORAL_UI_VERSION}
networks:
- temporal-network
ports:
- 8080:8080
networks:
temporal-network:
driver: bridge
name: temporal-network

And when will OpenSearch be released in temporal?