Large scale docebo installation

Install and configure FormaLMS and DoceboCE
Post Reply
wanadli
Newbie
Posts: 12
Joined: Sun Oct 14, 2012 5:00 pm

Large scale docebo installation

Post by wanadli »

Hi ... I was wondering if anybody has ever tried setting up docebo on a big scale using multiple servers.

I was thinking of using a couple of servers with the docebo source code (htdocs) shared on SAN.

Do you think that'll work?
User avatar
max
FormaLms Guru
Posts: 2761
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: Large scale docebo installation

Post by max »

Hi wanadli and welcome to the Community!

I have experience with about 8-9.000 users. I know that Docebo LMS was implemented at least with 200.000 users, probably there are also larger installations.

I'm not a system expert (other forum users can be more precise than me and can reply to your question).

what I can do is point you to this thread viewtopic.php?f=2&t=79
In the "tech draft" document, you can also find a useful table with the suggested configuration and server dimensioning.
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
wanadli
Newbie
Posts: 12
Joined: Sun Oct 14, 2012 5:00 pm

Re: Large scale docebo installation

Post by wanadli »

Hello ...

I created a docebo installation with 200k users.
The admin - user mgmt crashed! the user list table loads very very slow. And if you try to do a search it will crash the my machine.

In fact, with that number of users, any features that have a ALL USERS listing will crash the system.
maybe it's the way the sql query was program i am not sure.

will update a post once i find out.

would appreciate any leads if anybody else have encountered similar problems.

cheers!!
wanadli
Newbie
Posts: 12
Joined: Sun Oct 14, 2012 5:00 pm

Re: Large scale docebo installation

Post by wanadli »

I did firebug output print on
doceboCore/models/UsermanagementAdm.php
on a database with 75k users and here's what i get:

