Oracle NoSQL in AWS (Part 2)
We used a pre-release version of Oracle NoSQL with 'Bulk Put' support to improve upon the document insert times shown in "Oracle NoSQL in AWS" blog which can be found at
http://blog.nebulasoftwaresystems.com/oracle-nosql-in-aws
Oracle documentation for the new Bulk Put support can be found here:-
Oracle NoSQL in AWS
A 2 node test cluster
Goal
Set up a simple 2 Storage Node Oracle NoSQL database without replication in AWS, verify the installation and use for some basic performance tests for a customer needing fast metadata storage for a high volume 3D imaging application.
4 EC2 instances were created inside an Amazon Web Services Virtual Private Cloud (VPC) with the . . .
MongoDB with Wired Tiger in AWS
Some initial performance results
Goal
Set up a simple 2 Shard MongoDB 3.0 database without replication in AWS using the new WiredTiger storage engine, verify the installation and use for some basic performance tests for a customer needing fast metadata storage for a high volume 3D imaging application.
Infrastructure
5 EC2 instances were created inside an Amazon Web . . .
How to use Statspack with Oracle RDS instances
If you use Oracle SE One edition in Amazon RDS, you don't get to use Advanced Workload Repository (AWR). That's for the Enterprise license only. But the old familiar legacy Statspack which has been around since Oracle 8i IS available, and is very easy to set up in RDS thanks to Amazon.
To get Statspack installed for an instance you . . .
Android with Google Maps
Mobile embedded database synchronized with Cloud
Nebula’s Mobile Location Manager demonstrates a mapping application that can build location aware Android applications for multiple business models. It is designed to synchronize with Oracle and other database and application servers, and to consume Cloud resident SOA services.
Screenshot of Verizon Droid running Android and Location Manager . . .
Oracle Datapump with Amazon RDS
Some time saving scripts
When working with RDS Oracle instances and faced with relatively frequent use of datapump export and import to refresh instances of small to medium size, I find it convenient to use a small EC2 instance loaded with an Oracle 11g home and 11g database and a few simple scripts to automate the export and import (depending on your security setup . . .
Working with Amazon RDS
Migration to Amazons's Relational Database Service
Cloud services such as AWS are mature enough and enterprise ready. Many startups are considering the cloud as the first choice for hosting their websites and applications and organizations are looking at migrating their current infrastructure to the cloud. The big idea behind the cloud is to reduce the need to setup and maintain your own . . .