Milvus uses SQLite as metadata management service in the backend by default. SQLite is embedded in the Milvus process, so there is no need to run additional services. However, in production, it is strongly recommended that you use MySQL as metadata management service because of reliability.
Follow the steps below to use MySQL as metadata management service in Linux:
Pull the latest image of MySQL:
$ docker pull mysql:latest
Launch MySQL service. You can set your own password and port.
$ docker run -p 3306:3306 -e MYSQL_ROOT_PASSWORD=123456 -d mysql:latest
Use root account and the IP of the host that runs MySQL service (
<MySQL_server_host IP>) to log in MySQL. Press <ENTER> to enter the password you set in the previous step.
$ mysql -h<MySQL_server_host IP> -uroot -p
Enter MySQL client command line interface to create a database. Here we use
milvusas the database name.
create database milvus
Quit MySQL client and update the
server_config.yaml. Use the IP of the host that runs MySQL service (
<MySQL_server_host IP>). Note that the password, IP address, port, and database name must be consistent with your previous settings.
backend_url: mysql://root:123456@<MySQL_server_host IP>:3306/milvus
- Use the updated
server_config.yamlto launch Milvus.
From data import, data storage to data querying and scheduling, our blogs on Medium introduce detailed insights about the data management strategy in Milvus.