List of usage examples for com.amazonaws.services.rds.model CreateDBInstanceRequest CreateDBInstanceRequest
public CreateDBInstanceRequest()
From source file:RDSManager.java
public String createRDS() { String endPointAddr = null;/*from www . j av a2 s . c o m*/ try { System.out.println("Creating RDS"); CreateDBParameterGroupRequest cdpgr = new CreateDBParameterGroupRequest(); cdpgr.setDBParameterGroupName(DB_PARAM_GROUP_NAME); cdpgr.setDescription(DB_PARAM_GROU_DESC); cdpgr.setDBParameterGroupFamily(DB_PARAM_GROUP_FAMILY); rds.createDBParameterGroup(cdpgr); Collection<Parameter> parameters = new ArrayList<Parameter>(); parameters.add(new Parameter().withParameterName("max_connections").withParameterValue("200") .withApplyMethod("immediate")); parameters.add(new Parameter().withParameterName("max_allowed_packet").withParameterValue("999999") .withApplyMethod("immediate")); rds.modifyDBParameterGroup(new ModifyDBParameterGroupRequest() .withDBParameterGroupName(DB_PARAM_GROUP_NAME).withParameters(parameters)); /// create configuration of instance CreateDBInstanceRequest cdbir = new CreateDBInstanceRequest(); cdbir.setEngine(RDS_ENGINE); cdbir.setEngineVersion(ENGINE_VERSION); cdbir.setLicenseModel(LICENSE_MODEL); cdbir.setAutoMinorVersionUpgrade(AUTO_MINOR_VERSION_UPGRADE); cdbir.setDBInstanceClass(DB_INSTANCE_TYPE); cdbir.setMultiAZ(MULTI_AZ); cdbir.setAllocatedStorage(ALLOCATED_STORAGE); cdbir.setDBInstanceIdentifier(DBInstanceIdentifier); cdbir.setMasterUsername(MASTER_USER_NAME); cdbir.setMasterUserPassword(MasterUserPassword); cdbir.setDBName(DB_NAME); cdbir.setPort(DB_PORT); cdbir.setBackupRetentionPeriod(BackupRetentionPeriod); cdbir.setPubliclyAccessible(PubliclyAccessible); cdbir.setDBParameterGroupName(DB_PARAM_GROUP_NAME); ArrayList<String> arrDbSecur = new ArrayList<String>(); arrDbSecur.add(SECURITY_GROUP_NAME); cdbir.setDBSecurityGroups(arrDbSecur); System.out.println("Creating RDS DB Instance"); // creating instance DBInstance dbi = rds.createDBInstance(cdbir); // wait till instance created boolean isWaiting = true; while (isWaiting) { Thread.sleep(30000); DescribeDBInstancesRequest request = new DescribeDBInstancesRequest(); request.setDBInstanceIdentifier(dbi.getDBInstanceIdentifier()); DescribeDBInstancesResult result = rds.describeDBInstances(request); List<DBInstance> d = result.getDBInstances(); Iterator<DBInstance> i = d.iterator(); while (i.hasNext()) { DBInstance d1 = i.next(); System.out.println("RDS Status : " + d1.getDBInstanceStatus()); if (d1.getDBInstanceStatus().equals("available")) { isWaiting = false; System.out.println("RDS Endpoint Address : " + d1.getEndpoint().getAddress()); endPointAddr = d1.getEndpoint().getAddress(); } } } } catch (Exception e) { e.printStackTrace(); } return endPointAddr; }
From source file:beanstalk.BeansDatabase.java
License:Apache License
public DatabaseObject createDatabase(String AWSKeyId, String AWSSecretKey, String dbname, String dbType, String dbIdentifier, String dbClass, int dbSize, String dbUser, String dbPassword) {//throws Exception { DatabaseObject dbobj = new DatabaseObject(); String endpoint_str = ""; BasicAWSCredentials basic_credentials = new BasicAWSCredentials(AWSKeyId, AWSSecretKey); AmazonRDSClient rDSClient = new AmazonRDSClient(basic_credentials); //Minimum size per db type, as described in API Reference if (dbType != null && dbType.equalsIgnoreCase("MySQL") && dbSize < 5) { dbSize = 5;/* w w w . ja v a2 s . c om*/ } if (dbType != null && (dbType.equalsIgnoreCase("oracle-se1") || dbType.equalsIgnoreCase("oracle-se") || dbType.equalsIgnoreCase("oracle-ee")) && dbSize < 10) { dbSize = 10; } CreateDBInstanceRequest create_dbinstance = new CreateDBInstanceRequest(); create_dbinstance.setDBName(dbname); create_dbinstance.setEngine(dbType); create_dbinstance.setMasterUsername(dbUser); create_dbinstance.setMasterUserPassword(dbPassword); create_dbinstance.setDBInstanceIdentifier(dbIdentifier); create_dbinstance.setAllocatedStorage(dbSize);//min size =5GB for mysql,10gb for oracle create_dbinstance.setDBInstanceClass("db.m1.small");//db.m1.small//db.m1.large//db.m1.xlarge//db.m2.xlarge//db.m2.2xlarge//db.m2.4xlarge.... String group = "c4sallowallipgroup"; Vector sec_groups = new Vector(); sec_groups.add(group); create_dbinstance.setDBSecurityGroups(sec_groups); DBInstance dbInstance_create = new DBInstance(); System.out.println("will call createDBInstance"); try { dbInstance_create = rDSClient.createDBInstance(create_dbinstance); } catch (AmazonClientException amazonClientException) { System.out.println("Error in Database Creation."); } System.out.println("called createDBInstance"); String status = ""; System.out.println("called createDBInstance"); //wait 5 minutes for the first time int busyWaitingTime = 3000;//3sec //int busyWaitingTime=300000; //int busyWaitingTime=40000; while (!status.equalsIgnoreCase("available")) { System.out.println("just got inside while"); try { System.out.println("preparing for sleep"); Thread.sleep(busyWaitingTime); System.out.println("woke up"); } catch (InterruptedException ex) { Logger.getLogger(BeansDatabase.class.getName()).log(Level.SEVERE, null, ex); } DescribeDBInstancesRequest describeDBInstancesRequest = new DescribeDBInstancesRequest(); describeDBInstancesRequest.setDBInstanceIdentifier(dbname + "cloud4soaid"); //describeDBInstancesRequest.setDBInstanceIdentifier("c4sdb2cloud4soaid"); DBInstance dbInstance = new DBInstance(); System.out.println("will call describeDBInstances"); DescribeDBInstancesResult describeDBInstances = rDSClient .describeDBInstances(describeDBInstancesRequest); System.out.println("called describeDBInstances"); List<DBInstance> dbInstances = describeDBInstances.getDBInstances(); System.out.println("size--->" + dbInstances.size()); System.out.println("status--->" + dbInstances.get(0).getDBInstanceStatus()); System.out.println("dbname--->" + dbInstances.get(0).getDBName()); dbobj.setDbhost(dbInstances.get(0).getDBInstanceStatus()); if (dbInstances.get(0).getEndpoint() != null) { System.out.println("endpoint--->" + dbInstances.get(0).getEndpoint().getAddress()); System.out.println("port--->" + dbInstances.get(0).getEndpoint().getPort()); System.out.println("all--->" + dbInstances.get(0).toString()); dbobj.setDbhost(dbInstances.get(0).getEndpoint().getAddress()); dbobj.setDbname(dbInstances.get(0).getDBName()); dbobj.setPort(dbInstances.get(0).getEndpoint().getPort()); status = dbInstances.get(0).getDBInstanceStatus(); //after the first 5 minutes test every minute busyWaitingTime = 60000; } } System.out.println("just got outside while"); System.out.println( "just got outside while and endpoint is :" + dbobj.getDbhost() + ", name is " + dbobj.getDbname()); /* * * DescribeDBInstancesRequest describeDBInstancesRequest = new * DescribeDBInstancesRequest(); * * describeDBInstancesRequest.setDBInstanceIdentifier(dbname + * "cloud4soaid"); * //describeDBInstancesRequest.setDBInstanceIdentifier("c4sdb2cloud4soaid"); * DBInstance dbInstance = new DBInstance(); * * System.out.println("will call describeDBInstances"); * DescribeDBInstancesResult describeDBInstances = * rDSClient.describeDBInstances(describeDBInstancesRequest); * System.out.println("called describeDBInstances"); * * List<DBInstance> dbInstances = describeDBInstances.getDBInstances(); * * System.out.println("size--->" + dbInstances.size()); * System.out.println("status--->" + * dbInstances.get(0).getDBInstanceStatus()); * System.out.println("dbname--->" + dbInstances.get(0).getDBName()); * dbobj.setDbhost(dbInstances.get(0).getDBInstanceStatus()); * * * if(dbInstances.get(0).getEndpoint()!=null){ * * * System.out.println("endpoint--->" + * dbInstances.get(0).getEndpoint().getAddress()); * System.out.println("port--->" + * dbInstances.get(0).getEndpoint().getPort()); * System.out.println("all--->" + dbInstances.get(0).toString()); * * dbobj.setDbhost(dbInstances.get(0).getEndpoint().getAddress()); * dbobj.setDbname(dbInstances.get(0).getDBName()); * dbobj.setPort(dbInstances.get(0).getEndpoint().getPort()); } */ return dbobj; }
From source file:com.amazon.aws.myyoutube.videoUtil.GetRDSInstance.java
License:Open Source License
public static void main(String[] args) throws Exception { credentials = new PropertiesCredentials( GetRDSInstance.class.getResourceAsStream("AwsCredentials.properties")); try {/*www .ja v a 2 s .c om*/ rds = new AmazonRDSClient(credentials); /********************************************* * RDS DB *********************************************/ System.out.println("Creating a database instance"); CreateDBSecurityGroupRequest d = new CreateDBSecurityGroupRequest() .withDBSecurityGroupName("javaSecurityGroup1") .withDBSecurityGroupDescription("DB security group1"); rds.createDBSecurityGroup(d); AuthorizeDBSecurityGroupIngressRequest auth = new AuthorizeDBSecurityGroupIngressRequest() .withDBSecurityGroupName("javaSecurityGroup1") // .withEC2SecurityGroupName("javaSecurityGroup") .withCIDRIP("0.0.0.0/0"); // .withCIDRIP("216.165.95.69/32"); DBSecurityGroup dbsecuritygroup = rds.authorizeDBSecurityGroupIngress(auth); String[] dBSecurityGroups = { dbsecuritygroup.getDBSecurityGroupName() }; CreateDBInstanceRequest createDBInstanceRequest = new CreateDBInstanceRequest().withEngine("MySQL") .withLicenseModel("general-public-license").withEngineVersion("5.6.13") .withDBInstanceClass("db.t1.micro").withMultiAZ(false).withAutoMinorVersionUpgrade(true) .withAllocatedStorage(5).withDBInstanceIdentifier("mydbinstance1").withMasterUsername("awsuser") .withMasterUserPassword("mypassword").withDBName("dbname1").withPort(3306) .withAvailabilityZone(null).withDBSecurityGroups(dBSecurityGroups); ArrayList<String> arrDbSecur = new ArrayList<String>(); arrDbSecur.add("javaSecurityGroup1"); createDBInstanceRequest.setDBSecurityGroups(arrDbSecur); DBInstance dbInstance = rds.createDBInstance(createDBInstanceRequest); Thread.sleep(600000); DescribeDBInstancesRequest instRequest = new DescribeDBInstancesRequest() .withDBInstanceIdentifier("mydbinstance1"); DescribeDBInstancesResult instres = rds.describeDBInstances(instRequest); Endpoint e = instres.getDBInstances().get(0).getEndpoint(); System.out.println("ENd point " + e.getAddress() + " " + e.getPort()); System.out.println("Database Created"); System.out.println("Creating a table"); //connection java.sql.Connection con = null; Statement st = null; // Format "jdbc:mysql://" + hostname + ":" + port + "/" + dbName + "?user=" + userName + "&password=" + password; String url = "jdbc:mysql://" + e.getAddress() + ":" + e.getPort() + "/dbname1?user=awsuser&password=mypassword"; // "jdbc:mysql://master:password@"+e+"/dbname"; System.out.println("Url is " + url); String user = "awsuser"; String password = "mypassword"; con = DriverManager.getConnection(url, user, password); System.out.println("Connection created"); java.sql.Statement stat = con.createStatement(); String query = "CREATE TABLE Items ( item_id VARCHAR(200), type INTEGER, quantity INTEGER, user VARCHAR(100), price FLOAT(5,2) );"; stat.execute(query); String query1 = "CREATE TABLE WishList ( user VARCHAR(200), wishlistId VARCHAR(100) );"; stat.execute(query1); } catch (AmazonServiceException ase) { System.out.println("Caught Exception: " + ase.getMessage()); System.out.println("Response Status Code: " + ase.getStatusCode()); System.out.println("Error Code: " + ase.getErrorCode()); System.out.println("Request ID: " + ase.getRequestId()); } }
From source file:com.cloudera.director.aws.rds.RDSProvider.java
License:Apache License
/** * Returns a DB instance request based on the specified template. * * @param template the template * @param virtualInstanceId the virtual instance ID * @return a DB instance request based on the specified template *//* ww w. j a va 2 s .com*/ private CreateDBInstanceRequest buildCreateRequest(RDSInstanceTemplate template, String virtualInstanceId) { CreateDBInstanceRequest request = new CreateDBInstanceRequest().withDBInstanceIdentifier(virtualInstanceId) .withDBInstanceClass(template.getInstanceClass()) .withDBSubnetGroupName(template.getDbSubnetGroupName()) .withVpcSecurityGroupIds(template.getVpcSecurityGroupIds()) .withPubliclyAccessible(associatePublicIpAddresses) .withAllocatedStorage(template.getAllocatedStorage()).withEngine(template.getEngine()) .withMasterUsername(template.getAdminUser()).withMasterUserPassword(template.getAdminPassword()) // masterPassword in AWS SDK 1.9+ .withTags(convertToTags(template.getTags(), template, virtualInstanceId)); if (template.getEngineVersion().isPresent()) { request = request.withEngineVersion(template.getEngineVersion().get()); } if (template.getAvailabilityZone().isPresent()) { request = request.withAvailabilityZone(template.getAvailabilityZone().get()); } if (template.getAutoMinorVersionUpgrade().isPresent()) { request = request.withAutoMinorVersionUpgrade(template.getAutoMinorVersionUpgrade().get()); } if (template.getBackupRetentionPeriod().isPresent()) { request = request.withBackupRetentionPeriod(template.getBackupRetentionPeriod().get()); } if (template.getDbName().isPresent()) { request = request.withDBName(template.getDbName().get()); } if (template.getDbParameterGroupName().isPresent()) { request = request.withDBParameterGroupName(template.getDbParameterGroupName().get()); } if (template.getEngineVersion().isPresent()) { request = request.withEngineVersion(template.getEngineVersion().get()); } if (template.getLicenseModel().isPresent()) { request = request.withLicenseModel(template.getLicenseModel().get()); } if (template.isMultiAZ().isPresent()) { request = request.withMultiAZ(template.isMultiAZ().get()); } if (template.getOptionGroupName().isPresent()) { request = request.withOptionGroupName(template.getOptionGroupName().get()); } if (template.getPort().isPresent()) { request = request.withPort(template.getPort().get()); } if (template.getPreferredBackupWindow().isPresent()) { request = request.withPreferredBackupWindow(template.getPreferredBackupWindow().get()); } if (template.getPreferredMaintenanceWindow().isPresent()) { request = request.withPreferredMaintenanceWindow(template.getPreferredMaintenanceWindow().get()); } if (template.isPubliclyAccessible().isPresent()) { request = request.withPubliclyAccessible(template.isPubliclyAccessible().get()); } if (template.isStorageEncrypted().isPresent()) { request = request.withStorageEncrypted(template.isStorageEncrypted().get()); } return request; }
From source file:com.gs.obevo.amazon.CreateDbInstance.java
License:Apache License
public void createOracle(String dbInstanceIdentifier) throws Exception { // http://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstance.html CreateDBInstanceRequest request = new CreateDBInstanceRequest().withEngine("oracle-se2") //.withEngineVersion("12.1.0.2.v8") .withLicenseModel("license-included").withAllocatedStorage(10).withStorageType("gp2") // SSD .withBackupRetentionPeriod(0).withDBInstanceClass("db.t2.micro") .withDBInstanceIdentifier(dbInstanceIdentifier).withDBName("DBDEPLOY") .withMasterUsername("deploybuilddbo").withMasterUserPassword("deploybuilddb0") //.withVpcSecurityGroupIds("default") ;/*from w ww . ja v a 2 s . c om*/ DBInstance response = client.createDBInstance(request); System.out.println(response); describe(dbInstanceIdentifier); }
From source file:com.gs.obevo.amazon.CreateDbInstance.java
License:Apache License
public void createPostgresql(String dbInstanceIdentifier) throws Exception { // http://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstance.html CreateDBInstanceRequest request = new CreateDBInstanceRequest().withEngine("postgres") .withEngineVersion("9.6.2").withLicenseModel("postgresql-license").withAllocatedStorage(5) .withStorageType("gp2") // SSD .withBackupRetentionPeriod(0).withDBInstanceClass("db.t2.micro") .withDBInstanceIdentifier(dbInstanceIdentifier).withDBName("DBDEPLOY") .withMasterUsername("deploybuilddbo").withMasterUserPassword("deploybuilddb0"); DBInstance response = client.createDBInstance(request); System.out.println(response); describe(dbInstanceIdentifier);// www . j a v a 2 s.co m }
From source file:com.gs.obevo.amazon.CreateDbInstance.java
License:Apache License
private void createSqlServer(String dbInstanceIdentifier) throws Exception { // http://docs.aws.amazon.com/AmazonRDS/latest/APIReference/API_CreateDBInstance.html CreateDBInstanceRequest request = new CreateDBInstanceRequest().withEngine("sqlserver-ex") .withEngineVersion("13.00.2164.0.v1").withLicenseModel("license-included").withAllocatedStorage(20) .withStorageType("gp2") // SSD .withBackupRetentionPeriod(0).withDBInstanceClass("db.t2.micro") .withDBInstanceIdentifier(dbInstanceIdentifier) //.withDBName("DBDEPLOY") .withMasterUsername("deploybuilddbo").withMasterUserPassword("deploybuilddb0"); DBInstance response = client.createDBInstance(request); System.out.println(response); describe(dbInstanceIdentifier);/* w w w. j av a2 s . co m*/ }
From source file:com.kpbird.aws.Main.java
public void createRDS() { try {//from www. j a v a 2 s .c o m log.Info("About to Launch RDS"); log.Info("Createing DB Parameger Group"); CreateDBParameterGroupRequest cdpgr = new CreateDBParameterGroupRequest(); cdpgr.setDBParameterGroupName(DBParameterGroupName); cdpgr.setDescription(DBParameterGroupDescription); cdpgr.setDBParameterGroupFamily(DBParameterGroupFamily); rdsclient.createDBParameterGroup(cdpgr); Collection<Parameter> parameters = new ArrayList<Parameter>(); parameters.add(new Parameter().withParameterName(DBParameterName1).withParameterValue(DBParameterValue1) .withApplyMethod(DBParameterApplyMethod1)); parameters.add(new Parameter().withParameterName(DBParameterName2).withParameterValue(DBParameterValue2) .withApplyMethod(DBParameterApplyMethod2)); rdsclient.modifyDBParameterGroup(new ModifyDBParameterGroupRequest() .withDBParameterGroupName(DBParameterGroupName).withParameters(parameters)); log.Info("Create DB Instance Request"); /// create configuration of instance CreateDBInstanceRequest cdbir = new CreateDBInstanceRequest(); cdbir.setEngine(rdsengine); cdbir.setEngineVersion(EngineVersion); cdbir.setLicenseModel(LicenseModel); cdbir.setAutoMinorVersionUpgrade(AutoMinorVersionUpgrade); cdbir.setDBInstanceClass(DBInstanceClass); cdbir.setMultiAZ(MultiAZ); cdbir.setAllocatedStorage(AllocatedStorage); cdbir.setDBInstanceIdentifier(DBInstanceIdentifier); cdbir.setMasterUsername(MasterUsername); cdbir.setMasterUserPassword(MasterUserPassword); cdbir.setDBName(DBName); cdbir.setPort(Port); cdbir.setBackupRetentionPeriod(BackupRetentionPeriod); cdbir.setPubliclyAccessible(PubliclyAccessible); cdbir.setDBParameterGroupName(DBParameterGroupName); ArrayList<String> arrDbSecur = new ArrayList<String>(); arrDbSecur.add(DBSecurityGroupName); cdbir.setDBSecurityGroups(arrDbSecur); log.Info("Creating RDS DB Instance"); // creating instance DBInstance dbi = rdsclient.createDBInstance(cdbir); // wait till instance created boolean isWaiting = true; while (isWaiting) { Thread.sleep(5000); DescribeDBInstancesRequest request = new DescribeDBInstancesRequest(); request.setDBInstanceIdentifier(dbi.getDBInstanceIdentifier()); DescribeDBInstancesResult result = rdsclient.describeDBInstances(request); List<DBInstance> d = result.getDBInstances(); Iterator<DBInstance> i = d.iterator(); while (i.hasNext()) { DBInstance d1 = i.next(); log.Info("RDS Status : " + d1.getDBInstanceStatus()); if (d1.getDBInstanceStatus().equals("available")) { isWaiting = false; log.Info("RDS Endpoint : " + d1.getEndpoint().getAddress()); } } } } catch (Exception e) { e.printStackTrace(); System.exit(0); } }
From source file:com.vb.services.database.rds.MySQLDBUtils.java
public MySQLDBUtils(AWSCredentialsProvider awsCredentialsProvider) { this.amazonRDSClient = new AmazonRDSClient(awsCredentialsProvider); this.mysqlDB = new MySQLDB(); this.createDBInstanceRequest = new CreateDBInstanceRequest(); }
From source file:de.tuhrig.deployman.launch.Launcher.java
private DBInstance runDatabaseLaunch(Formation formation) { Rds rdsClient = new Rds(); // if ( true ) // return null; Database database = formation.getDatabase(); DBInstance dbInstance = null;//from w w w .ja v a 2 s . c o m if (rdsClient.databaseExists(database.getInstanceIdentifier())) { this.console.writeNl("Database already exists"); dbInstance = rdsClient.getDatabase(database.getInstanceIdentifier()); } else { this.console.writeNl("Create database"); CreateDBInstanceRequest request = new CreateDBInstanceRequest().withEngine(database.getEngine()) .withEngineVersion(database.getEngineVersion()).withLicenseModel(database.getLicense()) .withDBInstanceClass(database.getInstanceClass()).withMultiAZ(database.getMultiAz()) .withAutoMinorVersionUpgrade(database.getAutoMinorVersionUpgrade()) .withAllocatedStorage(database.getAllocatedStorage()) .withDBInstanceIdentifier(database.getInstanceIdentifier()) .withMasterUsername(database.getUsername()).withMasterUserPassword(database.getPassword()) .withDBName(database.getName()).withPort(database.getPort()); // .withVpcSecurityGroupIds( database.getSecurityGroup() ); dbInstance = rdsClient.getClient().createDBInstance(request); } this.console.writeNl("Starting..."); waitForDatabaseState(dbInstance.getDBInstanceIdentifier(), "available"); // sleep 10 seconds to get it really ready... // no idea why the state 'available isn't enough sleep(10000); dbInstance = rdsClient.getDatabase(dbInstance.getDBInstanceIdentifier()); runSetup(dbInstance, database); return dbInstance; }