Example usage for com.amazonaws.services.rds.model ModifyDBParameterGroupRequest ModifyDBParameterGroupRequest

Introduction

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

Prototype

public ModifyDBParameterGroupRequest() 

Source Link

Document

Default constructor for ModifyDBParameterGroupRequest object.

Usage

From source file:RDSManager.java

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

---