I’m in the process of taking on some of the MySQL databases in my company. The first ones are MySQL 4.1 running on Windows, so we are upgrading them to MySQL 5.6 on Oracle Linux. As with many of our systems, these will be running on VMware virtual machines.
Since the current installations are so old, we are planning on dumping out the data and creating fresh installations on the new systems. Based on the advice I got from Ronald Bradford and Sheeri Cabral, we are also taking this opportunity to switch to InnoDB and utf8, rather than MyISAM and latin1 that are currently used.
We are using the MySQL yum repository for the installation, so we can be on the latest MySQL version, rather than that shipped as part of Oracle Linux (or RHEL) 6.5. The other neat thing about this is it takes care of point release upgrades as part of the “yum update” process.
So far all my testing has been done on VMs running on my PC, but we are soon going to start rolling this out. It should be an interesting piece of work. The developers are doing a bunch of testing with InnoDB and utf8 to see what issues we come up against…
Update. For those new to MySQL, you might like to read this post by Patrick Hurley.
For those of you using Oracle Linux with UEK3, here are a couple of important blog posts that may have passed you by.
Following on from my recent batch of “what I’m doing at the moment” style posts, I just thought I would mention some of the infrastructure I’ve been installing and configuring recently…
We are still part way through a migration from Oracle Application Server to WebLogic 11g. There are many applications to migrate and test, fortunately not by me, but they fit into two main categories.
Some of our high profile applications of each type are already running in production on WebLogic and the general feedback has been very positive. I guess most of this comes down to the hardware refresh.
There are still a few more apps to migrate, but everything is pretty close to the end of testing now, so hopefully it won’t be long before we can say a not-so-fond farewell to Oracle Application Server!
All of these WebLogic installations are running on top of Oracle Linux 6 inside VMware virtual machines. So far we’ve seen nothing untoward about this setup and I would have no reservations about recommending this approach to others.
If you have any questions/concerns about Oracle Linux, you might want to read my Oracle Linux : Frequently Asked Questions article. If you have any concerns about Oracle’s stance as far as VMware support goes, you might want to read this.
Following from yesterday’s post about Cloud Control 12cR3, Oracle Linux and VMware, I thought I would just mention something I put live yesterday evening.
We have a 3rd party Java-based application that runs on Tomcat 7 and Java 7 that until recently was running on RHEL5 on physical hardware. It runs against an Oracle database, but that is not housed on this server. This application is not that big, but it is *very* high profile as it is what we use to process our REF submissions. If you know anything about higher education in the UK, you’ll know that REF is a very big deal, especially as we are within a couple of months of the next submission.
As I mentioned in February, like many of our systems, the resource utilization on the physical hardware was not optimal. We had this single Java app running on a server with 64G RAM and 12 cores, when it was probably using at most 6G and 2 cores. What’s more, there were two physical servers of this specification to provide manual failover, as the vendor does not support any form of clustering for automated failover.
What I did late yesterday was move this across to a VMware virtual machine running Oracle Linux 6. The benefits of this being:
- We can allocate just the resources we need. The existing physical boxes will be plugged into the VMware cluster and their resources used for something more useful than sitting around doing nothing.
- We can now use VMware’s HA functionality to provide automatic failover, giving us enough high availability for our needs.
- Using Oracle Linux gives us a variety of support options, starting from $0 upward.
IMHO this is another classic no-brainer as far as choosing a virtualized environment over physical and gets me one step closer to my vision for our systems…
If you are considering moving stuff to VMware and/or Oracle Linux, you might like to read these posts.
I mentioned some time ago that I was pushing my current company to move much of their gear on to VMware, mostly because of poor resource utilization on many of the servers. That process is still under way.
One thing I wanted to mention specifically was our use of Cloud Control 12cR3. Up until recently, we were using physical kit for this. We had an 11.2 database on HP-UX, With HA provided by HP Service Guard. We had two management servers on physical kit running RHEL5 pointing at this Service Guard package to give us some resiliency in of the OMS. It worked, but it was over complicated and I was never really happy with it for a number of reasons:
- HP-UX for the databases : I know some of you guys love it, but I don’t.
- Two management servers : Seems like a waste of kit to me. We either have them on their own boxes and waste lots of resources, or have multiple installations on those boxes, which adds to complexity and management of the kit.
- RHEL : Why pay for RHEL when we can use Oracle Linux and decide for ourselves if we want to pay for the extra features support gives us, or just use it for free?
So what are we running now? We have one VMware VM, running Oracle Linux 6. That has both the Oracle 11.2 database for the repository and the Cloud Control 12cR3 OMS running on it. We use VMware functionality for the HA of this system.
Why do I like this situation?
- Cloud Control is a complicated beast and I am a big fan of KISS (Keep It Simple Stupid). Having everything on a single VM is about as simple as it gets.
- If I am using Cloud Control in this way I pay nothing for the database repository. As soon as you start thinking about RAC or Data Guard to protect your repository you have to pay for Enterprise Edition licenses.
- Using VMware HA functionality gives us good enough HA for our purposes. We can failover or live migrate between hosts in the data centre, or between data centres.
- We can clone the whole installation in a few minutes and use that as a base for upgrades. If something goes wrong, we just flip back.
While I was at Oracle OpenWorld I discussed this a number of times and it seems it is a very common approach.
Another thing that came out of those discussions is many people still misunderstand what Oracle Linux is and the support status of Oracle Linux, and more specifically UEK, on VMware. Suffice to say, it’s all supported, as discussed in my Oracle Linux : Frequently Asked Questions article.
If you are struggling to decide how best to run Cloud Control in your organization, I would recommend using a virtual environment (Oracle VM or VMware) and run it on Oracle Linux 6.
UltraEdit 4.0 has been released for Mac and Linux. The downloads are in the usual place. You can see the latest changelogs here (Mac, Linux).
Fun, fun, fun…
For those eager beavers out there, you can now get hold of Fedora 19 Alpha from the pre-release location.
The release notes can be found here. I’m keen to check out the improvements to MATE in version 1.6, as this is now my standard desktop.
Update: It installs in Oracle VirtualBox and the guest additions install correctly, so it’s looking good so far.
I mentioned in a previous post that my company were planning to move all of our middle tier infrastructure and some of our Oracle databases to Oracle Linux running on a virtual infrastructure. That process is now underway.
Persuading the company to ditch Red Hat Enterprise Linux (RHEL) in favor of Oracle Linux took a bit of effort, partly due to some Fear, Uncertainty and Doubt (FUD) spread by one of the vendors we use. In the process of trying to counter the FUD I put together an Oracle Linux FAQ document. I thought it might come in handy for anyone else in a similar position, so I thought I would make it available on my site.
As I say at the top of the article, this includes some of my opinions as well as facts. This made me a little nervous, so I thought I would run it by an expert before I let it loose. Big thanks to Lenz Grimmer for giving the article the once-over. His corrections and suggestions were very welcome!
In a previous post I said that UltraEdit moves through beta really quickly. Today I’m rocking UltraEdit v4.0 Release Candidate on Fedora 18…
Last year I wrote an article about the installation of Oracle Forms and Reports Services 11gR2 on Oracle Linux 5. I’ve now written the article for Oracle Forms and Reports Services 11gR2 on Oracle Linux 6. The latest patch of F&RS is certified for OL6, along with JDK6 and JDK7.
In addition to the installation articles, I’ve compiled a collection of random notes about post-installation configuration into a separate article. I keep adding to it every time I come across a new (for me) issue.
I’m hoping this will stop me falling into the trap I did with AS10g, where I didn’t write down any of this stuff, assuming I would remember it, only to find I couldn’t remember Jack a few years later.