Blogs

Technical

What Is the Instaclustr Terraform Provider?

Friday 30th July 2021 by Taylor Bliszcz

Terraform is an open source platform that allows you to create, manage, and delete cloud resources in different cloud providers.

Technical — Cassandra Technical — Kafka

Why AWS PrivateLink Is Not Recommended With Kafka or Cassandra

Wednesday 28th July 2021 by Wade Timmer

Using PrivateLink, it is impossible by design to contact specific IPs within a VPC in the same way you can with VPC peering. VPC peering allows a connection between two VPCs, while PrivateLink publishes an endpoint that others can connect to from their own VPC.

Technical — Cassandra

Why You Shouldn't Run Nodetool Removenode

Monday 26th July 2021 by Ritam Das

There comes a time when your Apache Cassandra implementation will require scaling down or general maintenance (significant drop in disk usage or a number of reads and writes per second, etc.). Removing a node, whether it is working or not, falls under this scaling and maintenance. When scaling down, it is necessary to have the […]

Technical — Postgres Technical — Kafka

Streaming JSON Data Into PostgreSQL Using Open Source Kafka Sink Connectors (Pipeline Series Part 6)

Thursday 22nd July 2021 by Paul Brebner

Having explored one fork in the path (Elasticsearch and Kibana) in the previous pipeline blog series, in this blog we backtrack to the junction to explore the alternative path (PostgreSQL and Apache Superset). But we’ve lost our map (aka the JSON Schema)—so let’s hope we don’t get lost or attacked by mutant radioactive monsters.

Technical

Introduction to Instaclustr Boost Sizes

Monday 19th July 2021 by Instaclustr

Instaclustr has released support for an additional node type across all of our Managed Instaclustr Technologies. These sizes provide us with a more robust method of dealing with situations where customer data threatens to consume all available disk space (usually, despite warnings of the need to increase capacity) high disk usage.

Technical — Elasticsearch

Understanding and Configuring Elasticsearch Node Types

Wednesday 14th July 2021 by Shelby Carpenter

If you’re getting started with the Open Distro of Elasticsearch, or its replacement, OpenSearch, you need to start with a firm foundation on how to configure nodes within a given cluster. A key part of setting your configurations is deciding what node types you want for individual nodes.

Technical — Redis

Instaclustr Announces the General Availability of Instaclustr for Redis on Graviton 2

Wednesday 16th June 2021 by Thomas Griffiths

Instaclustr is pleased to announce the general availability of Instaclustr for Redis on Graviton 2 processors. These processors offer higher performance per core and lower infrastructure costs, providing extra value for customers using the Instaclustr Managed Platform on AWS.

Technical — Postgres Technical

Unlocking the Full Potential Of PostgreSQL JSON

Monday 7th June 2021 by Paul Brebner

In this blog we’ll answer the most commonly asked questions about the use of PostgreSQL JSON data type to help you unlock its full potential.

Feature Releases Technical — Elasticsearch

Instaclustr Announces PCI-DSS Certification for Elasticsearch

Friday 4th June 2021 by Instaclustr

Instaclustr is pleased to announce the addition of Managed Elasticsearch to our PCI-DSS certified offerings running in AWS. Our service is based on Open Distro for Elasticsearch which will soon be updated to OpenSearch. Managed Elasticsearch joins our PCI-DSS certified Apache Cassandra and Apache Kafka offerings.  PCI-DSS (Payment Card Industry – Data Security Standard) is […]

Technical Technical — Postgres

The PostgreSQL Boolean Three-Valued Logic Data Type

Tuesday 1st June 2021 by Paul Brebner

In my previous PostgreSQL blog, we discovered what data types are available in PostgreSQL (a lot) and hopefully determined the definitive mapping from PostgreSQL to SQL/JDBC to Java data types. However, even armed with this information you have to be careful about type conversion/casting, and watch out for run-time errors, truncation, or loss of information.

Technical Technical — Postgres

PostgreSQL Data Types: Mappings to SQL, JDBC, and Java Data Types

Monday 24th May 2021 by Paul Brebner

How do you use PostgreSQL from Java? With JDBC! (Java Database Connectivity). There’s a PostgreSQL JDBC Driver (PgJDBC for short) which allows Java programs to connect using standard, database independent, Java code. It’s an open source Pure Java (Type 4, which talks native PostgreSQL protocol) driver and is well documented.

Technical Technical — Postgres

The Case for PostgreSQL

Wednesday 19th May 2021 by Kirk Roybal

If you’re in database administration, chances are you’ve faced an age-old question: is it better to become slightly proficient in lots of different database tools, or become very proficient in one tool that can do a bit of everything reasonably well?  I have been a software engineer for over 35 years, and have been privileged […]