MySQL Recover from EBS snapshots for logical volume

In this blog post http://cloudconclave.blogspot.com/2013/12/mysql-ebs-snapshots-for-backing-up.html, we backed up a MySQL database that stores its data across an LVM using multiple EBS volumes.  Now we will do a restore.

sudo /etc/init.d/mysqld stop 

sudo umount /dev/md0 

sudo mdadm --stop /dev/md0 

sudo mdadm --zero-superblock /dev/sdf 

sudo mdadm --zero-superblock /dev/sdg 

aws ec2 detach-volume --volume-id vol-1 aws ec2 detach-volume --volume-id vol-2

aws ec2 create-volume --snapshot-id snap-1 --availability-zone AZ -- volume-type standard

aws ec2 create-volume --snapshot-id snap-2 --availability-zone AZ -- volume-type standard

aws ec2 attach-volume --volume-id vol-New1 --instance-id INSTANCE -- device /dev/sdf

aws ec2 attach-volume --volume-id vol-New2 --instance-id INSTANCE -- device /dev/sdg

Create the stripped volumes:

yes | sudo mdadm \ --create /dev/md0 \ --level 0 \ --metadata=1.1 \ --raid-devices 2 \

/dev/xvdf /dev/xvdg

sudo mount -a sudo /etc/init.d/mysqld start

Oracle Enterprise Manager Solutions on AWS

Listen to this webinar, presented by Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner, to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources:

http://youtu.be/XSBND55sghc

EMaaS : Oracle OEM 12c as a Service webinar

Learn how Oracle Enterprise Manager 12c Cloud Control enables you to monitor and manage the complete enterprise application stack, web tier to storage, for both dedicated and cloud-based infrastructure environments.

Join Amazon Web Services (AWS) and Apps Associates, an AWS Partner Network (APN) Advanced Consulting Partner to hear how you can leverage the AWS platform to run a centralized OEM 12c environment to free up your administrative resources.

Register here:

https://event.on24.com/eventRegistration/EventLobbyServlet?target=registration.jsp&eventid=641039&sessionid=1&key=C3BFA66F187A7E2A5DD0C6865B83A3E6&partnerref=AWSemail_v1&mkt_tok=3RkMMJWWfF9wsRow5%2FmYJoDpwmWGd5mht7VzDtPj1OY6hBkuIryWflL6iuNDGZQ7fbSfDAMKHJ52xQ5LH%2FKDdYNF6Q%3D%3D&sourcepage=register

Replay can be found here:
http://www.youtube.com/watch?v=XSBND55sghc

OEM 12c test drive on AWS

Now you can try out Oracle Enterprise Manager 12c on AWS:https://blogs.oracle.com/oem/entry/test_drive_oracle_enterprise_manager

Oracle Enterprise Manager Cloud Control 12c - Monitoring Essentials test drive lab

App Associates and AWS just announced a new test drive lab.  This test drive lab demonstrates how OEM 12c can be used to monitor and manage on premise Oracle environments in the cloud.

http://awslabs.appsassociates.com/oemdb-registration.php

Oracle Enterprise Manager and AWS EC2 instance restart

Question: An EC2 restart causes OEM to loss IP address of OEM management console - Is there a way to attach a static IP address to an EC2 instance instead the default o

ec2 IP.compute-1.amazonaws.com Response: If you assign an Elastic IP address to the EC2  instance before installing OEM, then you should have no problem.     Once the EC2 instance has been created (without an EIP) and  OEM has been installed there is no  other way to do it except to use this workaround -  http://cloudconclave.blogspot.com/2012/12/oracle-enterprise-manager-on-ec2-ip.html

Oracle Enterprise Manager 12c AWS plug in

There is now a plug in for Oracle Enterprise Manager (OEM) so OEM 12c can be used to monitor Oracle technology running on AWS:
http://www.oracle.com/technetwork/oem/grid-control/downloads/oem-aws-plugin-1852739.html

This plug in uses AWS CloudWatch metrics and can monitor EBS, EC2 and RDS.