SELECT u.idst, u.userid, u.lastname, u.firstname, u.email,
u.register_date, u.lastenter, u.valid FROM %adm_user as u
WHERE u.idst IN (

SELECT idstMember FROM %adm_group_members as gm WHERE gm.idst IN (
2,12762,12780,12960,14760,14762,14764,14766,14768,14770,14772,14774,
14776,14778,12962,14780,14782,14784,14786,14788,14790,14792,14794,14796,
14798,12964,14800,14802,14804,14806,14808,14810,14812,14814,14816,14818,
12966,14820,14822,14824,14826,14828,14830,14832,14834,14836,14838,12968,
14840,14842,14844,14846,14848,14850,14852,14854,14856,14858,12970,14860,
14862,14864,14866,14868,14870,14872,14874,14876,14878,12972,14880,14882,
14884,14886,14888,14890,14892,14894,14896,14898,12974,14900,14902,14904,
14906,14908,14910,14912,14914,14916,14918,12976,14920,14922,14924,14926,
14928,14930,14932,14934,14936,14938,12978,14940,14942,14944,14946,14948,
14950,14952,14954,14956,14958,12782,12980,14960,14962,14964,14966,14968,
14970,14972,14974,14976,14978,12982,14980,14982,14984,14986,14988,14990,
14992,14994,14996,14998,12984,15000,15002,15004,15006,15008,15010,15012,
15014,15016,15018,12986,15020,15022,15024,15026,15028,15030,15032,15034,
15036,15038,12988,15040,15042,15044,15046,15048,15050,15052,15054,15056,
15058,12990,15060,15062,15064,15066,15068,15070,15072,15074,15076,15078,
12992,15080,15082,15084,15086,15088,15090,15092,15094,15096,15098,12994,
15100,15102,15104,15106,15108,15110,15112,15114,15116,15118,12996,15120,
15122,15124,15126,15128,15130,15132,15134,15136,15138,12998,15140,15142,
15144,15146,15148,15150,15152,15154,15156,15158,12784,13000,15160,15162,
15164,15166,15168,15170,15172,15174,15176,15178,13002,15180,15182,15184,
15186,15188,15190,15192,15194,15196,15198,13004,15200,15202,15204,15206,
15208,15210,15212,15214,15216,15218,13006,15220,15222,15224,15226,15228,
15230,15232,15234,15236,15238,13008,15240,15242,15244,15246,15248,15250,
15252,15254,15256,15258,13010,15260,15262,15264,15266,15268,15270,15272,
15274,15276,15278,13012,15280,15282,15284,15286,15288,15290,15292,15294,
15296,15298,13014,15300,15302,15304,15306,15308,15310,15312,15314,15316,
15318,13016,15320,15322,15324,15326,15328,15330,15332,15334,15336,15338,
13018,15340,15342,15344,15346,15348,15350,15352,15354,15356,15358,12786,
13020,15360,15362,15364,15366,15368,15370,15372,15374,15376,15378,13022,
15380,15382,15384,15386,15388,15390,15392,15394,15396,15398,13024,15400,
15402,15404,15406,15408,15410,15412,15414,15416,15418,13026,15420,15422,
15424,15426,15428,15430,15432,15434,15436,15438,13028,15440,15442,15444,
15446,15448,15450,15452,15454,15456,15458,13030,15460,15462,15464,15466,
15468,15470,15472,15474,15476,15478,13032,15480,15482,15484,15486,15488,
15490,15492,15494,15496,15498,13034,15500,15502,15504,15506,15508,15510,15512,15514,15516,15518,13036,15520,15522,15524,15526,15528,15530,15532,15534,15536,15538,13038,15540,15542,15544,15546,15548,15550,15552,15554,15556,15558,12788,13040,15560,15562,15564,15566,15568,15570,15572,15574,15576,15578,13042,15580,15582,15584,15586,15588,15590,15592,15594,15596,15598,13044,15600,15602,15604,15606,15608,15610,15612,15614,15616,15618,13046,15620,15622,15624,15626,15628,15630,15632,15634,15636,15638,13048,15640,15642,15644,15646,15648,15650,15652,15654,15656,15658,13050,15660,15662,15664,15666,15668,15670,15672,15674,15676,15678,13052,15680,15682,15684,15686,15688,15690,15692,15694,15696,15698,13054,15700,15702,15704,15706,15708,15710,15712,15714,15716,15718,13056,15720,15722,15724,15726,15728,15730,15732,15734,15736,15738,13058,15740,15742,15744,15746,15748,15750,15752,15754,15756,15758,12790,13060,15760,15762,15764,15766,15768,15770,15772,15774,15776,15778,13062,15780,15782,15784,15786,15788,15790,15792,15794,15796,15798,13064,15800,15802,15804,15806,15808,15810,15812,15814,15816,15818,13066,15820,15822,15824,15826,15828,15830,15832,15834,15836,15838,13068,15840,15842,15844,15846,15848,15850,15852,15854,15856,15858,13070,15860,15862,15864,15866,15868,15870,15872,13072,15874,15876,15878,15880,15882,15884,15886,15888,15890,15892,13074,15894,15896,15898,15900,15902,15904,15906,15908,15910,15912,13076,15914,15916,15918,15920,15922,15924,15926,15928,15930,15932,13078,15934,15936,15938,15940,15942,15944,15946,15948,15950,15952,12792,13080,15954,15956,15958,15960,15962,15964,15966,15968,15970,15972,13082,15974,15976,15978,15980,15982,15984,15986,15988,15990,15992,13084,15994,15996,15998,16000,16002,16004,16006,16008,16010,16012,13086,16014,16016,16018,16020,16022,16024,16026,16028,16030,16032,13088,16034,16036,16038,16040,16042,16044,16046,16048,16050,16052,13090,16054,16056,16058,16060,16062,16064,16066,16068,16070,16072,13092,16074,16076,16078,16080,16082,16084,16086,16088,16090,16092,13094,16094,16096,16098,16100,16102,16104,16106,16108,16110,16112,13096,16114,16116,16118,16120,16122,16124,16126,16128,16130,16132,13098,16134,16136,16138,16140,16142,16144,16146,16148,16150,16152,12794,13100,16154,16156,16158,16160,16162,16164,16166,16168,16170,16172,13102,16174,16176,16178,16180,16182,16184,16186,16188,16190,16192,13104,16194,16196,16198,16200,16202,16204,16206,16208,16210,16212,13106,16214,16216,16218,16220,16222,16224,16226,16228,16230,16232,13108,16234,16236,16238,16240,16242,16244,16246,16248,16250,16252,13110,16254,16256,16258,16260,16262,16264,16266,16268,16270,16272,13112,16274,16276,16278,16280,16282,16284,16286,16288,16290,16292,13114,16294,16296,16298,16300,16302,16304,16306,16308,16310,16312,13116,16314,16316,16318,16320,16322,16324,16326,16328,16330,16332,13118,16334,16336,16338,16340,16342,16344,16346,16348,16350,16352,12796,13120,16354,16356,16358,16360,16362,16364,16366,16368,16370,16372,13122,16374,16376,16378,16380,16382,16384,16386,16388,16390,16392,13124,16394,16396,16398,16400,16402,13126,13128,13130,13132,13134,13136,13138,12798,13140,13142,13144,13146,13148,13150,13152,13154,13156,13158,12764,12800,13160,13162,13164,13166,13168,13170,13172,13174,13176,13178,12802,13180,13182,13184,13186,13188,13190,13192,13194,13196,13198,12804,13200,13202,13204,13206,13208,13210,13212,13214,13216,13218,12806,13220,13222,13224,13226,13228,13230,13232,13234,13236,13238,12808,13240,13242,13244,13246,13248,13250,13252,13254,13256,13258,12810,13260,13262,13264,13266,13268,13270,13272,13274,13276,13278,12812,13280,13282,13284,13286,13288,13290,13292,13294,13296,13298,12814,13300,13302,13304,13306,13308,13310,13312,13314,13316,13318,12816,13320,13322,13324,13326,13328,13330,13332,13334,13336,13338,12818,13340,13342,13344,13346,13348,13350,13352,13354,13356,13358,12766,12820,13360,13362,13364,13366,13368,13370,13372,13374,13376,13378,12822,13380,13382,13384,13386,13388,13390,13392,13394,13396,13398,12824,13400,13402,13404,13406,13408,13410,13412,13414,13416,13418,12826,13420,13422,13424,13426,13428,13430,13432,13434,13436,13438,12828,13440,13442,13444,13446,13448,13450,13452,13454,13456,13458,12830,13460,13462,13464,13466,13468,13470,13472,13474,13476,13478,12832,13480,13482,13484,13486,13488,13490,13492,13494,13496,13498,12834,13500,13502,13504,13506,13508,13510,13512,13514,13516,13518,12836,13520,13522,13524,13526,13528,13530,13532,13534,13536,13538,12838,13540,13542,13544,13546,13548,13550,13552,13554,13556,13558,12768,12840,13560,13562,13564,13566,13568,13570,13572,13574,13576,13578,12842,13580,13582,13584,13586,13588,13590,13592,13594,13596,13598,12844,13600,13602,13604,13606,13608,13610,13612,13614,13616,13618,12846,13620,13622,13624,13626,13628,13630,13632,13634,13636,13638,12848,13640,13642,13644,13646,13648,13650,13652,13654,13656,13658,12850,13660,13662,13664,13666,13668,13670,13672,13674,13676,13678,12852,13680,13682,13684,13686,13688,13690,13692,13694,13696,13698,12854,13700,13702,13704,13706,13708,13710,13712,13714,13716,13718,12856,13720,13722,13724,13726,13728,13730,13732,13734,13736,13738,12858,13740,13742,13744,13746,13748,13750,13752,13754,13756,13758,12770,12860,13760,13762,13764,13766,13768,13770,13772,13774,13776,13778,12862,13780,13782,13784,13786,13788,13790,13792,13794,13796,13798,12864,13800,13802,13804,13806,13808,13810,13812,13814,13816,13818,12866,13820,13822,13824,13826,13828,13830,13832,13834,13836,13838,12868,13840,13842,13844,13846,13848,13850,13852,13854,13856,13858,12870,13860,13862,13864,13866,13868,13870,13872,13874,13876,13878,12872,13880,13882,13884,13886,13888,13890,13892,13894,13896,13898,12874,13900,13902,13904,13906,13908,13910,13912,13914,13916,13918,12876,13920,13922,13924,13926,13928,13930,13932,13934,13936,13938,12878,13940,13942,13944,13946,13948,13950,13952,13954,13956,13958,12772,12880,13960,13962,13964,13966,13968,13970,13972,13974,13976,13978,12882,13980,13982,13984,13986,13988,13990,13992,13994,13996,13998,12884,14000,14002,14004,14006,14008,14010,14012,14014,14016,14018,12886,14020,14022,14024,14026,14028,14030,14032,14034,14036,14038,12888,14040,14042,14044,14046,14048,14050,14052,14054,14056,14058,12890,14060,14062,14064,14066,14068,14070,14072,14074,14076,14078,12892,14080,14082,14084,14086,14088,14090,14092,14094,14096,14098,12894,14100,14102,14104,14106,14108,14110,14112,14114,14116,14118,12896,14120,14122,14124,14126,14128,14130,14132,14134,14136,14138,12898,14140,14142,14144,14146,14148,14150,14152,14154,14156,14158,12774,12900,14160,14162,14164,14166,14168,14170,14172,14174,14176,14178,12902,14180,14182,14184,14186,14188,14190,14192,14194,14196,14198,12904,14200,14202,14204,14206,14208,14210,14212,14214,14216,14218,12906,14220,14222,14224,14226,14228,14230,14232,14234,14236,14238,12908,14240,14242,14244,14246,14248,14250,14252,14254,14256,14258,12910,14260,14262,14264,14266,14268,14270,14272,14274,14276,14278,12912,14280,14282,14284,14286,14288,14290,14292,14294,14296,14298,12914,14300,14302,14304,14306,14308,14310,14312,14314,14316,14318,12916,14320,14322,14324,14326,14328,14330,14332,14334,14336,14338,12918,14340,14342,14344,14346,14348,14350,14352,14354,14356,14358,12776,12920,14360,14362,14364,14366,14368,14370,14372,14374,14376,14378,12922,14380,14382,14384,14386,14388,14390,14392,14394,14396,14398,12924,14400,14402,14404,14406,14408,14410,14412,14414,14416,14418,12926,14420,14422,14424,14426,14428,14430,14432,14434,14436,14438,12928,14440,14442,14444,14446,14448,14450,14452,14454,14456,14458,12930,14460,14462,14464,14466,14468,14470,14472,14474,14476,14478,12932,14480,14482,14484,14486,14488,14490,14492,14494,14496,14498,12934,14500,14502,14504,14506,14508,14510,14512,14514,14516,14518,12936,14520,14522,14524,14526,14528,14530,14532,14534,14536,14538,12938,14540,14542,14544,14546,14548,14550,14552,14554,14556,14558,12778,12940,14560,14562,14564,14566,14568,14570,14572,14574,14576,14578,12942,14580,14582,14584,14586,14588,14590,14592,14594,14596,14598,12944,14600,14602,14604,14606,14608,14610,14612,14614,14616,14618,12946,14620,14622,14624,14626,14628,14630,14632,14634,14636,14638,12948,14640,14642,14644,14646,14648,14650,14652,14654,14656,14658,12950,14660,14662,14664,14666,14668,14670,14672,14674,14676,14678,12952,14680,14682,14684,14686,14688,14690,14692,14694,14696,14698,12954,14700,14702,14704,14706,14708,14710,14712,14714,14716,14718,12956,14720,14722,14724,14726,14728,14730,14732,14734,14736,14738,12958,14740,14742,14744,14746,14748,14750,14752,14754,14756,14758,1,12761,12779,12959,14759,14761,14763,14765,14767,14769,14771,14773,14775,14777,12961,14779,14781,14783,14785,14787,14789,14791,14793,14795,14797,12963,14799,14801,14803,14805,14807,14809,14811,14813,14815,14817,12965,14819,14821,14823,14825,14827,14829,14831,14833,14835,14837,12967,14839,14841,14843,14845,14847,14849,14851,14853,14855,14857,12969,14859,14861,14863,14865,14867,14869,14871,14873,14875,14877,12971,14879,14881,14883,14885,14887,14889,14891,14893,14895,14897,12973,14899,14901,14903,14905,14907,14909,14911,14913,14915,14917,12975,14919,14921,14923,14925,14927,14929,14931,14933,14935,14937,12977,14939,14941,14943,14945,14947,14949,14951,14953,14955,14957,12781,12979,14959,14961,14963,14965,14967,14969,14971,14973,14975,14977,12981,14979,14981,14983,14985,14987,14989,14991,14993,14995,14997,12983,14999,15001,15003,15005,15007,15009,15011,15013,15015,15017,12985,15019,15021,15023,15025,15027,15029,15031,15033,15035,15037,12987,15039,15041,15043,15045,15047,15049,15051,15053,15055,15057,12989,15059,15061,15063,15065,15067,15069,15071,15073,15075,15077,12991,15079,15081,15083,15085,15087,15089,15091,15093,15095,15097,12993,15099,15101,15103,15105,15107,15109,15111,15113,15115,15117,12995,15119,15121,15123,15125,15127,15129,15131,15133,15135,15137,12997,15139,15141,15143,15145,15147,15149,15151,15153,15155,15157,12783,12999,15159,15161,15163,15165,15167,15169,15171,15173,15175,15177,13001,15179,15181,15183,15185,15187,15189,15191,15193,15195,15197,13003,15199,15201,15203,15205,15207,15209,15211,15213,15215,15217,13005,15219,15221,15223,15225,15227,15229,15231,15233,15235,15237,13007,15239,15241,15243,15245,15247,15249,15251,15253,15255,15257,13009,15259,15261,15263,15265,15267,15269,15271,15273,15275,15277,13011,15279,15281,15283,15285,15287,15289,15291,15293,15295,15297,13013,15299,15301,15303,15305,15307,15309,15311,15313,15315,15317,13015,15319,15321,15323,15325,15327,15329,15331,15333,15335,15337,13017,15339,15341,15343,15345,15347,15349,15351,15353,15355,15357,12785,13019,15359,15361,15363,15365,15367,15369,15371,15373,15375,15377,13021,15379,15381,15383,15385,15387,15389,15391,15393,15395,15397,13023,15399,15401,15403,15405,15407,15409,15411,15413,15415,15417,13025,15419,15421,15423,15425,15427,15429,15431,15433,15435,15437,13027,15439,15441,15443,15445,15447,15449,15451,15453,15455,15457,13029,15459,15461,15463,15465,15467,15469,15471,15473,15475,15477,13031,15479,15481,15483,15485,15487,15489,15491,15493,15495,15497,13033,15499,15501,15503,15505,15507,15509,15511,15513,15515,15517,13035,15519,15521,15523,15525,15527,15529,15531,15533,15535,15537,13037,15539,15541,15543,15545,15547,15549,15551,15553,15555,15557,12787,13039,15559,15561,15563,15565,15567,15569,15571,15573,15575,15577,13041,15579,15581,15583,15585,15587,15589,15591,15593,15595,15597,13043,15599,15601,15603,15605,15607,15609,15611,15613,15615,15617,13045,15619,15621,15623,15625,15627,15629,15631,15633,15635,15637,13047,15639,15641,15643,15645,15647,15649,15651,15653,15655,15657,13049,15659,15661,15663,15665,15667,15669,15671,15673,15675,15677,13051,15679,15681,15683,15685,15687,15689,15691,15693,15695,15697,13053,15699,15701,15703,15705,15707,15709,15711,15713,15715,15717,13055,15719,15721,15723,15725,15727,15729,15731,15733,15735,15737,13057,15739,15741,15743,15745,15747,15749,15751,15753,15755,15757,12789,13059,15759,15761,15763,15765,15767,15769,15771,15773,15775,15777,13061,15779,15781,15783,15785,15787,15789,15791,15793,15795,15797,13063,15799,15801,15803,15805,15807,15809,15811,15813,15815,15817,13065,15819,15821,15823,15825,15827,15829,15831,15833,15835,15837,13067,15839,15841,15843,15845,15847,15849,15851,15853,15855,15857,13069,15859,15861,15863,15865,15867,15869,15871,13071,15873,15875,15877,15879,15881,15883,15885,15887,15889,15891,13073,15893,15895,15897,15899,15901,15903,15905,15907,15909,15911,13075,15913,15915,15917,15919,15921,15923,15925,15927,15929,15931,13077,15933,15935,15937,15939,15941,15943,15945,15947,15949,15951,12791,13079,15953,15955,15957,15959,15961,15963,15965,15967,15969,15971,13081,15973,15975,15977,15979,15981,15983,15985,15987,15989,15991,13083,15993,15995,15997,15999,16001,16003,16005,16007,16009,16011,13085,16013,16015,16017,16019,16021,16023,16025,16027,16029,16031,13087,16033,16035,16037,16039,16041,16043,16045,16047,16049,16051,13089,16053,16055,16057,16059,16061,16063,16065,16067,16069,16071,13091,16073,16075,16077,16079,16081,16083,16085,16087,16089,16091,13093,16093,16095,16097,16099,16101,16103,16105,16107,16109,16111,13095,16113,16115,16117,16119,16121,16123,16125,16127,16129,16131,13097,16133,16135,16137,16139,16141,16143,16145,16147,16149,16151,12793,13099,16153,16155,16157,16159,16161,16163,16165,16167,16169,16171,13101,16173,16175,16177,16179,16181,16183,16185,16187,16189,16191,13103,16193,16195,16197,16199,16201,16203,16205,16207,16209,16211,13105,16213,16215,16217,16219,16221,16223,16225,16227,16229,16231,13107,16233,16235,16237,16239,16241,16243,16245,16247,16249,16251,13109,16253,16255,16257,16259,16261,16263,16265,16267,16269,16271,13111,16273,16275,16277,16279,16281,16283,16285,16287,16289,16291,13113,16293,16295,16297,16299,16301,16303,16305,16307,16309,16311,13115,16313,16315,16317,16319,16321,16323,16325,16327,16329,16331,13117,16333,16335,16337,16339,16341,16343,16345,16347,16349,16351,12795,13119,16353,16355,16357,16359,16361,16363,16365,16367,16369,16371,13121,16373,16375,16377,16379,16381,16383,16385,16387,16389,16391,13123,16393,16395,16397,16399,16401,13125,13127,13129,13131,13133,13135,13137,12797,13139,13141,13143,13145,13147,13149,13151,13153,13155,13157,12763,12799,13159,13161,13163,13165,13167,13169,13171,13173,13175,13177,12801,13179,13181,13183,13185,13187,13189,13191,13193,13195,13197,12803,13199,13201,13203,13205,13207,13209,13211,13213,13215,13217,12805,13219,13221,13223,13225,13227,13229,13231,13233,13235,13237,12807,13239,13241,13243,13245,13247,13249,13251,13253,13255,13257,12809,13259,13261,13263,13265,13267,13269,13271,13273,13275,13277,12811,13279,13281,13283,13285,13287,13289,13291,13293,13295,13297,12813,13299,13301,13303,13305,13307,13309,13311,13313,13315,13317,12815,13319,13321,13323,13325,13327,13329,13331,13333,13335,13337,12817,13339,13341,13343,13345,13347,13349,13351,13353,13355,13357,12765,12819,13359,13361,13363,13365,13367,13369,13371,13373,13375,13377,12821,13379,13381,13383,13385,13387,13389,13391,13393,13395,13397,12823,13399,13401,13403,13405,13407,13409,13411,13413,13415,13417,12825,13419,13421,13423,13425,13427,13429,13431,13433,13435,13437,12827,13439,13441,13443,13445,13447,13449,13451,13453,13455,13457,12829,13459,13461,13463,13465,13467,13469,13471,13473,13475,13477,12831,13479,13481,13483,13485,13487,13489,13491,13493,13495,13497,12833,13499,13501,13503,13505,13507,13509,13511,13513,13515,13517,12835,13519,13521,13523,13525,13527,13529,13531,13533,13535,13537,12837,13539,13541,13543,13545,13547,13549,13551,13553,13555,13557,12767,12839,13559,13561,13563,13565,13567,13569,13571,13573,13575,13577,12841,13579,13581,13583,13585,13587,13589,13591,13593,13595,13597,12843,13599,13601,13603,13605,13607,13609,13611,13613,13615,13617,12845,13619,13621,13623,13625,13627,13629,13631,13633,13635,13637,12847,13639,13641,13643,13645,13647,13649,13651,13653,13655,13657,12849,13659,13661,13663,13665,13667,13669,13671,13673,13675,13677,12851,13679,13681,13683,13685,13687,13689,13691,13693,13695,13697,12853,13699,13701,13703,13705,13707,13709,13711,13713,13715,13717,12855,13719,13721,13723,13725,13727,13729,13731,13733,13735,13737,12857,13739,13741,13743,13745,13747,13749,13751,13753,13755,13757,12769,12859,13759,13761,13763,13765,13767,13769,13771,13773,13775,13777,12861,13779,13781,13783,13785,13787,13789,13791,13793,13795,13797,12863,13799,13801,13803,13805,13807,13809,13811,13813,13815,13817,12865,13819,13821,13823,13825,13827,13829,13831,13833,13835,13837,12867,13839,13841,13843,13845,13847,13849,13851,13853,13855,13857,12869,13859,13861,13863,13865,13867,13869,13871,13873,13875,13877,12871,13879,13881,13883,13885,13887,13889,13891,13893,13895,13897,12873,13899,13901,13903,13905,13907,13909,13911,13913,13915,13917,12875,13919,13921,13923,13925,13927,13929,13931,13933,13935,13937,12877,13939,13941,13943,13945,13947,13949,13951,13953,13955,13957,12771,12879,13959,13961,13963,13965,13967,13969,13971,13973,13975,13977,12881,13979,13981,13983,13985,13987,13989,13991,13993,13995,13997,12883,13999,14001,14003,14005,14007,14009,14011,14013,14015,14017,12885,14019,14021,14023,14025,14027,14029,14031,14033,14035,14037,12887,14039,14041,14043,14045,14047,14049,14051,14053,14055,14057,12889,14059,14061,14063,14065,14067,14069,14071,14073,14075,14077,12891,14079,14081,14083,14085,14087,14089,14091,14093,14095,14097,12893,14099,14101,14103,14105,14107,14109,14111,14113,14115,14117,12895,14119,14121,14123,14125,14127,14129,14131,14133,14135,14137,12897,14139,14141,14143,14145,14147,14149,14151,14153,14155,14157,12773,12899,14159,14161,14163,14165,14167,14169,14171,14173,14175,14177,12901,14179,14181,14183,14185,14187,14189,14191,14193,14195,14197,12903,14199,14201,14203,14205,14207,14209,14211,14213,14215,14217,12905,14219,14221,14223,14225,14227,14229,14231,14233,14235,14237,12907,14239,14241,14243,14245,14247,14249,14251,14253,14255,14257,12909,14259,14261,14263,14265,14267,14269,14271,14273,14275,14277,12911,14279,14281,14283,14285,14287,14289,14291,14293,14295,14297,12913,14299,14301,14303,14305,14307,14309,14311,14313,14315,14317,12915,14319,14321,14323,14325,14327,14329,14331,14333,14335,14337,12917,14339,14341,14343,14345,14347,14349,14351,14353,14355,14357,12775,12919,14359,14361,14363,14365,14367,14369,14371,14373,14375,14377,12921,14379,14381,14383,14385,14387,14389,14391,14393,14395,14397,12923,14399,14401,14403,14405,14407,14409,14411,14413,14415,14417,12925,14419,14421,14423,14425,14427,14429,14431,14433,14435,14437,12927,14439,14441,14443,14445,14447,14449,14451,14453,14455,14457,12929,14459,14461,14463,14465,14467,14469,14471,14473,14475,14477,12931,14479,14481,14483,14485,14487,14489,14491,14493,14495,14497,12933,14499,14501,14503,14505,14507,14509,14511,14513,14515,14517,12935,14519,14521,14523,14525,14527,14529,14531,14533,14535,14537,12937,14539,14541,14543,14545,14547,14549,14551,14553,14555,14557,12777,12939,14559,14561,14563,14565,14567,14569,14571,14573,14575,14577,12941,14579,14581,14583,14585,14587,14589,14591,14593,14595,14597,12943,14599,14601,14603,14605,14607,14609,14611,14613,14615,14617,12945,14619,14621,14623,14625,14627,14629,14631,14633,14635,14637,12947,14639,14641,14643,14645,14647,14649,14651,14653,14655,14657,12949,14659,14661,14663,14665,14667,14669,14671,14673,14675,14677,12951,14679,14681,14683,14685,14687,14689,14691,14693,14695,14697,12953,14699,14701,14703,14705,14707,14709,14711,14713,14715,14717,12955,14719,14721,14723,14725,14727,14729,14731,14733,14735,14737,12957,14739,14741,14743,14745,14747,14749,14751,14753,14755,14757 )

) AND u.userid <> '/Anonymous' ORDER BY u.userid asc LIMIT 0, 25


