- Log in to AWS
- Go to a sensible region
- Start a new instance with Ubuntu Trusty (14.04) - compute-optimised instances have a high vCPU:memory ratio, and the lowest-cost CPU time.
c4.2xlarge
is a decent choice. - Set security group (firewall) to have ports 22, 80, and 443 open (SSH, HTTP, HTTPS)
- If you want a static IP address (for long-running instances) then select Elastic IP for this VM
- If you want to use HTTPS, you'll probably need a paid certificate, or to use Amazon's Route 53 to get a non-Amazon domain (to avoid region blocking).
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
public SomeConstructor(){ | |
this.dataSource = initDatasource("jdbc/mysqldb01"); | |
} | |
private static DataSource initDatasource(String jndi){ | |
try { | |
javax.naming.Context ctx = new InitialContext(); | |
// relative to standard JNDI root for J2EE app | |
javax.naming.Context envCtx = (javax.naming.Context) ctx.lookup( "java:comp/env" ); | |
return (DataSource) envCtx.lookup( jndi ); |
This file contains hidden or bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
--drop table ContainerSearch; | |
drop table VerDatasetMetaString ; | |
drop table VerDatasetMetaNumber ; | |
drop table VerDatasetMetaTimestamp ; | |
drop table DatasetGroupMetaString ; | |
drop table DatasetGroupMetaNumber ; | |
drop table DatasetGroupMetaTimestamp ; |