Example usage for com.amazonaws.services.rds.model CreateDBParameterGroupRequest setDescription

Introduction

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

Prototype

public void setDescription(String description) 

Source Link

Document

The description for the DB parameter group.

Usage

From source file:RDSManager.java

public String createRDS() {
    String endPointAddr = null;/* ww  w  . j  a v a 2s. 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 {/*from w ww . j  a v a  2s. 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);
    }
}

---