The default DbSchema connection dialog shows an option to connect only to a single host. To connect to multiple hosts use the 'JDBC URL' tab and edit a string like here:
jdbc:scylladb://host1[:port1][,host2[:port2],...[,hostN[:portN]]][/[keyspace];[dataCenter][&options]]
Find the DataCenter using 'nodetool status' or 'nodetool -h ::FFFF:127.0.0.1 status'.
This will be translate an URL like jdbc:scylladb://192.168.0.1:9042/mykeyspace into:
Cluster cluster = Cluster.builder().addContactPoint("192.168.0.1").withPort(9042).build();
Session session = cluster.connect("mykeyspace");
-Djavax.net.ssl.trustStore=/path/to/client.truststore
-Djavax.net.ssl.trustStorePassword=password123
# If you're using client authentication:
-Djavax.net.ssl.keyStore=/path/to/client.keystore
-Djavax.net.ssl.keyStorePassword=password123
From Windows menu you can start DataStax Dev Center and connect to the installed ScyllaDB:
To execute a command select first a connection in the top menu.
CREATE KEYSPACE sample
WITH REPLICATION = { 'class' : 'NetworkTopologyStrategy',
'datacenter1' : 3 } AND DURABLE_WRITES = false;
CREATE TABLE sample.table1 ( id int primary key, name text);
####################
CREATE TYPE sample.flagtype (data map<text,text>,working text);
CREATE TABLE sample.table1a (abc text,
hello text,
flag frozen<flagtype>,
PRIMARY KEY (abc));
INSERT INTO sample.table1a JSON '{"abc":"abc", "hello":"world", "flag":{"data":{"hi":"cassandra"}, "working":"no"}}';