Does Botium Box store the test data secure, reliable and long-term ?
Botium Box uses Prisma as data storage mechanism, which itself is backed by a MySQL-compatible or PostgreSQL-compatible relational database. On deployment, Botium Box includes it’s own Prisma service and MySQL database by default.
There is no management interface, no backup mechanism, no data recovery mechanism in place by default. You have to take care yourself.
If you have your own database infrastructure, you can easily replace the included MySQL database with your own MySQL-compatible database.
While it would be technically possible to replace the included Prisma service with a your own hosted Prisma service, either on-premise or in the cloud, we don’t recommend it (and we don’t support such replacements).
Here are some examples for MySQL compatible databases you can use:
MySQL Community Edition (on-premise installation)
MariaDB (on-premise installation)
Amazon RDS for MySQL (cloud service)
Amazon RDS for MariaDB (cloud service)
Azure Database for MySQL (cloud service)
Azure Database for MariaDB (cloud service)
In either setup, for connection Botium Box to your MySQL database, you need connection information:
Hostname and Port (default: 3306)
Username and Password
Edit the PRISMA_CONFIG environment variable in your config map when using Kubernetes deployment, or in your docker-compose file if using Docker deployment:
apiVersion: v1 kind: ConfigMap metadata: name: botium-box-ce-configmap namespace: botium-box-ce labels: name: config app: botium-box-ce data: PRISMA_ENDPOINT: http://prisma:4466/box/ce BOTIUMBOX_QUEUE_REDISURL: redis://redis:6379 PRISMA_CONFIG: | port: 4466 databases: default: connector: mysql host: my-mysql-host-name port: 3306 user: my-mysql-user-name password: my-mysql-password migrations: true
See Prisma Documentation for details