MixingLight – Virtualizing Your Networked Resolve Database Server on Linux

Unless you’ve lived under a rock for the past decade – it’s pretty likely you’ve at least heard of the term virtualization. Even if you don’t use it directly – you’ve certainly used it indirectly while using almost any online service.

Virtualization is the the process of running a virtual computer inside a physical one. Multiple virtual machines can run on a single host machine. This makes it possible to maximize the hardware of a single computer, running multiple operating systems and services at the same time. It is also how almost all datacenter and cloud applications are hosted today.

Virtualized Database Servers For Resolve

Resolve’s project database runs on a industry standard Postgres database platform. This means it can be hosted on just about any computer, and it barely uses any resources. This also makes it a perfect use-case for virtualization. Many colorists already have NAS machines that support running virtual machines. If you don’t have a NAS that supports virtualization, you may have a spare computer that is doing something else that does.

Hosting your Resolve Database in a virtual machine is a great way to maximize hardware that you may already have! In my home studio, I run my database in VMWare. At our office at DC Color, we run it on our big TrueNAS server, and at Pat’s facility, he runs it on his TrueNAS Mini XL+.

The Process

First, you will need a hypervisor. This is the software that runs and manages virtual machines. In this Insight – i’ll be using Oracle Virtualbox – an opensource hypervisor that runs on desktop operating systems. Other options include the built-in hypervisors in TrueNAS, Synology, QNAP and other NAS servers. You can also use dedicated, bare-metal hypervisors like VMWare or ProxMox.

Every hypervisor is a little different – but the general options for configuring a virtual machine are the same. In this Insight, I’ll show you how to:

• Set up and configure virtual machine options
• Download and install CentOS Linux
• Install and configure Postgres server on CentOS for use with Resolve
• Use Resovle to create and connect to databases on the new virtual server

Command Reference

This Insight features a lot of command-line interaction – so a general understanding of Linux is recommended. Don’t worry – since the server is virtual, you won’t break anything. If you get it wrong – you can just delete it and start fresh. This makes virtual machines a great way to dip your feet into Linux without a lot of risk.

To make it easier to follow along – I’ve also included all the commands I used as a reference. Just know that these may be different in other linux distributions or versions.

DOWNLOAD LINK: MixingLight – Virtualizing Your Networked Resolve Database Server on Linux