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

Introduction

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

Prototype

DBInstance

Source Link

Usage

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;//from  w  ww . j  av a 2 s.c o  m
    }

    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:beanstalk.BeansDatabase.java

License:Apache License

public DatabaseObject getDBInstanceInfo(String AWSKeyId, String AWSSecretKey, String dbname) {//throws Exception {
    BasicAWSCredentials basic_credentials = new BasicAWSCredentials(AWSKeyId, AWSSecretKey);
    AmazonRDSClient rDSClient = new AmazonRDSClient(basic_credentials);
    DescribeDBInstancesRequest describeDBInstancesRequest = new DescribeDBInstancesRequest();
    describeDBInstancesRequest.setDBInstanceIdentifier(dbname + "cloud4soaid");
    DBInstance dbInstance = new DBInstance();
    DescribeDBInstancesResult describeDBInstances = rDSClient.describeDBInstances(describeDBInstancesRequest);
    List<DBInstance> dbInstances = describeDBInstances.getDBInstances();

    System.out.println("size--->" + dbInstances.size());
    System.out.println("dbname--->" + dbInstances.get(0).getDBName());
    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());
    DatabaseObject dbobj = new DatabaseObject();
    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:beanstalk.BeansDatabase.java

License:Apache License

public String getDBEndpoint(String AWSKeyId, String AWSSecretKey, String dbname) {//throws Exception {

    String endpoint_str = "";
    BasicAWSCredentials basic_credentials = new BasicAWSCredentials(AWSKeyId, AWSSecretKey);

    AmazonRDSClient rDSClient = new AmazonRDSClient(basic_credentials);

    ModifyDBInstanceRequest mod_db = new ModifyDBInstanceRequest(dbname + "cloud4soaid");
    DBInstance dbInstance = new DBInstance();
    ////CHECK THIS. in order to make correct ModifyDBInstanceRequest an attribute must be sent for modification.
    ///5 (GB) is the minimum
    mod_db.setAllocatedStorage(6);/*from  w  w  w. j a v a2 s . com*/

    dbInstance = rDSClient.modifyDBInstance(mod_db);
    Endpoint endpoint = new Endpoint();
    endpoint = dbInstance.getEndpoint();
    if (endpoint != null) {
        endpoint_str = endpoint.getAddress();
        System.out.println("endpoint to string:" + endpoint_str);/////{Address: cloud4soadbid.coaodqyxxykq.us-east-1.rds.amazonaws.com, Port: 3306, }
        System.out.println("endpoint get address:" + endpoint.getAddress());/////cloud4soadbid.coaodqyxxykq.us-east-1.rds.amazonaws.com
    }

    return endpoint_str;
}

---

From source file:beanstalk.BeansDatabase.java

License:Apache License

public boolean deleteDatabase(String AWSKeyId, String AWSSecretKey, String dbIdentifier) {//throws Exception {

    boolean ret = false;
    //  credentials = new PropertiesCredentials(BeanstalkDeployNoGUI.class.getResourceAsStream("AwsCredentials.properties"))
    BasicAWSCredentials basic_credentials = new BasicAWSCredentials(AWSKeyId, AWSSecretKey);

    //  SimpleDBUtils simpledb= new SimpleDBUtils();
    AmazonRDSClient rDSClient = new AmazonRDSClient(basic_credentials);
    // RestoreDBInstanceFromDBSnapshotRequest req= new RestoreDBInstanceFromDBSnapshotRequest();
    //  req.setDBName("dbname");
    //  req.setPort(3306);

    DescribeDBInstancesRequest ddbi = new DescribeDBInstancesRequest();

    DBInstance dbins = new DBInstance();
    dbins.getEndpoint();//from w ww.j a va  2s.c  o  m
    DeleteDBInstanceRequest delRequest = new DeleteDBInstanceRequest(dbIdentifier);
    // rDSClient.restoreDBInstanceFromDBSnapshot(req);
    delRequest.setSkipFinalSnapshot(true);
    rDSClient.deleteDBInstance(delRequest);

    return ret;
}

---

From source file:com.msi.tough.utils.rds.InstanceEntity.java

public static DBInstance toDBInstance(final RdsDbinstance b, final AccountBean ac) {
    final DBInstance instRec = new DBInstance();
    instRec.setDBInstanceIdentifier(b.getDbinstanceId());
    instRec.setReadReplicaSourceDBInstanceIdentifier(b.getSourceDbinstanceId());
    instRec.setReadReplicaDBInstanceIdentifiers(b.getReplicas());
    instRec.setDBInstanceClass(b.getDbinstanceClass());
    instRec.setAllocatedStorage(Integer.valueOf(b.getAllocatedStorage()));
    instRec.setInstanceCreateTime(b.getInstanceCreateTime());
    instRec.setDBInstanceStatus(b.getDbinstanceStatus());
    instRec.setEngine(b.getEngine());//ww w  . j  a  v a  2 s.c o m
    instRec.setEngineVersion(b.getEngineVersion());
    instRec.setAvailabilityZone(b.getAvailabilityZone());
    instRec.setMultiAZ(b.getMultiAz());
    instRec.setMasterUsername(b.getMasterUsername());
    instRec.setDBName(b.getDbName());
    instRec.setAutoMinorVersionUpgrade(b.getAutoMinorVersionUpgrade());
    instRec.setBackupRetentionPeriod(Integer.valueOf(b.getBackupRetentionPeriod()));
    instRec.setLatestRestorableTime(b.getLatestRestorableTime());
    instRec.setPreferredBackupWindow(b.getPreferredBackupWindow());
    instRec.setPreferredMaintenanceWindow(b.getPreferredMaintenanceWindow());
    instRec.setLicenseModel(b.getLicenseModel());
    final Endpoint endpoint = new Endpoint();
    endpoint.setAddress(b.getAddress());
    endpoint.setPort(Integer.valueOf(b.getPort()));
    instRec.setEndpoint(endpoint);
    String status = b.getDbinstanceStatus();
    if (status.equals("restoring")) {
        status = "creating";
    }
    instRec.setDBInstanceStatus(status);
    final String dbparamName = b.getDbParameterGroup();
    final Collection<DBParameterGroupStatus> dBParameterGroups = new LinkedList<DBParameterGroupStatus>();
    final DBParameterGroupStatus dbparamStatus = new DBParameterGroupStatus();
    dbparamStatus.setDBParameterGroupName(dbparamName);
    if (b.getPendingRebootParameters() == null || b.getPendingRebootParameters().size() == 0) {
        dbparamStatus.setParameterApplyStatus(RDSUtilities.STATUS_IN_SYNC);
    } else {
        dbparamStatus.setParameterApplyStatus(RDSUtilities.STATUS_PENDING_REBOOT);
    }
    dBParameterGroups.add(dbparamStatus);
    instRec.setDBParameterGroups(dBParameterGroups);

    final Collection<DBSecurityGroupMembership> dBSecurityGroups = new LinkedList<DBSecurityGroupMembership>();
    for (final RdsDbsecurityGroup secGrp : b.getSecurityGroups()) {
        final DBSecurityGroupMembership membership = new DBSecurityGroupMembership();
        membership.setDBSecurityGroupName(secGrp.getDbsecurityGroupName());
        membership.setStatus(secGrp.getStatus());
        dBSecurityGroups.add(membership);
    }
    instRec.setDBSecurityGroups(dBSecurityGroups);
    return instRec;
}

---