Single server with SQLite

[vitorsavian]

Is your feature request related to a problem? Please describe.

Describe the solution you'd like

• When rke2 uses the disable-etcd flag and not set the server flag, he need to initiate with sqlite as the default database

Describe alternatives you've considered

Additional context

• Kine was added and we saw a possibility to help our users to set a single node sqlite in a easy way and also make rke2 have almost the same behavior as k3s

[VestigeJ]

Cluster is ready and healthy

$ COMMIT=3aaa16c9b17da45e9f3475ba5011ed90a49a2e42

config.yaml

token: YOUR_TOKEN_HERE
write-kubeconfig-mode: 644
debug: true
cni: multus,cilium
disable-etcd: true

$ kgn

NAME               STATUS   ROLES                  AGE   VERSION
ip-ip              Ready    control-plane,master   41m   v1.30.1+rke2r1

$ kgp -A

NAMESPACE     NAME                                                    READY   STATUS      RESTARTS      AGE
kube-system   cilium-operator-f6cf5bf74-q8rkg                         0/1     Pending     0             41m
kube-system   cilium-operator-f6cf5bf74-zblpw                         1/1     Running     0             41m
kube-system   cilium-sfn7c                                            1/1     Running     0             41m
kube-system   cloud-controller-manager-ip-ip                          1/1     Running     0             41m
kube-system   helm-install-rke2-cilium-s5k6l                          0/1     Completed   0             41m
kube-system   helm-install-rke2-coredns-fpw74                         0/1     Completed   0             41m
kube-system   helm-install-rke2-ingress-nginx-5qxb7                   0/1     Completed   0             41m
kube-system   helm-install-rke2-metrics-server-bct9x                  0/1     Completed   0             41m
kube-system   helm-install-rke2-multus-ns9kh                          0/1     Completed   0             35m
kube-system   helm-install-rke2-snapshot-controller-5zxzp             0/1     Completed   0             41m
kube-system   helm-install-rke2-snapshot-controller-crd-9xj6z         0/1     Completed   0             41m
kube-system   helm-install-rke2-snapshot-validation-webhook-t4nk8     0/1     Completed   0             41m
kube-system   kube-apiserver-ip-ip                                    1/1     Running     0             41m
kube-system   kube-controller-manager-ip-ip                           1/1     Running     0             41m
kube-system   kube-proxy-ip-ip                                        1/1     Running     0             41m
kube-system   kube-scheduler-ip-ip                                    1/1     Running     0             41m
kube-system   rke2-coredns-rke2-coredns-64dcf4f58b-5hrld              1/1     Running     0             41m
kube-system   rke2-coredns-rke2-coredns-autoscaler-5749cd7b8b-tpb96   1/1     Running     0             41m
kube-system   rke2-ingress-nginx-controller-zhz7b                     1/1     Running     0             40m
kube-system   rke2-metrics-server-868fc8795f-fd96k                    1/1     Running     0             40m
kube-system   rke2-multus-6sf96                                       1/1     Running     3 (40m ago)   41m
kube-system   rke2-multus-rke2-whereabouts-2799s                      1/1     Running     0             35m
kube-system   rke2-snapshot-controller-7dcf5d5b46-xcbz6               1/1     Running     0             40m
kube-system   rke2-snapshot-validation-webhook-bf7bbd6fc-dz4g7        1/1     Running     0             40m

//observe sqlite start up in journalctl
$ sudo journalctl -u rke2-server | grep -i sqlite

Jun 11 18:56:11 ip-ip rke2[3121]: time="2024-06-11T18:56:11Z" level=info msg="Configuring sqlite3 database connection pooling: maxIdleConns=2, maxOpenConns=0, connMaxLifetime=0s"
Jun 11 18:56:12 ip-ip rke2[3121]: time="2024-06-11T18:56:12Z" level=info msg="Configuring sqlite3 database connection pooling: maxIdleConns=2, maxOpenConns=0, connMaxLifetime=0s"

//observe kine table stored in state.db /var/lib/rancher/rke2/server/db/state.db

$ sudo sqlite3 /var/lib/rancher/rke2/server/db/state.db
// sample output from sqlite query on kine table

es/kube-system/cilium-operator-resource-lock|0|0|695|3783|0|k8s|k8s
3785|/registry/leases/kube-system/apiserver-3pt4lblhojbebjzbd3i5qqxmka|0|0|68|3774|0|k8s|k8s
3786|/registry/leases/kube-system/snapshot-controller-leader|0|0|1129|3780|0|k8s|k8s
3787|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3784|0|k8s|k8s
3788|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3787|0|k8s|k8s
3789|/registry/masterleases/ip|0|0|200|3778|15|k8s|k8s
3790|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1289|3781|0|k8s|k8s
3791|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3788|0|k8s|k8s
3792|/registry/leases/kube-system/snapshot-controller-leader|0|0|1129|3786|0|k8s|k8s
3793|/registry/leases/kube-node-lease/ip-ip|0|0|399|3782|0|k8s|k8s
3794|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3791|0|k8s|k8s
3795|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3794|0|k8s|k8s
3796|/registry/leases/kube-system/apiserver-3pt4lblhojbebjzbd3i5qqxmka|0|0|68|3785|0|k8s|k8s
3797|/registry/leases/kube-system/snapshot-controller-leader|0|0|1129|3792|0|k8s|k8s
3798|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1289|3790|0|k8s|k8s
3799|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3795|0|k8s|k8s
3800|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3799|0|k8s|k8s
3801|/registry/masterleases/ip|0|0|200|3789|15|k8s|k8s
3802|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3800|0|k8s|k8s
3803|/registry/leases/kube-system/snapshot-controller-leader|0|0|1129|3797|0|k8s|k8s
3804|/registry/leases/kube-node-lease/ip-ip|0|0|399|3793|0|k8s|k8s
3805|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3802|0|k8s|k8s
3806|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1289|3798|0|k8s|k8s
3807|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3805|0|k8s|k8s
3808|/registry/leases/kube-system/apiserver-3pt4lblhojbebjzbd3i5qqxmka|0|0|68|3796|0|k8s|k8s
3809|/registry/leases/kube-system/snapshot-controller-leader|0|0|1129|3803|0|k8s|k8s
3810|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3807|0|k8s|k8s
3811|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3810|0|k8s|k8s
3812|/registry/masterleases/ip|0|0|200|3801|15|k8s|k8s
3813|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3811|0|k8s|k8s
3814|/registry/leases/kube-system/snapshot-controller-leader|0|0|1129|3809|0|k8s|k8s
3815|/registry/leases/kube-system/rke2-ingress-nginx-leader|0|0|1289|3806|0|k8s|k8s
3816|/registry/leases/kube-system/cilium-operator-resource-lock|0|0|695|3813|0|k8s|k8s
3817|/registry/leases/kube-node-lease/ip-ip|0|0|399|3804|0|k8s|k8s