If you don’t want to deal with missteps, I recommend that you test your standby database to facilitate the failover or switchover process. This procedure is very useful when you have physical standby databases for testing and other purposes that require read-write access to the standby database. Also, it improves your checklist in the event of an error or disaster. Here is how to do it.
Recently, I had an opportunity to participate in a database stress-testing exercise. The objective is to make sure the particular hardware can handle the expected load and also to test where the physical limit of the machine lies if we keep increasing the number of concurrent users. I searched for tools available out there. The open source Hammerora turned out to be excellent tool for the purpose of simulating a typical transactions load in any number of threads. It’s built with the Tcl scripting language and it can simulate a real workload with as many client user sessions as your system can handle. If you’re looking for an easy way to measure throughput performance of your database, keep reading.
Welcome to the 131st edition of Log Buffer, the weekly review of database blogs.
Welcome to the 130th edition of Log Buffer, the weekly review of database blogs.
Welcome, readers, to the 129th edition of Log Buffer, the weekly review of database blogs. Welcome also to 2009, so fresh it still has that wonderful new year smell.
Welcome to the 128th edition of Log Buffer, the weekly review of database blogs.
This is the streamlined version of maybe two hours of fiddling. I hope it will help someone avoid the pitfalls (there are 8-bit crocodiles below!). So I humbly present to you . . .
The 127th edition of of Log Buffer, the weekly review of database blogs, has been published by Robert Treat on zillablog.
Welcome to the 126th edition of Log Buffer, the weekly review of database blogs. Just to be different, let’s start with PostgreSQL this time.
Sometimes you find yourself facing some little problem. You don’t believe it’s a bug or software deficiency, and you spend some time trying to find out what is the silly thing you’ve missed. Here are a handful of issues in Grid Control that cause this sort of little problem.