Once the VoltDB database starts, you are ready to manage the database contents. Using Kubernetes does not change how you manage the database content. However, it does require a few extra steps to ensure you have access to the database, as described in Section 3.2.1, “Accessing the Database Interactively”.

First you need to identify the pods using the kubectl get pods command. You can then access the pods, individually, using the kubectl exec command, specifying the pod you want to access and the command you want to run. For example, to run sqlcmd on the first pod, use the following command:

$ kubectl exec -it mydb-voltdb-cluster-0 -- sqlcmd
SQL Command :: localhost:21212
1>

You can execute a local batch file of sqlcmd commands remotely by piping the file into the utility. For example:

$ cat schema.sql
 CREATE TABLE HELLOWORLD ( 
    HELLO VARCHAR(15), WORLD VARCHAR(15),
    DIALECT VARCHAR(15) NOT NULL
 );
 PARTITION TABLE HELLOWORLD ON COLUMN DIALECT;
$ kubectl exec -it mydb-voltdb-cluster-0 -- sqlcmd < schema.sql
Command succeeded.
Command succeeded.
$

Changing the database schema does not require synchronization with Helm or Kubernetes necessarily. However, if you specified the schema and/or procedure classes when you initially create the Helm release, it may be a good idea to keep those properties updated in case you need to re-initialize the database. (for example, when re-establishing a XDCR connection that was broken due to conflicts.) This can be done by updating the cluster.config.schemas and/or cluster.config.classes properties. For example:

$ helm upgrade mydb voltdb/voltdb       \
   --reuse-values                       \
   --set-file cluster.config.schemas schema.sql \
   --set-file cluster.config.classes procs.jar