ALL POSTS

Benchmarking NDB vs Galera

Inspired by the benchmark in this post, we decided to run some NDB vs Galera benchmarks for ourselves. We confirmed that NDB does not perform well using m1.large instances. In fact, it’s totally unacceptable –  no setup should ever have a minimum latency of 220ms – so m1.large instances are not an option. Apparently the…

Put Opsview Hosts Into Downtime via the Shell

Recently a client of ours who used opsview to manage their resources needed to place some of their hosts into downtime in conjunction with some other cron-scheduled tasks. In order to implement that functionality, I created this simple script that should work with most installations of opsview, or with a few modifications, can be modified…

Changing SID on a RAC Environment

Just a short note documenting a procedure that isn’t done frequently, and I didn’t see described anywhere else. Somewhere last month a customer asked for my help in changing the SIDs on one of his RAC databases to match the new corporate standard. The database name matched the standard so we could leave that alone, but the SID needed to be changed. Here’s what we did to change it

Temporary Tablespaces: to BIGFILE or Not to BIGFILE

The environment was an Exadata environment undergoing pre-production stress testing. We used Real Application Testing to take a highly-concurrent OLTP workload, and replayed the workload with the synchronization parameter set to FALSE, effectively increasing concurrency beyond the original test system. AWR showed a large volume of buffer busy activity.

Still a Lot of Database Offerings…

The CORE database audience has been well served at this year’s version of the UKOUG forum. Many of the shows we attend concentrate on the late-breaking components of the vendors’ new offerings. The attendees are hungry for this information and having it delivered in a 4-5 day package is very helpful.

Page 60 of 281« First...102030...5859606162...708090...Last »