Hi, You need to write into "write behind handler" to database only (you can fill several table, if it needed, for example "Order" than "Trade"). Cache which has "read through" on table "Trade" will always read value from database, until cache entry does not exist.
On Thu, Oct 27, 2016 at 6:03 PM, bintisepaha <binti.sep...@tudor.com> wrote: > yes I think you are write. Is there any setting that we can use in write > behind that will not lock the entries? > the use case is we have is like this > > Parent table - Order (Order Cache) > Child Table - Trade (Trade Cache) > > We only have write behind on Order Cache and when writing that we write > order and trade table both. so we query trade cache from order cache store > writeAll() which is causing the above issue. We need to do this because we > cannot write trade in the database without writing order. Foreign key > constraints and data-integrity. > > Do you have any recommendations to solve this problem? We cannot use > write-through. How do we make sure 2 tables are written in an order if they > are in separate caches? > > Thanks, > Binti > > > > -- > View this message in context: http://apache-ignite-users. > 70518.x6.nabble.com/Killing-a-node-under-load-stalls-the- > grid-with-ignite-1-7-tp8130p8557.html > Sent from the Apache Ignite Users mailing list archive at Nabble.com. > -- Vladislav Pyatkov
