AWS Database Blog

How to use ProxySQL with open source platforms to split SQL reads and writes on Amazon Aurora clusters

The blog post How to set up a single pgpool endpoint for reads and writes with Amazon Aurora PostgreSQL introduces an architecture that uses the read and write split capabilities of Amazon Aurora PostgreSQL endpoints. This type of architecture works great for Aurora PostgreSQL clusters, but what if you are using Amazon Aurora MySQL clusters […]

Read More

How LifeOmic’s JupiterOne simplifies security and compliance operations with Amazon Neptune

This is a guest blog post by Erkang Zheng, the CISO at LifeOmic. Most organizations take a linear, list-based approach to security operations. It’s a two-dimensional process. First, identify resources. Second, manage their configurations. Ideally the tools and technologies for management also alert security analysts about changes in the environment and help with remediation. The […]

Read More

Using Amazon Aurora to seamlessly increase capacity of WordPress database backends

WordPress powers 30 percent of all websites. It is the content management system that we’ve built our business on at Pagely. Our managed WordPress hosting runs entirely on Amazon Web Services. In the same way that Amazon has freed customers from the worries of managing physical hardware and data centers, Pagely enables clients to stop worrying about managing WordPress and instead focus on their mission. Pagely’s dedicated support and experience with successfully running WordPress at scale pairs nicely with Amazon’s technology offerings.

Read More

Migrate from MongoDB to Amazon DocumentDB using the offline method

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. The Amazon DocumentDB Migration Guide outlines three primary approaches for migrating from MongoDB to Amazon DocumentDB: offline, online, and hybrid. The offline migration approach is the fastest and simplest of the three, but it […]

Read More

Implementing a disaster recovery strategy with Amazon RDS

Amazon RDS (Relational Database Service) is a managed service that makes it easier to set up, operate, and scale a relational database. Based on AWS high performance compute and storage, Amazon RDS supports the MySQL, SQL Server, PostgreSQL, MariaDB, and Oracle database engines. It offers a complete set of solutions for provisioning, patching, monitoring, and […]

Read More

Best practices for Amazon Aurora MySQL database configuration

After migrating or launching your new Amazon Aurora MySQL instance in the AWS Cloud, have you asked yourself one or more of the following questions? “What are the next steps? How can I make it run optimally?” “Is it recommended to modify any existing parameters?” “What parameters should I modify?” If so, I hope that […]

Read More

Amazon DynamoDB: Ad tech use cases and design patterns

Advertising technology (ad tech) companies use Amazon DynamoDB to store various kinds of marketing data, such as user profiles, user events, clicks, and visited links. Some of the uses include real-time bidding (RTB), ad targeting, and attribution. In this blog post, I identify the most common use cases and design patterns of ad tech companies […]

Read More

Using new aggregation pipeline capabilities in Amazon DocumentDB to build powerful aggregation queries

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 application code, drivers, and tools as you do today to run, manage, and scale workloads on Amazon DocumentDB. This way, you can enjoy improved performance, scalability, and availability, […]

Read More

Applying best practices for securing sensitive data in Amazon RDS

In the first post of the series, I described some generic security concepts and corresponding AWS security controls that can be applied to data stores on AWS. Using these, you can create a stronger security posture around your data. In this second post, I demonstrate how these concepts can be implemented to Amazon RDS databases. […]

Read More

Add new members to a Hyperledger Fabric channel on Amazon Managed Blockchain

In the previous post in this series, you learned how to build a Hyperledger Fabric network using Amazon Managed Blockchain. After creating the network, you deployed a three-tier application that consisted of Fabric chaincode, a RESTful API, and a user interface application. The network you created was a single-member network, suitable for experimenting and learning […]

Read More