April 2018 Summaries

Aiven has integrated with the monitoring and analytics platform, Datadog, allowing users to send metrics from their Aiven for Apache Kafka®, Aiven for PostgreSQL®, Aiven for OpenSearch®, and Aiven for Redis® services to their Datadog account. This unified monitoring system makes it easier to correlate events between a company's and Aiven services, as the data is now available under one roof. The integration also provides real-time insights into resource loads of service VMs and allows users to set customized alerting limits for optimizing their Aiven services usage. There are no additional charges from Aiven for this integration; however, Datadog will still charge based on its pricing schedule. Users can start using the integration by following a two-step guide after updating their service if necessary. Feedback and suggestions for future improvements or additional third-party service integrations are welcome.

The text discusses a visit to New York and New Jersey by the team of Aiven, a company that provides managed cloud services for open-source data technologies. They attended PostgresConf US 2018 in Jersey City where they networked with customers, partners, and new contacts. They also gave two talks on connecting PostgreSQL with Apache Kafka. The key points from their talks include the benefits of using Apache Kafka as a central piece of a data pipeline, the versatility of PostgreSQL for various workloads, and the relevance of SQL in modern systems. Slides for both talks are available on GitHub. Upcoming events related to these topics will be posted on Twitter and RSS feeds.

In the latest post from Aiven, learn how to transform Aiven for PostgreSQL into an advanced open-source time series database using TimescaleDB. Time series data is often voluminous and demands efficient storage for both ingestion and querying. TimescaleDB meets these requirements effectively as a scalable SQL engine packaged as a PostgreSQL extension. This post provides a general overview of time series data, demonstrates how TimescaleDB turns PostgreSQL into a time series database, and guides users through setting up and performing various tasks with it. The tutorial concludes by visualizing the data in Grafana.

PostgreSQL remote read replicas enable users to increase their data availability, as well as read and write performance. Aiven's new feature of remote read replica allows businesses to have a standalone read replica that will never be considered for promotion if the master fails, and it can be set up between homogenous or heterogeneous cloud providers. This functionality provides greater data availability and increased performance (throughput and latency) for reads and writes by offloading reads to the replica. The cost of using this feature is minimal compared to the benefits and peace of mind it brings.