Introduction
This document details the process for deploying the OpenLink Virtuoso Bring-Your-Own-License (BYOL) Edition Marketplace Offer for the Google Cloud.
Prerequisites
- A Google Cloud subscription account
- A Virtuoso License purchased from our Online Store or via an Account Manager
Deployment from Google Marketplace Offer
- From the Google Marketplace search for the keywords
OpenLink
orVirtuoso
to locate the available Virtuoso BYOL offer:
- Click on the
Launch
button to start the subscription and deployment of the BYOL offer.
- Set a
Deployment name
and appropriateMachine type
for VM deployment, accept the agreement by selecting the check box and then click on theDEPLOY
button
- The deployment is in progress:
- The following screen is displayed when the deployment is complete:
Administering Virtuoso Instance via SSH
- Click on the
SSH
drop down list box as in the screenshot below:
- Select the
Open in browser window
item from the dropdown list box to start an SSH connection to the VM and click on theAuthorize
button:
- Authenticate as your google
user
account:
- The
SSH
connection to the VM completes:
- Being a BYOL VM, the next step is to copy the acquired Virtuoso license file to the VM using the
scp
or other command along the following lines:scp {local-virtuoso-license-file} {username}@{vm-host}:/{destination-folder}/
- Once connected it is strongly recommended to update the VM to get the latest operating system and Virtuoso updates with the command:
sudo apt-get upgrade
- Run the following command to enable the Virtuoso instance to auto-start on reboot:
sudo systemctl virtuoso enable
- Copy the
virtuoso.lic
license file to the/etc/oplmgr
directory for use by the Virtuoso instance:
sudo cp virtuoso.lic /etc/oplmgr
- The following commands can be used to Administer the Virtuoso server:
- Start the Virtuoso Server:
sudo service virtuoso start
- Stop the Virtuoso Server:
sudo service virtuoso stop
- Restart the Virtuoso Server:
sudo service virtuoso restart
- Check status of Vrtuoso Server:
sudo service virtuoso status
- Check the Virtuoso server is automatically started post deployment with the command:
sudo service virtuoso status
- Determine the random password set for the
dba
user with the command:
sudo cat /opt/virtuoso/database/.initial-password
- A
SQL
connection can then be made to the Virtuoso instance with theisql
command line tool on port1111
with the command :
isql 1111
Accessing the Virtuoso Instance via HTTP
- Determine the
External IP Address
of the VM from the google cloud console:
- The Virtuoso HTTP server can then be accessed on
http://{External IP Address}:8890
:
- Click on the
Conductor
link in the left frame to access the Virtuoso Conductor Admin UI.
- Use the Virtuoso
dba
user and password determined previously to login to the Conductor
Performance Tuning
There are a range of Google VM instance types with different system memory and CPU combinations. Collectively, the factors above affect the performance of your Virtuoso instance. Thus, use Google VM Instance Type
s with more memory and CPU cores for best performance.
Note: This VM is configured to use minimal system memory. For the instance type chosen, the NumberOfBuffer
and MaxDirtyBuffers
parameters in the /opt/virtuoso/database/virtuoso.ini
configuration file should be increased to match the available memory, as detailed in the Virtuoso Performance Tuning Guide, for example –
VM Instance Type | System RAM | Number Of Buffers | Max Dirty Buffers |
---|---|---|---|
n2d-standard-2 |
8 GB | 680000 | 500000 |
n2d-standard-4 |
16 GB | 1360000 | 1000000 |
n2d-standard-8 |
32 GB | 2720000 | 2000000 |
n2d-standard-16 |
64 GB | 5450000 | 4000000 |
– and the Virtuoso server restarted as detailed above.
Extrapolate the NumberOfBuffer
and MaxDirtyBuffers
parameters accordingly for different sized VMs.
Troubleshooting
If the Virtuoso server fails to start:
- Run the command
sudo service virtuoso status
to see if the Virtuoso server is running - Check the
/opt/virtuoso/database/virtuoso.log
file to see why the server might have failed to start - Ensure there file
/opt/virtuoso/database/virtuoso.lck
does not exist before starting the server - Attempt to start the Virtuoso server with the command
sudo service virtuoso start
- Run the command
sudo service virtuoso status
again to see if the Virtuoso server is running - If it is now running attempt a connect via the
SQL
orHTTP
interfaces are detailed above