Building a biological knowledge graph at Pendulum using Amazon Neptune
This is a guest post by Connor Skennerton, Staff Data Engineer at Pendulum Therapeutics.
At Pendulum, we combine state-of-the-art genome sequencing, cell culturing, and manufacturing processes to produce Pendulum Glucose Control,...
Deriving real-time insights over petabytes of time series data with Amazon Timestream
Time series data is one of the fastest growing categories across a variety of industry segments, such as application monitoring, DevOps, clickstream analysis, network traffic monitoring, industrial IoT, consumer IoT, manufacturing,...
Collecting, storing, and analyzing your DevOps workloads with open-source Telegraf, Amazon Timestream, and Grafana
Telegraf is an open-source, plugin-driven server agent for collecting and reporting metrics. Telegraf offers over 230 plugins to process a variety of metrics from datastores to message queues, including InfluxDB, Graphite,...
Top n Window Function queries in MySQL
Top n Window Function queries over a specific subset of data are common in analysis and reporting requirements. Luckily, in MySQL, there are Window functions we can use for this type...
How to Fix MySQL High CPU Usage?
So you thought your database is in good shape, but suddenly your CPU usage spiked and reached 100% at 2AM. How would you go about tracking the root cause and fix...
Announcing the Amazon DocumentDB (with MongoDB compatibility) workshop
Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. You can use the same MongoDB 3.6 and 4.0 application...
Exploring frequently asked questions with AWS Database Solutions Architects
At Amazon, we listen to our customers and work backward from your needs. Our AWS Database Specialist Solutions Architect team helps you architect your database landscape. In this post, we address...
Recover Percona XtraDB Cluster in Kubernetes From Wrong MySQL Config
Kubernetes operators are meant to simplify the deployment and management of applications. Our Percona Kubernetes Operator for Percona XtraDB Cluster serves the purpose, but also provides users the flexibility to fine-tune...
On the Observability of Outliers
At work, I am in an ongoing discussion with a number of people on the Observability of Outliers. It started with the age-old question “How do I find slow queries in...
Setting up Amazon CloudWatch alarms for AWS DMS resources using the AWS CLI
For very large migrations, AWS Database Migration Service (AWS DMS) replication can run for hours or days depending on the data being replicated. It’s advisable to monitor the AWS DMS resources...
Building a secure digital ID using Amazon Managed Blockchain
As more people use mobile devices to access services such as bank accounts and shared vehicles, there has been a surge in digital identity theft and forgery. Most mobile identification systems...
Geo-Redundancy for MySQL InnoDB And NDB Clusters
MySQL highly available solutions, InnoDB Cluster (it uses InnoDB storage engine and is based on Group Replication plugin) and NDB Cluster (NDB storage engine), offer high scalability and redundant topologies.
InnoDB...
Getting started with Amazon DocumentDB (with MongoDB compatibility); Part 4 – using Amazon SageMaker...
Many Python developers—and developers in other languages, too—enjoy the developer experience of notebooks, such as Jupyter. They are a useful tool for developing, but also for sharing code, comments, and results...
Best practices for migrating Oracle database MERGE statements to Amazon Aurora PostgreSQL and Amazon...
To migrate an Oracle database to Amazon Aurora with PostgreSQL compatibility, you usually need to perform both automated and manual tasks. The automated tasks involve schema conversion using AWS Schema Conversion...
Exploring Apache TinkerPop 3.4.8’s new features in Amazon Neptune
Amazon Neptune engine version 1.0.4.0 supports Apache TinkerPop 3.4.8, which introduces some new features and bug fixes. This post outlines these features, like the new elementMap() step and the improved behavior...