BYO Oracle RAC on EC2

March 18th, 2011

Former work mate Jeremy Schneider is always the first to look at interesting ways to use Oracle RAC – now he’s considering to run a BYO Oracle RAC on Amazon EC2. I kinda defeats the purpose of cloud, but it’s still fun the play with.

So what’s the right way to use the cloud for DB scalability (specifically RDBMS, not SimpleDB), you may ask? It’s through sharding, and the fine folks at Xeround and Microsoft are already heavily investing in making that easier and more transparent for developers.

Oracle Database Firewall

March 18th, 2011

Oracle recently released it’s Oracle Database Firewall.

[The] release of Oracle Database Firewall is the culmination of the company’s  acquisition of database security vendor Secerno last year. The product  creates a defensive perimeter around databases by looking at SQL  statements sent to the database through the wire to determine whether to  pass, log, alert, block, or substitute SQL statements based on an  organization’s policies. Users can set whitelist or blacklist policies  to control the product, which is designed to work not only with Oracle  databases, but also other major platforms, such as DB2, SQL Server and  Sybase platforms.

As usual, they claim it’s going to replace all competitor’s remotely similar products, which is now causing quite a controversy among them, nicely summarized by Pete Finnigan in Oracle Database Firewall Controversy.

Gartner released it’s 2011 Magic Quadrant for Business Intelligence Platforms, and Oracle apparently is sponsoring it for the public.

We have to obvious suspects in the leaders quadrant: Oracle, IBM, Microsoft and SAP, as well as a few smaller folks. Most of the remaining vendors are in the niche players quadrant, there are no visionaries and just two in the challengers quadrant.

The market according to Gartner appears to be mature, and most vendors have found a good (or should I say: boring?) balance between vision and execution.

It’s that time of the year again: January 2011 Oracle Critical Patch Update Released. People using OEM Grid Control on 11g versions and people using RAC on 10g and newer are vulnerable to remote vulnerabilities not requiring authentication, so again quite a serious CPU. Go and patch!

Oracle Direct NFS Clonedb Feature

December 27th, 2010

Kevin Closson introduces us to the Oracle 11g Direct NFS Clonedb Feature in a mini-series (part 1.5). Sounds very interesting from what I hear. And I wonder if this is a(nother) sign of Oracle going against NetApp, i.e. maybe even a sign of soon to be announced features or products that will further de-value NetApp features with offerings from the combined Oracle and Sun stack?

Oracle took the popular DBA Views poster and now provide a Flash based digital version for download at Oracle 11g Interactive Quick Reference. I’m not sure how helpful that’s ultimately going to be as it doesn’t allow for the same kind of visual browsing, but wanted to post this anyway.

Via the Oracle DB Insider blog.

Oracle answer one of the most asked questions around CPUs: What are the criteria used by Oracle to decide whether a vulnerability warrants a fix in the CPU?

Oracle Workload Management, No. 2

November 16th, 2010

Another one in the series of Oracle Workload Management posts: Workload Management – Based on Execution Times, about a dynamic switching system based on the optimizer’s estimate of the execution time.

Husnu Sensoy lists in great detail how to Create Your Own Oracle TPC-H Playground on Linux. He doesn’t cover load generators or benchmark tools, just dbgen to generate test data. If you need more, look e.g. for Quest Benchmark Factory, which can create and benchmark all the relevant TPC-x benchmarks, also on DBs other than Oracle.

Recommend any other benchmark tool? Let me know!

Using MySQL as NoSQL

October 25th, 2010

Using MySQL as a NoSQL – A story for exceeding 750,000 qps on a commodity server – how to almost achieve double the Memcached performance using a MySQL UDF that bypasses the SQL layer, talks directly to the InnoDB layer. Wonder if the SQL overhead is similar in Oracle or MS SQL Server, and how you’d work around that there.

Via High Scalability Blog.