Example usage for com.amazonaws.services.rds.model CreateDBInstanceRequest setEngineVersion

Introduction

In this page you can find the example usage for com.amazonaws.services.rds.model CreateDBInstanceRequest setEngineVersion.

Prototype

public void setEngineVersion(String engineVersion) 

Source Link

Document

The version number of the database engine to use.

Usage

From source file:RDSManager.java

public String createRDS() {
    String endPointAddr = null;//from   www  . j  a  v a  2  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:com.kpbird.aws.Main.java

public void createRDS() {
    try {/* ww  w  .ja v  a 2  s. c om*/
        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);
    }
}

---