I AM SHOCKED!! I wonder what those idst number represents?
User avatar
alberto
FormaLms Guru
Posts: 1152
Joined: Fri Mar 02, 2012 9:18 am
Contact:

Re: Large scale docebo installation

Post by alberto »

With more than 14.000k users you need a cluster server, of course with 200.000 registered users you need a specific hardware infrastructure. What are you trying to do?

That query exctracts the user list, the idst ar the user ids...what are you shocked for?
User avatar
tuanmaster
FormaLms User
Posts: 72
Joined: Thu Oct 03, 2013 6:59 am

Re: Large scale docebo installation

Post by tuanmaster »

I hope Alberto and your company have solution for this problem without add more server, I want just have one Server, not more.
User avatar
max
FormaLms Guru
Posts: 2761
Joined: Thu Mar 01, 2012 10:41 am
Version: forma.lms 2.4
Contact:

Re: Large scale docebo installation

Post by max »

Hi Tuan,
Actually this thread is not about a problem to be fixed. It's about how to manage the system of you have more than 15-20.000 users.
In that case, you need a cluster server. If you don't have that many users, then you are ok with one.
---------------------
Massimiliano Ferrari
Elearnit - Elearning e Knowledge Management
https://www.elearnit.net
https://www.linkedin.com/in/massimilianoferrari
m.ferrari[at]elearnit.net
Skype: m_ferrari_it
User avatar
tuanmaster
FormaLms User
Posts: 72
Joined: Thu Oct 03, 2013 6:59 am

Re: Large scale docebo installation

Post by tuanmaster »

Yes, I know this thread is not a problem. I just hope/think you find one solution (or guide our install) to one server can run with >20.000 users, :)
User avatar
alberto
FormaLms Guru
Posts: 1152
Joined: Fri Mar 02, 2012 9:18 am
Contact:

Re: Large scale docebo installation

Post by alberto »

There can't be a guide for such an installation, because server configuration may vary a lot depending on several conditions. Type and real amount of traffic generated, type of OS, and so on. In any case, I suggest to use a cluster solution and not single server. Please contact a server specialist to find the right configuration for your needs.
Post Reply