0

We are attempting to replace our existing Cassandra EC2 Cluster with AWS Keyspace and we are attempting to keep our old code base. The idea is to simply get out of the devops business and have our Cassandra managed by AWS (scaling, upgrades, etc.). Looking at the guide they provide

https://docs.aws.amazon.com/keyspaces/latest/devguide/using_java_driver.html

They use a different (newer) driver than we currently use:

Our current driver:

<dependency>
    <groupId>com.datastax.cassandra</groupId>
    <artifactId>cassandra-driver-core</artifactId>
    <version>3.3.0</version>
</dependency>

Their example:

<dependency>
    <groupId>com.datastax.oss</groupId>
    <artifactId>java-driver-core</artifactId>
    <version>4.4.0</version>
</dependency>

The code examples seem radically different than our existing code.

Question - has anyone successfully migrated to AWS Keyspaces using the older driver and old code? Or does this require an upgrade? My hesitation is that we have a lot of code and with the cost of refactoring it might be easier to abandon Cassandra and start over with something else (DynamoDB, MongoDB, etc.).

Kirby
  • 15,127
  • 10
  • 89
  • 104
Age of Empires
  • 1
  • 2
  • 1
    keep in mind that AWS Keyspaces have functional differences - it's not a hosted Cassandra, but a kind of "Cassandra API for DynamoDB". Check first doc: https://docs.aws.amazon.com/keyspaces/latest/devguide/functional-differences.html. If you need hosted Cassandara, look onto https://astra.datastax.com/ – Alex Ott Nov 20 '21 at 12:40
  • Thanks for the info. Definitely want to go to a host service just we we don't have to do our own devops, but would the host service also require an upgrade of the driver? I believe our version of Cassandra is pretty old. – Age of Empires Nov 22 '21 at 16:38
  • You can use driver 3.x to connect to Astra: https://docs.datastax.com/en/developer/java-driver/3.10/manual/cloud/ – Alex Ott Nov 22 '21 at 16:41
  • Thanks! I am in the process of upgrading drivers and code, though the changes are pretty significant. – Age of Empires Nov 23 '21 at 18:36
  • Yeah, driver 4 changes are huge – Alex Ott Nov 23 '21 at 18:52
  • Keyspaces can use the 3.x drivers – MikeJPR May 12 '22 at 13:58

1 Answers1

0

Amazon Keyspaces can use the 3.x drivers pretty simply. While there are benefits to the 4.x driver, like externalized configuration, there is no need to upgrade to move the Amazon Keyspaces.

You can use traditional user/name password authentication or the sigv4 plugin.

<!-- https://mvnrepository.com/artifact/software.aws.mcs/aws-sigv4-auth-cassandra-java-driver-plugin -->
<dependency>
    <groupId>software.aws.mcs</groupId>
    <artifactId>aws-sigv4-auth-cassandra-java-driver-plugin_3</artifactId>
    <version>3.0.3</version>
</dependency>

Code sample to connect with java 3.x and write to keyspaces.

import com.datastax.driver.core.Cluster;
import com.datastax.driver.core.Session;
import com.datastax.driver.core.PreparedStatement;
import com.datastax.driver.core.ResultSet;
import com.datastax.driver.core.Row;
import software.aws.mcs.auth.SigV4AuthProvider;

import java.net.InetSocketAddress;
import java.util.Collections;
import java.util.List;


    public class OrderFetcher {
        public final static String TABLE_FORMAT = "%-25s%s\n";
        public final static int KEYSPACES_PORT = 9142;
    
        public static Cluster connectToCluster(String region, List<InetSocketAddress> contactPoints) {
            SigV4AuthProvider provider = new SigV4AuthProvider(region);
            return Cluster.builder()
                    .addContactPointsWithPorts(contactPoints)
                    .withPort(KEYSPACES_PORT)
                    .withAuthProvider(provider)
                    .withSSL()
                    .build();
        }
    
        public static void main(String[] args) {
            if (args.length != 3) {
                System.err.println("Usage: OrderFetcher <region> <endpoint> <customer ID>");
                System.exit(1);
            }
    
            String region = args[0];
            List<InetSocketAddress> contactPoints = Collections.singletonList(new InetSocketAddress(args[1], KEYSPACES_PORT));
    
            try (Cluster cluster = connectToCluster(region, contactPoints)) {
                Session session = cluster.connect();
    
                // Use a prepared query for quoting
                PreparedStatement prepared = session.prepare("select * from acme.orders where customer_id = ?");
    
                // We use execute to send a query to Cassandra. This returns a ResultSet, which is essentially a collection
                // of Row objects.
                ResultSet rs = session.execute(prepared.bind(args[2]));
    
                // Print the header
                System.out.printf(TABLE_FORMAT, "Date", "Order Id");
    
                for (Row row : rs) {
                    System.out.printf(TABLE_FORMAT, row.getTimestamp("order_timestamp"), row.getUUID("order_id"));
                }
            }
    
        }
    }

Here is a link to example on github

https://github.com/aws-samples/amazon-keyspaces-examples/blob/main/java/datastax-v3/connection-sigv4/src/main/java/software/aws/mcs/example/OrderFetcher.java

MikeJPR
  • 764
  • 3
  • 14