How do you optimize your MySQL database for writing?

Question

I have an intensive recording application running on EC2. Any thoughts on how to optimize it to be able to make several thousand simultaneous entries in the MySQL database?

Answer 1

Recording compression is a complex issue. Perhaps the secret scaling of a record is scaling a read. That is, the cache reads as much as possible, so that the records get all the bandwidth.

Having said that, there are tons of things you can do:

1) . , . - . " ", " " " ", "", "" "", "". Append Only. RethinkDB..

2) Concurrent Insert 1. , .

3) , . , MyISAM ( InnoDB, ).

4) , Memory Engine. MY_DATA, MY_DATA_MEM .

5) MEM. , UNIONS , .

6) , MEM Mem. MOVE Delete Mem ( , Memory Engine, ).

7) MEM ( ) (HASH vs B-Tree: Low Card → Hash, High Card- > -)

8) , jdbc/odbc. InnoDB Handler Socket, (Google Yoshinori-San MySQL)

HS, . Google Code Java HS.

, .