Amazon Web Services Developer Connection : Running MySQL on Amazon EC2 with El... - The Diigo Meta page

• 06 Dec 09
  

  Robert Redl
  • Now that we have an EBS volume mounted on the instance with a good
    file system, let's put the MySQL database on that volume and tell
    MySQL where it is.
  • sudo /etc/init.d/mysql stop
  • 5 more annotations...
  • • sudo mkdir /vol/etc /vol/lib /vol/log
      sudo mv /etc/mysql /vol/etc/
      sudo mv /var/lib/mysql /vol/lib/
      sudo mv /var/log/mysql /vol/log/
      
      sudo mkdir /etc/mysql
      sudo mkdir /var/lib/mysql
      sudo mkdir /var/log/mysql
      
      echo "/vol/etc/mysql /etc/mysql none bind" | sudo tee -a /etc/fstab
      sudo mount /etc/mysql
      
      echo "/vol/lib/mysql /var/lib/mysql none bind" | sudo tee -a /etc/fstab
      sudo mount /var/lib/mysql
      
      echo "/vol/log/mysql /var/log/mysql none bind" | sudo tee -a /etc/fstab
      sudo mount /var/log/mysql
    • sudo /etc/init.d/mysql start
    • The ec2-consistent-snapshot program automates the appropriate flushing and
      locking of MySQL and XFS file systems while the EBS snapshot is initiated.
    • codename=$(lsb_release -cs)
      echo "deb http://ppa.launchpad.net/alestic/ppa/ubuntu $codename main"|
      sudo tee /etc/apt/sources.list.d/alestic-ppa.list
      sudo apt-key adv --keyserver keyserver.ubuntu.com --recv-keys BE09C571
      sudo apt-get update
      sudo apt-get install -y ec2-consistent-snapshot
      sudo PERL_MM_USE_DEFAULT=1 cpan Net::Amazon::EC2
    • man ec2-consistent-snapshot
• 01 Aug 09
  

  Eran Davidov

  AWS EBS volume

• 30 May 09
  

  Julian R

  Amazon Cloud

• 15 Apr 09
  

  Carl Dunham

  database mysql aws ebs

• 25 Jan 09
  

  Piotr Malinski

  ec2 mysql ebs

• 04 Sep 08
  

  M G
• 03 Sep 08
  

  Michael Giles
• 29 Aug 08
  

  Ken Wei

  Amazon EC2 EBS MySQL

Would you like to comment?

Join Diigo for a free account, or sign in if you are already a member.