dosubot[bot] commented on issue #7864:
URL:
https://github.com/apache/incubator-devlake/issues/7864#issuecomment-2274040383
<!-- Answer -->
You do not need to reinstall DevLake. You can resolve the error code 500
when connecting a MySQL RDS instance by following these steps:
1. Comment out the MySQL part in your `docker-compose.yml` file:
```yaml
# mysql:
# image: mysql:8
# volumes:
# - mysql-storage:/var/lib/mysql
# restart: always
# ports:
# - "127.0.0.1:3306:3306"
# environment:
# MYSQL_ROOT_PASSWORD: admin
# MYSQL_DATABASE: lake
# MYSQL_USER: merico
# MYSQL_PASSWORD: merico
# command:
# --character-set-server=utf8mb4
# --collation-server=utf8mb4_bin
```
2. Comment out the MySQL volume:
```yaml
# volumes:
# mysql-storage:
```
3. Comment out the `depends_on mysql` part:
```yaml
# depends_on:
# - mysql
```
4. Set `DB_URL` to your own DB_URL in the `.env` file:
```bash
DB_URL="mysql://YOUR_USER:YOUR_PASSWORD@YOUR_IP:YOUR_PORT/lake?charset=utf8mb4&parseTime=True"
# Don't forget to create db named `lake` in your own db, and set
character-set-server=utf8mb4, collation-server=utf8mb4_bin as below
# character-set-server=utf8mb4
# collation-server=utf8mb4_bin
```
5. Run `docker compose up -d`.
Additionally, if you encounter the error "The total number of locks exceeds
the lock table size," you can solve it by increasing the
`innodb_buffer_pool_size` to a higher value in your MySQL configuration. Here
is an example of how to modify the `docker-compose` file for MySQL:
```yaml
mysql:
image: mysql:8
...
# add the following line to the mysql container
command: --innodb-buffer-pool-size=200M
```
These steps should help you connect to your MySQL RDS instance without
needing to reinstall DevLake
<sup>[[1]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.16/GettingStarted/DockerComposeSetup.md)</sup><sup>[[2]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.19/Troubleshooting/Configuration.md)</sup><sup>[[3]](https://github.com/apache/incubator-devlake-website/blob/main/versioned_docs/version-v0.21/Troubleshooting/Configuration.md)</sup>.
<!-- Dosu Comment Footer -->
*To continue talking to [Dosu](https://dosu.dev), mention @dosu.*
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
