This HTML5 document contains 61 embedded RDF statements represented using HTML+Microdata notation.

The embedded RDF content will be recognized by any processor of HTML5 Microdata.

Subject Item

n7:this

foaf:made

n2:VirtPayAsYouGoEBSBackedAMI

Subject Item

n16:item

n15:services_of

n2:VirtPayAsYouGoEBSBackedAMI

Subject Item

n24:this

sioc:creator_of

n2:VirtPayAsYouGoEBSBackedAMI

Subject Item

n4:ODS

sioc:container_of

n2:VirtPayAsYouGoEBSBackedAMI

atom:entry

n2:VirtPayAsYouGoEBSBackedAMI

atom:contains

n2:VirtPayAsYouGoEBSBackedAMI

Subject Item

n2:VirtPayAsYouGoEBSBackedAMI

rdf:type

sioct:Comment atom:Entry

dcterms:created

2017-06-13T06:05:34.109086

dcterms:modified

2017-06-29T07:34:24.116628

rdfs:label

VirtPayAsYouGoEBSBackedAMI

foaf:maker

n7:this n25:this

dc:title

VirtPayAsYouGoEBSBackedAMI

opl:isDescribedUsing

n14:rdf

sioc:has_creator

n23:this n24:this

sioc:attachment

n9:jpg n10:jpg

sioc:content

