Recently, we faced a huge performance problem with one of our installed apps. The application is a Call Center ERP solution. The Call model is updated very frequently as there are about approximately 8,000 – 10,000 calls being made everyday. For every action there is an audit trail, so updates and inserts into database areContinue reading “Case Study: Improving Performance of MySQL, Thinking Sphinx in a Rails app”
> Getting started with MySQL on Amazon Web Serviceshttp://static.slidesharecdn.com/swf/ssplayer2.swf?doc=usingamazonwebservices-090422111735-phpapp01&stripped_title=getting-started-with-mysql-in-amazon-web-services&userName=ronaldbradford View more presentations from Ronald Bradford.
1. Copy One database to other on same host mysqldump -uroot -p source_database_name | mysql -uroot dest_database_name 2. Copy database from one host to other host. mysqldump -uroot -p source_database | ssh host2 “mysql -uroot dest_database”