Amazon recently added Oracle database hosting capabilities to its RDS service
offering. You can rent an Oracle database related infrastructure in a
pay-as-you-go fashion now. We are going to explore if corporations should be
utilizing Amazon AWS Oracle Database related services (EC2, RDS ), how it
should be used, where possible savings and potential trouble points are. With
services like Amazon AWS it doesn't matter where your hardware and software
physically is - it could be in a room next to you or in some other country.
It is much easier and cheaper to procure and get new servers up and running.
What's Really New?
You swipe your credit card and get an Oracle database server up and running
in half an hour. Sounds like magic, especially if you compare it to the weeks
and months it normally takes to have an Oracle database server operational in
an average enterprise ... (more)
Hadoop is designed to store extremely large volumes of data. HBase, an open
source NoSQL data store, makes it possible to randomly access such large data
sets. HBase is included in Cloudera's Hadoop distribution.
One of the major obstacles to a wider adoption of NoSQL databases is the lack
of query languages, i.e., lack of comprehensive non-programmatic interfaces
to data inside NoSQL data store. We expect NoSQL databases to come up with
such query languages in near future. In meantime, Quest's Toad for Cloud
fills this gap and makes it easy to seamlessly access NoSQL, Cloud and ... (more)
Modern enterprise class Oracle shops typically operate hundreds of Oracle
databases, all managed by sizable DBA teams.
Properly deployed Oracle databases actually require little administrative
effort. I am here exploring ideas, technologies and techniques that bring us
closer to the fully autonomic, self-managed Oracle database shops.
Autonomic computing aims at delivering self-managed and adaptable database
systems ( and other IT components), while hiding complexity from users and
operators. The goal is to minimize manual administrative effort, thus
leading to reduced OPEX, bett... (more)
The traditional way of performing backups includes using Oracle RMAN in
combination with media management layer software ( typically Netbackup,
Tivoli or similar ), which writes backup data to remote robotic tape unit.
Tapes are then stored offsite to a secure location. It is well known fact
that tape media poses certain challenges in reliability and physical
Cloud-based backups' main attraction is that they are inherently disk based,
always accessible, offsite and there are no capex expenditures. All tape
related costs are thus eliminated. On the other hand ... (more)
A recent BlackBerry outage is the nightmare for both RIM and its
users. Nature and mass popularity of Blackberry service make this
particular outage highly visible. There are many other in-house outages we
never hear about. Companies prefer to keep silent about them, if they can.
The only insight we get into the poor state of DR procedures is in some
public cases like this one, or from limited personal experience. In my Oracle
database infrastructure consulting career I have seen several serious
production outages and was part of a few data recovery efforts.
Backups and DR proc... (more)