%META:TOPICPARENT{name="VirtInstallationEC2"}% ---+ Deploying the Virtuoso Pay As You Go (PAGO) EBS-backed EC2 AMI %TOC% ---++Introduction In addition to the [[VirtInstallationEC2][Instance-backed EC2 AMI]] that has been in existence since 2008, Virtuoso is now also available as an EBS-backed EC2 AMI based on your choice of License Model -- * [[VirtEBSBackedBYOLAMI][Bring You Own License, or BYOL]] * Pay As You Go, or PAGO (documented here) With either License Model, you will be starting with a preconfigured Virtuoso instance. The fundamental benefits provided by this type of AMI include: * Virtuoso DBMS Server is preinstalled with basic tuning for the host operating system. * You can start and stop this Virtuoso instance without having to terminate its host AMI. * With the hourly model, you pay only for the time the AMI is used. ---++ Prerequisites * An [[https://aws-portal.amazon.com/gp/aws/developer/registration/index.html/103-7399647-0537426?][Amazon Web Services]] (AWS) account. * Recently created AWS accounts will have been automatically signed up for the [[http://www.amazon.com/b/ref=sc_fe_l_2?ie=UTF8&node=201590011&no=3435361&me=A36L942TSJ2AJA][Amazon S3 and EC2 Web Service]]. If you created your AWS account a long time ago, you may now need to manually sign up for these services. * Ensure a AWS <code>security group</code> allowing access to ports 22 (SSH) and 80 (HTTP) is used. ---++ Instantiating & Using Virtuoso 7.2 PAGO Enterprise Edition via Web Interface 1 Use one-click or aws-console (at <code>[[https://console.aws.amazon.com/][https://console.aws.amazon.com/]]</code>) launch options to start the <b>Virtuoso Universal Server 7.2 (Enterprise-- Cloud PAGO Edition)</b> %BR%%BR%<a href="%ATTACHURLPATH%/Virt72AMI-PAGO.jpg"><img src="%ATTACHURLPATH%/Virt72AMI-PAGO.jpg" alt="EC2 instance launch dialog, PAGO" style="max-width: 600px ; min-width: 200px ; width: 50%"></a>%BR%%BR% ---++ First-time Setup & Usage Notes These steps are only necessary immediately after instantiating the AMI, when you start the Virtuoso Database for the first time. This section may subsequently be ignored, as it is not necessary after AMI reboots. 1 <code>ssh</code> into your instantiated AMI using: <verbatim> ssh -i {secure-pem-file} ec2-user@{amazon-ec2-dns-name-or-ip-address} </verbatim> 1 Start the Virtuoso DBMS Server against the DBpedia Database by issuing the command: <verbatim> sudo /etc/rc.d/init.d/virtuoso restart </verbatim> 1 Retrieve the AMI <code>instance-id</code> from the AMI properties presented by the Amazon AWS console UI, or by executing the following in the Linux shell: <verbatim> curl http://169.254.169.254/latest/meta-data/instance-id </verbatim> 1 Go to <b><code><nowiki>http://{amazon-ec2-ami-dns-name-or-ip-address}/conductor</nowiki></code></b> -- to change the default password of this instance. 1 At the authentication challenge, log in as the <b><code>dba</code></b> user, with the AMI <b><code>instance-id</code></b> as the password. 1 Change the password for the '<code>dba</code>' user. ---++ Administering Virtuoso Instance via SSH All scripts for starting and stopping the Virtuoso instance are found in the following locations -- * <b><code><nowiki>/etc/rc.d/init.d</nowiki></code></b> -- scripts that enable automatic database server instantiation at operating system (AMI) boot or reboot time * <b><code><nowiki>/opt/virtuoso</nowiki></code></b> -- scripts for starting and stopping the database server within a running operating system (AMI) ---+++OpenLink License Manager * Start the License Manager: <verbatim> /etc/rc.d/init.d/oplmgr start </verbatim> * Stop the License Manager <verbatim> /etc/rc.d/init.d/oplmgr stop </verbatim> * Restart the License Manager <verbatim> /etc/rc.d/init.d/oplmgr restart </verbatim> ---+++Virtuoso the Server * Start the Virtuoso Server: <verbatim> /etc/rc.d/init.d/virtuoso start </verbatim> * Stop the Virtuoso Server: <verbatim> /etc/rc.d/init.d/virtuoso stop </verbatim> * Restart the Virtuoso Server: <verbatim> /etc/rc.d/init.d/virtuoso restart </verbatim> ---++Virtuoso Database Instance Interaction 1 Set the Virtuoso environment variables by running the command <verbatim> . /opt/virtuoso/virtuoso-enterprise.sh </verbatim> 1 Run the Virtuoso "<b><code>isql</code></b>" command line tool to connect to the database. Note: your EC2 AMI's <b>instance-id</b> will be the <code>dba</code> user's password, until you change it. <verbatim> $ isql 1111 -U dba -P i-123abc321 Connected to OpenLink Virtuoso Driver: 07.10.3214 OpenLink Virtuoso ODBC Driver OpenLink Interactive SQL (Virtuoso), version 0.9849b. Type HELP; for help and EXIT; to exit. SQL> </verbatim> 1 Run the "<b><code>tables</code></b>" command to obtain a list of tables in the default schema <verbatim> SQL> tables; Showing SQLTables of tables like 'NULL.NULL.NULL', tabletype/colname like 'NULL' TABLE_QUALIFIER TABLE_OWNER TABLE_NAME TABLE_TYPE REMARKS VARCHAR VARCHAR VARCHAR VARCHAR VARCHAR _______________________________________________________________________________ DB DBA ADMIN_SESSION SYSTEM TABLE NULL DB DBA ADM_OPT_ARRAY_TO_RS_PVIEW SYSTEM TABLE NULL DB DBA ADM_XML_VIEWS SYSTEM TABLE NULL . . . DB DBA SYS_SQL_INVERSE SYSTEM TABLE NULL DB DBA SYS_TRIGGERS SYSTEM TABLE NULL DB DBA SYS_VIEWS SYSTEM TABLE NULL 209 Rows. -- 1890 msec. SQL> </verbatim> 1 You can stop the Virtuoso Database Server by running: <verbatim> virtuoso-stop.sh </verbatim> 1 You can restart the Virtuoso Database Server by running: <verbatim> virtuoso-start.sh </verbatim> ---++ Performance Notes In regards to performance, please be aware of the following: 1 We currently bundle a 10 Database Sessions and 4 CPU Affinity license with this AMI -- Database & CPU Affinity upgrade licenses are available as upgrade options. 1 There are a range of AMIs choices covering system memory and CPU combination. Collectively, the factors above affect the performance of your DBpedia instance. Thus, use <code> EC2 Instance Type</code>s with more memory and CPU cores for best performance. *Note* by default this AMI is configured to run on a <code>m3.large</code> EC2 Instance Type, thus if a larger EC2 Instance Type is chosen then the <code><nop>NumberOfBuffer</code> and <code><nop>MaxDirtyBuffers</code> parameters in the <code>/opt/virtuoso/dbpedia/dbpedia.ini</code> configuration file, should be increased to the available memory as detailed in the [[http://virtuoso.openlinksw.com/dataspace/doc/dav/wiki/Main/VirtRDFPerformanceTuning#General%20Memory%20Usage%20Settings][Virtuoso Performance Tuning Guide]]: | *EC2 Instance Type* | *System RAM* | *NumberOfBuffers* | *MaxDirtyBuffers* | | m3.large | 7 GB | 680000 | 500000 | | r3.large | 15 GB | 1360000 | 1000000 | | r3.xlarge | 30.5 GB | 2720000 | 2000000 | | r3.2xlarge | 61 GB | 5450000 | 4000000 | and the Virtuoso server restarted as detailed above. ---++ Troubleshooting If you are unable to start your Virtuoso instance as described in the installation and usage steps above, please perform the following steps to get your instance running: 1 cd to <code><b>/opt/virtuoso</code></b> 1 execute: <code><b>. ?./*ent*?.sh</code></b> 1 cd to <code><b>/opt/virtuoso/database</code></b> 1 execute: <code><b>virtuoso -c virtuoso -f</code></b> If successful, you can retry the alternative options such as: * <code><b>/etc/init.d/virtuoso restart</code></b> * <code><b>/etc/init.d/virtuoso start</code></b> ---++ Related Items * [[http://ods.openlinksw.com/wiki/ODS/ODSInstallationEC2][OpenLink Data Spaces Installation]] * EC2 &amp; AMI related information * [[VirtPayAsYouGoEBSBackedAMIDBpedia2015][Virtuoso DBpedia 2015 Pay As You Go (PAGO) EBS-backed EC2 AMI]] * [[VirtInstallationEC2][Instance-backed Virtuoso EC2 AMI]] * [[VirtAWSPublicDataSets][Pre-configured &amp; Pre-loaded Virtuoso instances (DBpedia, BBC Music &amp; Programmes etc.)]] * [[VirtEC2AMINeuroCommonsInstall][Creating Your Own Neurocommons Instance]] * [[VirtEC2AMIBio2rdfInstall][Creating Your Own Bio2RDF Instance]] * [[VirtEC2AMIMusicBrainzInstall][Creating Your Own MusicBrainz Instance]] * [[VirtEc2ExtensionUI][Backup Your Virtuoso EC2 AMI to S3]] * [[VirtEC2AMIElasticBlockStorageConfig][Configure your Virtuoso EC2 AMI for use with Amazon Elastic Block Storage (EBS)]] * [[http://calculator.s3.amazonaws.com/calc5.html][Amazon-provided AWS Simple Monthly Cost Calculator]] * Protecting your Virtuoso-hosted SPARQL Endpoint * [[VirtSPARQLEndpointProtection][Safeguarding your Virtuoso-hosted SPARQL Endpoint]] * [[VirtTipsAndTricksGuideSPARQLEndpointProtection][SPARQL Endpoint Protection Methods Collection]] * [[VirtTipsAndTricksGuideSPARQLEndpoints][Securing SPARQL endpoints]] * [[VirtSPARQLSecurityWebID][WebID Protocol &amp; SPARQL Endpoint ACLs Tutorial]] * [[VirtOAuthSPARQL][SPARQL OAuth Tutorial]] * [[http://docs.openlinksw.com/virtuoso/][Virtuoso documentation]] * [[http://docs.openlinksw.com/virtuoso/rdfsparql.html][Virtuoso's SPARQL support]] * [[VirtTipsAndTricksGuide][Virtuoso Tips and Tricks]] * [[VirtSPARQLDET][SPARQL Endpoint DET (DEV Extension Type) Configuration Guide]] CategoryHowTo CategoryODS CategoryVirtuoso CategoryDocumentation CategoryEC2 %VOSCOPY%

sioc:id

9d9b0cde0a57faf29b97c5e196791398

sioc:link

n2:VirtPayAsYouGoEBSBackedAMI

sioc:has_container

n4:ODS

n15:has_services

n16:item

atom:title

VirtPayAsYouGoEBSBackedAMI

sioc:links_to

n5:VirtEC2AMINeuroCommonsInstall n5:VirtEC2AMIBio2rdfInstall n5:VirtPayAsYouGoEBSBackedAMIDBpedia2015 n5:VirtAWSPublicDataSets n5:NumberOfBuffers n5:MaxDirtyBuffers n5:VirtInstallationEC2 n5:VirtSPARQLDET n5:VirtEBSBackedBYOLAMI n5:VirtSPARQLSecurityWebID n2:CategoryODS n12: n17:html n5:OpenLink n18:html n20: n22:Settings n2:CategoryDocumentation n2:CategoryVirtuoso n5:VirtSPARQLEndpointProtection n5:VirtTipsAndTricksGuideSPARQLEndpointProtection n2:CategoryHowTo n26:ODSInstallationEC2 n27:A36L942TSJ2AJA n29: n5:VirtEC2AMIElasticBlockStorageConfig n5:CategoryEC2 n5:VirtEC2AMIMusicBrainzInstall n5:VirtTipsAndTricksGuideSPARQLEndpoints n5:VirtEc2ExtensionUI

atom:source

n4:ODS

atom:author

n7:this

atom:published

2017-06-13T06:05:34Z

atom:updated

2017-06-29T07:34:24Z

sioc:topic

n4:ODS

Subject Item

n23:this

sioc:creator_of

n2:VirtPayAsYouGoEBSBackedAMI