Your new post is loading...
Faster insertion rates, improved scalability and agility support lab’s fast growing research database as it grows from 100s of GBs to 1 TB and beyond
|
Scooped by Phillip Trotter |
Scoop.it!
No comment yet.
Sign up to comment
When you think large scale biodata storage you do not usually think MySQL however TokuView have done just that at the University of Montreal. The lab’s genomic research database is following 1400 individuals with 3.7 million shared mutations, tracking a potential 5.3 billion mutations. Because the representation of genomic sequence is a highly compressible series of letters, the database requires less hardware than a typical one. However, it must be able to store and retrieve data quickly in order to respond to research requests.TokuDB proved to be over 50x faster to add or update data into big tables than standard MyISAM.