Java DBInstance类代码示例

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
private void getRDSInstances() {
	DescribeDBInstancesResult response = rdsClient.describeDBInstances(new DescribeDBInstancesRequest());
	
	List<PulseInstance> rds = new ArrayList<PulseInstance>();

	PulseInstance pulse = null;
	for (DBInstance instance : response.getDBInstances()) {
		ListTagsForResourceResult result = rdsClient.listTagsForResource(new ListTagsForResourceRequest().withResourceName(instance.getDBInstanceArn()));
		
		for (com.amazonaws.services.rds.model.Tag tag : result.getTagList()) {
			if (tag.getKey().equals(properties.getTag()) && (tag.getValue().equals("TRUE") || tag.getValue().equals("True") || tag.getValue().equals("true"))) {
				pulse = new PulseInstance();
				pulse.setId(instance.getDBInstanceIdentifier());
				pulse.setName(instance.getDBInstanceIdentifier());
				pulse.setAddress(instance.getEndpoint().getAddress());
				pulse.setType(instance.getDBInstanceClass());
				
				rds.add(pulse);
			}
		}
	}
	
	GetMonitoringInstances.rds = rds;
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Test helper - makes describe result with a named instance.
 */
private DescribeDBInstancesResult makeDescribeDBInstancesResult(String... instanceNames)
{
  DescribeDBInstancesResult result = new DescribeDBInstancesResult();
  List<DBInstance> dbInstances = new ArrayList<DBInstance>();
  if (ArrayUtils.isNotEmpty(instanceNames))
  {
    for (String instanceName : instanceNames)
    {
      DBInstance dbInstance = new DBInstance();
      dbInstance.setDBInstanceIdentifier(instanceName);
      dbInstances.add(dbInstance);
    }
  }
  result.setDBInstances(dbInstances);
  return result;
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
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")
            ;
    DBInstance response = client.createDBInstance(request);
    System.out.println(response);

    describe(dbInstanceIdentifier);
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
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);
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
public 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);
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
public void describe(String dbInstanceIdentifier) throws Exception {
    while (true) {
        DescribeDBInstancesRequest request = new DescribeDBInstancesRequest()
                .withDBInstanceIdentifier(dbInstanceIdentifier);

        DescribeDBInstancesResult response = client.describeDBInstances(request);
        DBInstance dbInstance = response.getDBInstances().get(0);
        if (!dbInstance.getDBInstanceStatus().equalsIgnoreCase("creating")) {
            System.out.println("Done! " + response);
            System.out.println(dbInstance.getEndpoint().getAddress());
            System.out.println(dbInstance.getEndpoint().getPort());
            break;
        }

        System.out.println("Not done - will wait 10s: " + response);
        Thread.sleep(10000L);
    }
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Deletes the parameter group, if it appears to have been created solely for the deleted db instance.
 * <p/>
 * (The parameter group cannot be deleted until the dependent rdsInstance is fully deleted.)
 */
void deleteParameterGroup(DBInstance rdsInstance, boolean noop)
{
  if (noop)
  {
    //rdsInstance is null, don't try to analyze it
    LOGGER.info(context() + "Deleting parameter group" + noopRemark(noop));
  }
  else
  {
    String paramGroupName = rdsAnalyzer.findSelfNamedParamGroupName(rdsInstance);
    if (StringUtils.isBlank(paramGroupName))
    {
      LOGGER.info(context() + "Deleted database did not have its own special parameter group");
    }
    else
    {
      LOGGER.info(context() + "Deleting parameter group '" + paramGroupName + "', which was used only by the deleted database");
      rdsClient.deleteParameterGroup(paramGroupName);
    }
  }
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Communicates with RDS for updated instance progress and checks the status.
 * Concludes if error or if naturally done.
 */
@Override
public void followupCheck(int waitNum)
{
  try
  {
    DBInstance dbInstance = rdsClient.describeInstance(instanceId);
    checkInstanceId(dbInstance);
    logFollowupStatus(waitNum, dbInstance);
    checkInstanceStatus(dbInstance);
  }
  catch (DBInstanceNotFoundException e)
  {
    handleInstanceNotFound(waitNum, e);
  }
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Checks if the instance is in an acceptable intermediate status, and flags done if at final state.
 */
protected void checkInstanceStatus(DBInstance dbInstance)
{
  final String status = dbInstance.getDBInstanceStatus();
  if (expectedFinalState.equalsString(status))
  {
    LOGGER.info("RDS " + getDescription() + " is done");
    done = true;
    result = dbInstance;
  }
  else if (isOneOfTheseStates(expectedIntermediateStates, status))
  {
    //Keep waiting.
  }
  else
  {
    LOGGER.error(logContext + getDescription() + ": Unexpected response status '" + status + "'");
    done = true;
  }
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Amazon can't find the instance.  This is an allowed final state for a delete operation, otherwise is a bad error.
 */
private void handleInstanceNotFound(int waitNum, DBInstanceNotFoundException e)
{
  LOGGER.debug("RDS " + getDescription() + " status after wait#" + waitNum + ": " + e.getClass().getSimpleName()
      + ": " + e.getMessage());
  if (expectedFinalState.equals(DELETE_FINAL_STATE))
  {
    LOGGER.info("RDS " + getDescription() + " is done");
    result = new DBInstance(); //Just a stub, since result==null would be considered a progress error.
  }
  else
  {
    LOGGER.error(logContext + getDescription() + ": not found", e);
  }
  done = true;
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Makes a copy of the live instance's parameter group.
 */
private DBParameterGroup copyParameterGroup(DBInstance liveInstance, boolean noop)
{
  String stagePhysicalInstanceName = dbMap.get(liveLogicalDatabase.getLogicalName());
  String liveParamGroupName = rdsAnalyzer.findSelfNamedOrDefaultParamGroupName(liveInstance);
  String stageParamGroupName = makeStageParamGroupName(liveParamGroupName,
      liveInstance.getDBInstanceIdentifier(), stagePhysicalInstanceName);
  LOGGER.info(liveContext() + "Copying live parameter group '" + liveParamGroupName
      + "' to stage parameter group '" + stageParamGroupName + "'" + noopRemark(noop));
  if (!noop)
  {
    return rdsClient.copyParameterGroup(liveParamGroupName, stageParamGroupName);
  }
  else
  {
    return null;
  }
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Restores the live snapshot into the new staging environment.
 * Then makes a few small modifications that restore would not do automatically (paramgroup and security group).
 * Reboots the db so the paramgroup modification will take effect.
 * Returns the rebooted instance.
 */
DBInstance restoreStage(DBSnapshot dbSnapshot,
                        DBParameterGroup stageParamGroup,
                        DBInstance liveInstance,
                        boolean noop)
{
  LOGGER.info(liveContext() + "Restoring snapshot to new stage RDS instance" + noopRemark(noop));
  if (!noop)
  {
    String stagePhysicalInstanceName = dbMap.get(liveLogicalDatabase.getLogicalName());
    initModel(stagePhysicalInstanceName);
    String subnetGroupName = getSubnetGroupName(liveInstance);
    DBInstance stageInstance = rdsClient.restoreInstanceFromSnapshot(stagePhysicalInstanceName,
        dbSnapshot.getDBSnapshotIdentifier(), subnetGroupName);
    stageInstance = waitTilInstanceIsAvailable(stagePhysicalInstanceName, stageInstance, RdsInstanceStatus.CREATING);
    DBInstance modifiedInstance = modifyInstance(stageInstance, stageParamGroup, liveInstance);
    modifiedInstance = waitTilParamGroupIsPendingReboot(stagePhysicalInstanceName, modifiedInstance, stageParamGroup,
        RdsInstanceStatus.MODIFYING);
    DBInstance rebootedInstance = rebootInstance(modifiedInstance);
    rebootedInstance = waitTilInstanceIsAvailable(stagePhysicalInstanceName, rebootedInstance, RdsInstanceStatus.REBOOTING);
    return rebootedInstance;
  }
  return null;
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Creates a Waiter using an instance paramgroup progress checker, and returns the final DBInstance when waiting is done.
 * In case of error - never returns null, throws instead.
 */
private DBInstance waitTilParamGroupIsPendingReboot(String instanceId, DBInstance initialInstance,
                                                    DBParameterGroup stageParamGroup,
                                                    RdsInstanceStatus expectedInitialState)
{
  LOGGER.info(liveContext() + "Waiting for instance to become available and instance paramgroup modification to be fully applied");
  RdsInstanceParamGroupProgressChecker progressChecker = new RdsInstanceParamGroupProgressChecker(instanceId,
      stageParamGroup.getDBParameterGroupName(), liveContext(), rdsClient, rdsAnalyzer, initialInstance, expectedInitialState);
  Waiter<DBInstance> waiter = new Waiter(waiterParameters, threadSleeper, progressChecker);
  DBInstance dbInstance = waiter.waitTilDone();
  if (dbInstance == null)
  {
    throw new RuntimeException(liveContext() + progressChecker.getDescription() + " did not become available, "
        + "or paramgroup failed to reach pending-reboot state");
  }
  return dbInstance;
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Restores a snapshot to a brand new instance.
 * <p/>
 * New instance gets the default security group, otherwise should be same as snapshot.
 * <p/>
 * Caller must wait for status=available afterwards.
 */
public DBInstance restoreInstanceFromSnapshot(String instanceName, String snapshotId, String subnetGroupName)
{
  LOGGER.debug("restoreDBInstanceFromDBSnapshot(instanceName: " + instanceName + ", snapshotId: " + snapshotId
      + ", subnetGroupName: " + subnetGroupName + ")");
  StopWatch stopWatch = new StopWatch();
  try
  {
    stopWatch.start();
    RestoreDBInstanceFromDBSnapshotRequest request = new RestoreDBInstanceFromDBSnapshotRequest(
        instanceName, snapshotId);
    request.setDBSubnetGroupName(subnetGroupName);
    return awsRdsClient.restoreDBInstanceFromDBSnapshot(request);
  }
  finally
  {
    stopWatch.stop();
    LOGGER.debug("restoreDBInstanceFromDBSnapshot time elapsed: " + stopWatch);
  }
}
 

import com.amazonaws.services.rds.model.DBInstance; //导入依赖的package包/类
/**
 * Modifies the instance by applying new security groups and new parameter group.
 * <p/>
 * Caller must wait for status=available afterwards.
 */
public DBInstance modifyInstanceWithSecgrpParamgrp(String instanceName,
                                                   Collection<String> vpcSecurityGroupIds,
                                                   String paramGroupName)
{
  LOGGER.debug("modifyDBInstance(instanceName: " + instanceName + ", vpcSecurityGroupIds: ("
      + StringUtils.join(vpcSecurityGroupIds, ", ") + "), paramGroupName: " + paramGroupName + ")");
  StopWatch stopWatch = new StopWatch();
  try
  {
    stopWatch.start();
    ModifyDBInstanceRequest request = new ModifyDBInstanceRequest(instanceName);
    request.setVpcSecurityGroupIds(vpcSecurityGroupIds);
    request.setDBParameterGroupName(paramGroupName);
    return awsRdsClient.modifyDBInstance(request);
  }
  finally
  {
    stopWatch.stop();
    LOGGER.debug("modifyDBInstance time elapsed: " + stopWatch);
  }
}