If not, can you tell me how to store the file? I want to continue using cassandra because it is fault tolerant and uses automatic replication between nodes.
Thanks for the help.
Cassandra's public API is based on Thrift, which offers no streaming abilities
any value written or fetched has to fit in memory. This is inherent to Thrift's
design and is therefore unlikely to change. So adding large object support to
Cassandra would need a special API that manually split the large objects up
into pieces. A potential approach is described in http://issues.apache.org/jira/browse/CASSANDRA-265.
As a workaround in the meantime, you can manually split files into chunks of whatever
size you are comfortable with - at least one person is using 64MB - and making a file correspond
to a row, with the chunks as column values.
So if Your file is <10MB and you should be fine, just make sure to limit the file size, or break large files into blocks.
I am developing a PHP platform that will be used a lot Images, documents and any file format, this will be in my mind, so I want to know if Cassandra is a good choice for my needs.
If not, can you tell me how to store the file? I want to continue using cassandra because it is fault-tolerant and uses automatic replication between nodes.
Thanks for the help.
From cassandra wiki,
Cassandra's public API is based on Thrift, which offers no streaming abilities
any value written or fetched has to fit in memory. This is inherent to Thrift's
design and is therefore unlikely to change. So adding large object support to
Cassandra would need a special API that manually split the large objects up
into pieces. A potential approach is described in http://issues.apache.org/jira/browse/CASSANDRA-265.
As a workaround in the meantime, you can manually split files into chunks of whatever
size you are comfortable with - at least one person is using 64MB - and making a file correspond
to a row, with the chunks as column values.
So if your file is <10MB you should be fine, as long as Make sure to limit the file size, or break large files into blocks.
WordPress database error: [Table 'yf99682.wp_s6mz6tyggq_comments' doesn't exist]SELECT SQL_CALC_FOUND_ROWS wp_s6mz6tyggq_comments.comment_ID FROM wp_s6mz6tyggq_comments WHERE ( comment_approved = '1' ) AND comment_post_ID = 622 ORDER BY wp_s6mz6tyggq_comments.comment_date_gmt ASC, wp_s6mz6tyggq_comments.comment_ID ASC