150 reputation
6
bio website
location
age
visits member for 2 years, 4 months
seen Nov 3 at 17:03

Sep
17
comment DB for storing simple time-stamped values
You just create collection like this: db.createCollection("yourcollection", {capped: true, size: 50000000000}); and it will automatically overwrite the oldest data and index entries.
Sep
16
revised DB for storing simple time-stamped values
added 607 characters in body
Sep
16
awarded  Editor
Sep
16
revised DB for storing simple time-stamped values
added 135 characters in body
Sep
16
answered DB for storing simple time-stamped values
Sep
16
awarded  Commentator
Sep
16
comment DB for storing simple time-stamped values
OK, I am working on similar problem myself right now. Large sequential writes, and few random reads as well some aggregation but not much. I have test app in Groovy to generate data, and few backends - MariaDB, MongoDB, PostgreSQL, DB2, MSSQL, H2, Cassandra as well AWS services. I will do some more tests so I will be able to tell something. I am looking into filling the database, then "rotating the data", and I am measuring response times. So far it's quite challenging for all of these.
Sep
16
comment DB for storing simple time-stamped values
There isn't magic bullet for fast writes with overwrite and fast random reads based on timestamps and using cheap hardware. Using DynamoDB in AWS would be quite OK.
May
28
awarded  Popular Question
Sep
21
comment PostgreSQL replication and large import
I am investigating cascading replication, seems to be similar to the MySQL Distribution Master - thanks for linking it up!
Sep
21
accepted PostgreSQL replication and large import
Sep
21
comment PostgreSQL replication and large import
Since it's long distance replication, I have chosen asynchronous replication, hence the streaming as for now looks OK
Sep
17
asked PostgreSQL replication and large import
Aug
25
comment MySQL cluster - how many hosts are needed for full HA?
@lzac thats actually very true, you need one spare at any time to switch over
Aug
20
accepted How to use MySQL Server 5.6 for GeoIP replication?
Aug
20
comment How to use MySQL Server 5.6 for GeoIP replication?
OKOK I have now idea how to get this to work properly. I'll put one in place, and see how it performs with 4 nodes with 200-300ms distances from the write master in London.
Aug
20
awarded  Supporter
Aug
20
comment SQL server job deployment
It's very hard to say really, I would just submit it and rely on server feedback on errors for the first time.
Aug
20
answered Large scale, hard to model design advice needed
Aug
20
comment Providing an ad-hoc report facility for business users in SQL Server 2008 R2
You mean both setting up the query and rendering the data? This is multi-tier application and it's implemented with Silverlight, LightSwitch and .NET WPF as in Server 2012 but not 2008 R2. There are however different tools to do either query construction and presentation rendering, and as for facility there are OLAP cubes.