Posts Categorized: Technical Blog

MySQL Conference 2012 Day 0

If you’re at the conference, please come join us for the MySQL Community Dinner at Pedro’s and meet some of the people behind Pythian. We’re always hiring so if you’re interested, please attend the talks and tutorials being presented by Pythian folk, talk to us, or check out the job openings!

Pythian at Collaborate 2012 – Las Vegas

It’s that time of the year again! Collaborate time: the world’s only user-driven, user-run Oracle conference. From April 22nd to 26th, thousands of Oracle professionals are heading to Las Vegas for a week’s worth of presentations, education sessions, networking opportunities, and who knows what else (it’s Vegas, after all!). Here is what we have planned for Collaborate 12!

Using Oracle VM with Amazon EC2

If you’re planning on running Oracle VM with Amazon EC2, there are some important limitations you should know about. As part of my work getting the Oracle Linux Unbreakable Enterprise Kernel 2 working, I tried using the Oracle-supplied Oracle Linux 6 AMI images that are listed as community AMIs by Amazon. Here are my findings.

Testing Out Oracle’s Unbreakable Enterprise Kernel 2

I’m going to test Oracle’s Unbreakable Enterprise Kernel out, and an obvious way to do this would be using Amazon EC2, providing high-capacity instances on demand. After some blind allies getting the Oracle Linux UEK2 kernel working with Amazon EC2 and Oracle VM, I found that I could make it work without Oracle VM, with Amazon’s default Xen hypervisor. Here are the steps I used.

T-SQL:Generate statements to add TEMPDB datafiles

TEMPDB, is one of SQL server hot-debated topics; there’s always something to say about its sizing, file placement or datafiles count in Multi-core instances. This is simply because TEMPDB is a global resource that’s heavily used and very critical asset in a busy instance; this makes any advice against TEMPDB fall in the “It depends” category.

Getting GoldenGate Heartbeats Working with SUPPRESSTRIGGERS

Those of you who have seen me present about GoldenGate will know that I recommend using a heartbeat table to monitor GoldenGate lag. The heartbeat table is a great way to monitor GoldenGate replication because it can follow a single SQL insert through each major GoldenGate replication process, and report the replication lag attributable to each.

Moving MSDB to a New Location

In recent past we had a situation where in, we were required to move MSDB, Model and Master databases to a new location, the reason being a faulty drive. While moving the system databases to the new location we needed to be extra cautious. Let’s see the process step-by-step.

Page 22 of 61« First...10...2021222324...304050...Last »