Tag Info

New answers tagged

0

At first you should move to a 3 node replica set to ensure High Availability. At your case i would suggest to add an arbiter to your set, and give higher priority to the server A to ensure that will be the Primary. 1) Probably your question is about atomicity rather than consistency (correct me if i am wrong) the most safe choice is command findAndModify ...


0

There could be many way possible to store data for such scenario, as with your design attempt it seems that you are looking to have unique Id to identify each product and if that is the case the you are right with having a productstable and make that product_id an auto increment key. Now the next thing to make sure that what ever the attributes of all these ...


0

I worked it out, in-case anyone would like to know the following Query did it: SELECT CONCAT( 'SELECT `ost_ticket_event`.ticket_id', GROUP_CONCAT(' , `t_', REPLACE(state, '`', '``'), '`.timestamp AS `', REPLACE(state, '`', '``'), '`' SEPARATOR ''), ' FROM `ost_ticket_event` ', GROUP_CONCAT(' LEFT JOIN `ost_ticket_event` AS `t_', REPLACE(state, ...



Top 50 recent answers are included