From: Hendrik Woltersdorf Date: January 29 2010 9:33am Subject: howto implement a fifo queue in MySQL Cluster ? List-Archive: http://lists.mysql.com/cluster/7415 Message-Id: MIME-Version: 1.0 Content-Type: multipart/alternative; Boundary="0__=4EBBFC29DFA0BE358f9e8a93df938690918c4EBBFC29DFA0BE35" --0__=4EBBFC29DFA0BE358f9e8a93df938690918c4EBBFC29DFA0BE35 Content-type: text/plain; charset=ISO-8859-15 Content-transfer-encoding: base64 SGkgYWxsLA0KDQpob3cgZG8gSSBpbXBsZW1lbnQgYSBmaWZvIHF1ZXVlIGluIE15U1FMIENsdXN0 ZXIgPw0KDQpXaGF0IEkgd2FudCB0byBkbzoNCg0KSSB3cml0ZSBpbnNlcnRzIGFuZCB1cGRhdGVz IHRvIHNvbWUgdGFibGVzIHdpdGggdHJpZ2dlcnMgaW50byBhIHF1ZXVlLg0KVGhlc2Ugcm93cyBo YXZlIHRvIGJlIHJlYWQgYW5kIHByb2Nlc3NlZCBpbiBjaHJvbm9sb2dpY2FsIG9yZGVyLg0KTXkg Zmlyc3QgYXR0ZW1wdCB3YXMgdG8gdXNlIGEgdGFibGUgd2l0aCBhbiBhdXRvaW5jcmVtZW50IGNv bHVtbiBhcyB0aGUNCnByaW1hcnkga2V5LiBCdXQgdGVzdHMgc2hvdywgdGhhdCB0aGVzZSBhdXRv aW5jcmVtZW50IHZhbHVlcyBhcmUgbm90DQppbnNlcnRlZCBpbiBjaHJvbm9sb2dpY2FsIG9yZGVy LiBBIGRhdGV0aW1lIGNvbHVtbiBkb2VzIG5vdCBoZWxwIGVpdGhlciwNCmJlY2F1c2UgaXQgaXMg YnkgZmFyIG5vdCBwcmVjaXNlIGVub3VnaCwgYW5kIGl0IGRlcGVuZHMgb24gdGhlDQpzeW5jaHJv bml6YXRpb24gb2YgdGhlIGNsb2NrcyBvZiB0aGUgZGlmZmVyZW50IHNxbCBub2RlIG1hY2hpbmVz Lg0KDQpBbnkgaWRlYXMsIGhvdyB0byByZWFkIHRoZXNlIGRhdGEgcm93cyBpbiBjaHJvbm9sb2dp Y2FsIG9yZGVyID8NCg0KVGhlIHNlY29uZCBiZXN0IGlkZWEgaXMsIHRvIHVzZSAic2VsZWN0IG1h eChQSykrMSIsIGJ1dCB0aGlzIHdpbGwgY2F1c2UNCmxvdHMgb2YgZHVwbGljYXRlIGtleSBlcnJv cnMuDQoNCkkgYW0gdXNpbmcgTXlTUUwgQ2x1c3RlciB2ZXJzaW9uIDcuMC43IHdpdGggMiBkYXRh IG5vZGVzLCAyIG1hbmFnZW1lbnQNCm5vZGVzIGFuZCAyIHNxbCBub2Rlcy4NCg0Ka2luZCByZWdh cmRzDQoNCkhlbmRyaWsgV29sdGVyc2RvcmYNClhDT00gQUcNClRlbC46IDAzNzUvMjcwMDgtNTgw DQpUZWwuIG1vYmlsOiAwMTc4LzU3MTAwNzgNCkVtYWlsOiBIZW5kcmlrLldvbHRlcnNkb3JmQHhj b20uZGUNCg0KDQoNCioqKiBYQ09NIEFHIExlZ2FsIERpc2NsYWltZXIgKioqDQoNCkRpZXNlIEUt TWFpbCBlaW5zY2hsaWVzc2xpY2ggaWhyZXIgQW5oYWVuZ2UgaXN0IHZlcnRyYXVsaWNoIHVuZCBp c3QgYWxsZWluDQpm/HIgZGVuIEdlYnJhdWNoIGR1cmNoIGRlbiB2b3JnZXNlaGVuZW4gRW1wZmFl bmdlciBiZXN0aW1tdC4gRHJpdHRlbiBpc3QNCmRhcyBMZXNlbiwgVmVydGVpbGVuIG9kZXIgV2Vp dGVybGVpdGVuIGRpZXNlciBFLU1haWwgdW50ZXJzYWd0LiBXaXIgYml0dGVuLA0KZWluZSBmZWhs Z2VsZWl0ZXRlIEUtTWFpbCB1bnZlcnp1ZWdsaWNoIHZvbGxzdGFlbmRpZyB6dSBsb2VzY2hlbiB1 bmQgdW5zDQplaW5lIE5hY2hyaWNodCB6dWtvbW1lbiB6dSBsYXNzZW4uDQoNClRoaXMgZW1haWwg bWF5IGNvbnRhaW4gbWF0ZXJpYWwgdGhhdCBpcyBjb25maWRlbnRpYWwgYW5kIGZvciB0aGUgc29s ZSB1c2UNCm9mIHRoZSBpbnRlbmRlZCByZWNpcGllbnQuIEFueSByZXZpZXcsIGRpc3RyaWJ1dGlv biBieSBvdGhlcnMgb3IgZm9yd2FyZGluZw0Kd2l0aG91dCBleHByZXNzIHBlcm1pc3Npb24gaXMg c3RyaWN0bHkgcHJvaGliaXRlZC4gSWYgeW91IGFyZSBub3QgdGhlDQppbnRlbmRlZCByZWNpcGll bnQsIHBsZWFzZSBjb250YWN0IHRoZSBzZW5kZXIgYW5kIGRlbGV0ZSBhbGwgY29waWVzLg0KDQpI YXVwdHNpdHo6IEJhaG5zdHJhc3NlIDM3LCBELTQ3ODc3IFdpbGxpY2gsIFVTdC1JZE5yLjogREUg ODEyIDg4NSA2NjQNCktvbW11bmlrYXRpb246IFRlbGVmb24gKzQ5IDIxNTQgOTIwOS03MCwgVGVs ZWZheCArNDkgMjE1NCA5MjA5LTkwMCwNCnd3dy54Y29tLmRlDQpIYW5kZWxzcmVnaXN0ZXI6IEFt dHNnZXJpY2h0IEtyZWZlbGQsIEhSQiAxMDM0MA0KVm9yc3RhbmQ6IE1hdHRoaWFzIEFsYnJlY2h0 LCBNYXJjbyBNYXJ0eSwgRHIuIFJhaW5lciBGdWNocywgRGlyayBXZXJuZXINClZvcnNpdHplbmRl ciBkZXMgQXVmc2ljaHRzcmF0ZXM6IFN0ZWZhbiBILiBUYXJhY2g= --0__=4EBBFC29DFA0BE358f9e8a93df938690918c4EBBFC29DFA0BE35--