CUBRID & highload?
I have a banner network project. I need to INSERT up to 2k rows per second (thats a peak load) in one table and UPDATE up to 300 rows in another.
Table for INSERTs looks like this: id primary key, ip integer, date (date when record was added), user agent, referer, publisher_id (references row in another table), feed_id (references row in another table).
Table for UPDATEs has 12 fields and intentified by primary key id, only one of them (integer counter) is updated.
Also I need to do 2 SELECTs: one on INSERTs table and one on another table with ~10k records.
INSERTs table can have up to 10 million records (this is a log for views/clicks).
Currently I'm using MySQL with Infobright extension, but I already see it doesn't handle load. Scaling MySQL is a problem, so I'm looking for some alternative able to handle such load.
The question is: is CUBRID ready for this? Is it stable?