… high availability. We’re coming with pre-installed virtual machine images for you to use. Florian took care of the Libvirt… virtual appliances (tarball): http://ubuntuone.com/01mJtfGDc2QbxB9eaOqcWc Libvirt and VMware images and configuration files (bzipped tarball): http://ubuntuone.com/3nikxumH483slq8rfP73iZ If…
Comment: Making the impossible: 3 nodes intercontinental replication
March 21, 2012 By 25 Comments
…’s default as well as RHEL 6.2 stock AMI images (I had to modify the script slightly for the Amazon image) but it didn’t work on either. Should I install ….com/doc/percona-server/5.5/installation.html on these images before running this intercontinental script?
Post: Shard-Query EC2 images available
May 11, 2011 By 2 Comments
Infobright and InnoDB AMI images are now available There are now demonstration AMI images for Shard-Query. Each image comes pre-loaded with…/null 2>&1 < /dev/null done; Where to find the images Amazon ID Name Arch Notesami-20b74949 shard-query-infobright-demo… times and throughput. Setting up a cluster using the AMI images You can easily test Shard-Query for yourself. Spin up…
Post: XtraDB Amazon Image
October 25, 2009 By 9 Comments
… a good news. We created a public AMI (Amazon Machine Image) with XtraDB release 8 installed on CentOS 5.3. How… use it. First make sure it is avaiable. $ ec2-describe-images ami-4701e22e IMAGE  ami-4701e22e   xtradb/centos…
Post: Content delivery system design mistakes
February 11, 2007 By 9 Comments
… especially for “aggregate” pages which may require images to be pulled from 10 different image servers. Keep Alive In my previous post…) but you really should have Keep Alive enabled while serving images. It especially hurts not to have one if 30 thumbnails… and should not be mixed. Use noatime mount option Serving images you rarely need last access time tracked for them, especially…
Post: Long PRIMARY KEY for Innodb tables
October 3, 2006 By 8 Comments
… had the task to store meta data about thumbnails for images retrieved from various web sites in the Internet. Thumbnails themselves…) or something similar as a key – it is often many images from one domain/album are inserted at about same time… plus we might want to get all thumbnails for given image url effectively. In general I use this example as illustration…
Comment: Join performance of MyISAM and Innodb
April 3, 2010 By 6 Comments
…) AGAINST (‘gold’)) AS score FROM products p LEFT JOIN product_images pi ON (p.productid = pi.imageprodid AND pi.imageisthumb = 1…: 2.5000+ seconds TABLES DATA: products: 31,000 records product_images: 92,000 records product_search: 57,000 records EXPLAIN COMMAND… 1 Using where 1 SIMPLE pi ref i_product_images_imageprodid i_product_images_imageprodid 5 shoppingcart_5521.p.productid,const 1
Comment: JOIN Performance & Charsets
April 3, 2010 By 2 Comments
…) AGAINST (‘gold’)) AS score FROM products p LEFT JOIN product_images pi ON (p.productid = pi.imageprodid AND pi.imageisthumb = 1…: 2.5000+ seconds TABLES DATA: products: 31,000 records product_images: 92,000 records product_search: 57,000 records EXPLAIN COMMAND… 1 Using where 1 SIMPLE pi ref i_product_images_imageprodid i_product_images_imageprodid 5 shoppingcart_5521.p.productid,const 1
Post: High availability for MySQL on Amazon EC2 – Part 2 - Setting up the initial instances
June 29, 2010 By 9 Comments
… seems ok. yves@yves-laptop:~$ ec2-describe-images ami-1cdf3775 IMAGE ami-1cdf3775 099720109477/ubuntu-images-testing/ubuntu-lucid-daily-i386-server-20100618…
Comment: Blob Storage in Innodb
February 14, 2010 By 13 Comments
I seem to be missing the point?? WHY, WHY, WHY would you save images in your DB when saving the link/URL to a simple varchar field and letting the OS do the work on the image directory is not MUCH more efficient?? BLOB, really?
