Postgres has finally come to RDS! Want to know how these instances stack up on a naive pgbench test? Below is a table of simple pgbench results taken over a 60 second period. All RDS instances were launched into us-east-1a, and pgbench (9.4devel) was run from an m2.4xlarge in us-east-1a as well. TPS t1.micro
While many Amazon Web Services resources with "state" have CloudWatch sensors available, AWS VPCs and tunnels unfortunately do not. If you're ever in need of a solution to monitor and log the status of VPC tunnels back to another data center or office, my gist below will be right up your alley. It uses
Benchmarking I/O with Oracle ORION is an important part of planning, baselining, and performance-tuning Oracle environments. I've previously provided ORION results for the hi1.4xlarge SSD-backed instance class, and based on some recent work, I wanted to provide an update for the newer hs1.8xlarge instance class. Below you'll find hs1.8xlarge Oracle ORION benchmark results with the following
As a consultant and advisor to many firms running on or investigating AWS, I find SSH host and key management to be a constant struggle. From IAM credentials to default OS logins, it's easy to lose time with constant lookups. What we'd really like is to get a custom SSH config file for AWS.
I'll be giving a talk tonight on automated Oracle database deployment at the SouthEast Michigan Oracle Professionals (SEMOP) Meetup Group. While I'll be following up on this post later, I wanted to share the slides and Github repository for participants to follow along: Automating Oracle Database deployment with Amazon Web Services, fabric, and boto from mjbommar Github
In a typical Oracle database implementation, you'll want to baseline or benchmark your storage. The storage team will hand over, and you'll run a battery of tests using software like bonnie++ or ORION. You'll make sure that the results are in-line with requirements and expectations. What if you are implementing said database on
Tonight, Eric and I will be presenting back-to-back talks at the AWS Michigan meetup (hosted by the Tech Brewery this time). Eric will be detailing a large Matlab HPC experiment we ran this summer to optimize parameters for a trading strategy; this one is a great AWS case study, as we crunch 10B inputs
In our last post on cloud architectures, I covered a simple one-node Oracle Transportation Management instance on Amazon Web Services using EC2. This OTM cloud hosting configuration is well-suited to a development environment and is a very inexpensive option for teams that have on-staff database administration skills. For teams that do not have the
As I mentioned on Monday, I'll be starting a series of posts on Oracle Transportation Management (OTM) in the cloud. In the first stage of these posts, I'll be covering the set of feasible architectures given the infrastructure offerings at Amazon Web Services. And, as you might expect, we'll be starting with the simplest
I wanted to update readers to let them know of an upcoming post series on Oracle Transportation Management (OTM) in the cloud. Oracle Transportation Management is a powerful solution for businesses or 3PLs that need to take control of their supply chain planning and execution. While many organizations continue to run OTM in a
