{"id":87814,"date":"2020-07-10T13:42:14","date_gmt":"2020-07-10T11:42:14","guid":{"rendered":"https:\/\/prohoster.info\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy"},"modified":"2020-07-10T13:42:14","modified_gmt":"2020-07-10T11:42:14","slug":"chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","status":"publish","type":"post","link":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","title":{"rendered":"Co je lep\u0161\u00ed \u2013 Oracle nebo Redis, nebo jak od\u016fvodnit v\u00fdb\u011br platformy","gt_translate_keys":[{"key":"rendered","format":"text"}]},"content":{"rendered":"<blockquote><p>\u2013 To je n\u011bco, \u2013 \u0159ekla nahlas, ani\u017e by se na n\u011bkoho obr\u00e1tila. \u2013 To je n\u011bco! Tak p\u0159\u00edmo naps\u00e1no \u2013 hlavn\u00edm \u00fakolem spole\u010dnosti je z\u00edsk\u00e1v\u00e1n\u00ed zisku v z\u00e1jmu akcion\u00e1\u0159\u016f. Tak si to promyslete! Nic se neboj\u00ed!<\/p>\n<p><i>Julij Dubov, \u201eMen\u0161\u00ed zlo\u201c<\/i><\/p><\/blockquote>\n<p>\nKdy\u017e uvid\u00edte takov\u00fd titulek, pravd\u011bpodobn\u011b u\u017e m\u00e1te za to, \u017ee \u010dl\u00e1nek je \u2013 bu\u010f hloupost, nebo provokace. Ale nesp\u011bchejte se z\u00e1v\u011bry: zam\u011bstnanci velk\u00fdch korporac\u00ed, zvl\u00e1\u0161t\u011b t\u011bch, kter\u00e9 maj\u00ed st\u00e1tn\u00ed \u00fa\u010dast, se docela \u010dasto mus\u00ed srovn\u00e1vat r\u016fzn\u00e9 platformy, v\u010detn\u011b zcela odli\u0161n\u00fdch \u2013 nap\u0159\u00edklad jako ty, kter\u00e9 jsou zm\u00edn\u011bny v titulku.<\/p>\n<p><img decoding=\"async\" alt=\"Co je lep\u0161\u00ed \u2013 Oracle nebo Redis, nebo jak od\u016fvodnit v\u00fdb\u011br platformy\" src=\"\/wp-content\/uploads\/2020\/07\/6b0c0a3a60794b2a9e98733e59eec6da.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nSamoz\u0159ejm\u011b, \u017ee se S\u0158BD tak nikdo nesrovn\u00e1v\u00e1, proto\u017ee jejich siln\u00e9 a slab\u00e9 str\u00e1nky jsou dob\u0159e zn\u00e1m\u00e9. Obvykle se srovn\u00e1vaj\u00ed platformy, kter\u00e9 \u0159e\u0161\u00ed n\u011bjak\u00fd praktick\u00fd \u00fakol. V \u010dl\u00e1nku uk\u00e1\u017eu metodiku, kter\u00e1 se p\u0159i tom pou\u017e\u00edv\u00e1, na p\u0159\u00edkladu datab\u00e1z\u00ed jako p\u0159edm\u011btu, kter\u00fd je \u010dten\u00e1\u0159\u016fm Habra zn\u00e1m. Tak\u017ee,<br \/>\n<noindex><a rel=\"nofollow\" name=\"habracut\"><\/a><\/noindex><\/p>\n<h4>Motivace<\/h4>\n<p>\nKdy\u017e za\u010d\u00edn\u00e1te vzd\u011bl\u00e1vac\u00ed projekt nebo projekt kon\u00ed\u010dek, motivace pro v\u00fdb\u011br platformy m\u016f\u017ee b\u00fdt velmi rozmanit\u00e1: \u201etuto platformu zn\u00e1m nejl\u00e9pe\u201c, \u201es touto m\u011b zaj\u00edm\u00e1 zab\u00fdvat se\u201c, \u201etady je nejlep\u0161\u00ed dokumentace\u201c\u2026 V p\u0159\u00edpad\u011b komer\u010dn\u00ed spole\u010dnosti je krit\u00e9rium v\u00fdb\u011bru jedin\u00e9: kolik bude t\u0159eba zaplatit a co za ty pen\u00edze dostanu.<\/p>\n<p>P\u0159irozen\u011b, cht\u011blo by se zaplatit m\u00e9n\u011b a dostat v\u00edce. Je v\u0161ak t\u0159eba rozhodnout, co je d\u016fle\u017eit\u011bj\u0161\u00ed \u2013 zaplatit m\u00e9n\u011b nebo dostat v\u00edce, a p\u0159i\u0159adit ka\u017ed\u00e9mu uzlu v\u00e1hu. P\u0159edpokl\u00e1dejme, \u017ee n\u00e1m z\u00e1le\u017e\u00ed na kvalitn\u00edm \u0159e\u0161en\u00ed v\u00edce ne\u017e na levn\u00e9m, a p\u0159i\u0159ad\u00edme uzlu \u201eCena\u201c v\u00e1hu 40 %, zat\u00edmco uzlu \u201eMo\u017enosti\u201c 60 %.<\/p>\n<p><img decoding=\"async\" alt=\"Co je lep\u0161\u00ed \u2013 Oracle nebo Redis, nebo jak od\u016fvodnit v\u00fdb\u011br platformy\" src=\"\/wp-content\/uploads\/2020\/07\/b3ba842198428e7de98f3b5a27591d43.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nVe velk\u00fdch korporac\u00edch je obvykle v\u0161e naopak \u2013 v\u00e1ha n\u00e1klad\u016f nekles\u00e1 pod 50 %, a m\u016f\u017ee b\u00fdt i v\u00edce ne\u017e 60 %. V modelov\u00e9m p\u0159\u00edkladu je d\u016fle\u017eit\u00e9 pouze to, \u017ee celkov\u00e1 v\u00e1ha pod\u0159\u00edzen\u00fdch uzl\u016f jak\u00e9hokoli rodi\u010dovsk\u00e9ho uzlu mus\u00ed b\u00fdt 100 %.<\/p>\n<h4>Omezeni podm\u00ednkami<\/h4>\n<p>\nWebu <noindex><a rel=\"nofollow\" href=\"https:\/\/db-engines.com\/\">db-engines.com<\/a><\/noindex> je zn\u00e1mo p\u0159ibli\u017en\u011b 500 syst\u00e9m\u016f pro spr\u00e1vu datab\u00e1z\u00ed. P\u0159irozen\u011b, pokud vyb\u00edr\u00e1te c\u00edlovou platformu z takov\u00e9ho mno\u017estv\u00ed mo\u017enost\u00ed, m\u016f\u017ee vzniknout p\u0159ehledov\u00fd \u010dl\u00e1nek, ale ne komer\u010dn\u00ed projekt. Aby se z\u00fa\u017eil prostor v\u00fdb\u011bru, formuluj\u00ed se omezuj\u00edc\u00ed krit\u00e9ria, a pokud platforma t\u011bmto krit\u00e9ri\u00edm nevyhovuje, nebere se v \u00favahu.<\/p>\n<p>Krit\u00e9ria vylou\u010den\u00ed mohou souviset s technick\u00fdmi vlastnostmi, nap\u0159\u00edklad:<\/p>\n<ul>\n<li>z\u00e1ruky ACID;<\/li>\n<li>rela\u010dn\u00ed datov\u00fd model;<\/li>\n<li>podpora jazyka SQL (vezm\u011bte pros\u00edm na v\u011bdom\u00ed, \u017ee to nen\u00ed tot\u00e9\u017e jako \u201erela\u010dn\u00ed model\u201c);<\/li>\n<li>mo\u017enost horizont\u00e1ln\u00edho \u0161k\u00e1lov\u00e1n\u00ed.<\/li>\n<\/ul>\n<p>\nMohou existovat krit\u00e9ria obecn\u00e9ho charakteru:<\/p>\n<ul>\n<li>p\u0159\u00edtomnost komer\u010dn\u00ed podpory v \u010cesku;<\/li>\n<li>otev\u0159en\u00fd zdrojov\u00fd k\u00f3d;<\/li>\n<li>p\u0159\u00edtomnost platformy v registru Ministerstva dopravy;<\/li>\n<li>p\u0159\u00edtomnost platformy v n\u011bjak\u00e9m hodnocen\u00ed (nap\u0159\u00edklad v prvn\u00ed stovce hodnocen\u00ed na db-engines.com);<\/li>\n<li>p\u0159\u00edtomnost expert\u016f na trhu (nap\u0159\u00edklad podle v\u00fdsledk\u016f hled\u00e1n\u00ed n\u00e1zvu platformy v\u00a0\u017eivotopisech na str\u00e1nk\u00e1ch hh.ru).<\/li>\n<\/ul>\n<p>\nNakonec mohou existovat krit\u00e9ria specifick\u00e1 pro podnik:<\/p>\n<ul>\n<li>p\u0159\u00edtomnost specialist\u016f v t\u00fdmu;<\/li>\n<li>kompatibilita se syst\u00e9mem monitorov\u00e1n\u00ed X nebo se syst\u00e9mem z\u00e1lohov\u00e1n\u00ed Y, na kter\u00fd je nav\u00e1z\u00e1na ve\u0161ker\u00e1 podpora\u2026<\/li>\n<\/ul>\n<p>\nNejd\u016fle\u017eit\u011bj\u0161\u00ed je, aby existoval seznam vylu\u010duj\u00edc\u00edch krit\u00e9ri\u00ed. Jinak v\u017edy existuje n\u011bjak\u00fd expert (nebo \u201eexpert\u201c), kter\u00fd m\u00e1 zvl\u00e1\u0161tn\u00ed d\u016fv\u011bru veden\u00ed, a \u0159ekne: \u201ePro\u010d jste nevybrali platformu Z, v\u00edm, \u017ee je nejlep\u0161\u00ed.\u201c <\/p>\n<h4>Ohodnocen\u00ed n\u00e1klad\u016f<\/h4>\n<p>\nN\u00e1klady na \u0159e\u0161en\u00ed se skl\u00e1daj\u00ed z n\u00e1klad\u016f na licence, n\u00e1klad\u016f na \u00fadr\u017ebu a\u00a0n\u00e1klad\u016f na hardware.<\/p>\n<p>Pokud jsou syst\u00e9my zhruba stejn\u00e9 t\u0159\u00eddy (nap\u0159\u00edklad Microsoft SQL Server a PostgreSQL), pak pro zjednodu\u0161en\u00ed m\u016f\u017eeme pova\u017eovat, \u017ee mno\u017estv\u00ed hardware pro ob\u011b \u0159e\u0161en\u00ed bude zhruba stejn\u00e9. To u\u0161et\u0159\u00ed hodnocen\u00ed hardwaru, \u010d\u00edm\u017e se u\u0161et\u0159\u00ed hodn\u011b \u010dasu a \u00fasil\u00ed. Pokud je v\u0161ak nutn\u00e9 porovn\u00e1vat zcela odli\u0161n\u00e9 syst\u00e9my (nap\u0159\u00edklad Oracle vs. Redis), je z\u0159ejm\u00e9, \u017ee pro spr\u00e1vn\u00e9 posouzen\u00ed je t\u0159eba prov\u00e9st sizing (v\u00fdpo\u010det mno\u017estv\u00ed hardwaru). Sizing neexistuj\u00edc\u00edho syst\u00e9mu je velice vd\u011b\u010dn\u00e1 \u010dinnost, a proto se s takov\u00fdmi porovn\u00e1n\u00edmi sna\u017e\u00edme vyvarovat. Je to jednoduch\u00e9: v podm\u00ednk\u00e1ch vylou\u010den\u00ed jsou uvedeny nulov\u00e9 ztr\u00e1ty dat a rela\u010dn\u00ed model, nebo naopak - zat\u00ed\u017een\u00ed 50 tis\u00edc transakc\u00ed za sekundu.<\/p>\n<p>Pro ocen\u011bn\u00ed licenc\u00ed sta\u010d\u00ed po\u017e\u00e1dat dodavatele nebo jeho partnery o cenu licence na pevn\u00fd po\u010det jader a podpory na pevn\u00e9 obdob\u00ed. Obvykle maj\u00ed spole\u010dnosti ji\u017e vybudovan\u00e9 siln\u00e9 vztahy s dodavateli softwaru, a pokud odd\u011blen\u00ed spr\u00e1vy datab\u00e1z\u00ed nedok\u00e1\u017ee na ot\u00e1zku o cen\u011b odpov\u011bd\u011bt samo, sta\u010d\u00ed k z\u00edsk\u00e1n\u00ed t\u00e9to informace jedno e-mailov\u00e9 zpr\u00e1vy.<\/p>\n<p>R\u016fzn\u00ed dodavatel\u00e9 mohou m\u00edt r\u016fzn\u00e9 metriky licencov\u00e1n\u00ed: podle po\u010dtu jader, objemu dat nebo po\u010dtu uzl\u016f. Z\u00e1lo\u017en\u00ed datab\u00e1ze m\u016f\u017ee b\u00fdt zdarma, nebo m\u016f\u017ee b\u00fdt licencov\u00e1na stejn\u011b jako hlavn\u00ed. Pokud se objev\u00ed n\u011bjak\u00e9 rozd\u00edly v metrik\u00e1ch, bude nutn\u00e9 podrobn\u011b popsat modelov\u00fd stojan a spo\u010d\u00edtat n\u00e1klady na licence pro stojan.<\/p>\n<p>D\u016fle\u017eit\u00fd bod pro spr\u00e1vn\u00e9 srovn\u00e1n\u00ed \u2013 stejn\u00e9 podm\u00ednky podpory. \u0158ekn\u011bme, \u017ee podpora Oracle stoj\u00ed 22 % z ceny licence za rok, zat\u00edmco za podporu PostgreSQL nemus\u00edte platit. Je takov\u00e9 srovn\u00e1n\u00ed spr\u00e1vn\u00e9? Ne, proto\u017ee d\u016fsledky chyby, kterou nelze vy\u0159e\u0161it vlastn\u00edmi silami, jsou zcela odli\u0161n\u00e9: v prvn\u00edm p\u0159\u00edpad\u011b odborn\u00edci podpory rychle pomohou probl\u00e9m vy\u0159e\u0161it, zat\u00edmco ve druh\u00e9m p\u0159\u00edpad\u011b hroz\u00ed zpo\u017ed\u011bn\u00ed projektu nebo v\u00fdpadek hotov\u00e9ho syst\u00e9mu na neur\u010ditou dobu.<\/p>\n<p>Podm\u00ednky v\u00fdpo\u010dtu lze vyrovnat t\u0159emi zp\u016fsoby:<\/p>\n<ol>\n<li>Pou\u017e\u00edt Oracle bez podpory (v realit\u011b se to nest\u00e1v\u00e1).<\/li>\n<li>Koupit podporu na PostgreSQL \u2013 nap\u0159\u00edklad od spole\u010dnosti Postgres Professional.<\/li>\n<li>Zahrnout do v\u00fdpo\u010dt\u016f rizika spojen\u00e1 s absenc\u00ed podpory.<\/li>\n<\/ol>\n<p>\nNap\u0159\u00edklad v\u00fdpo\u010det rizik m\u016f\u017ee vypadat takto: v p\u0159\u00edpad\u011b neodstraniteln\u00e9ho selh\u00e1n\u00ed datab\u00e1ze \u010din\u00ed v\u00fdpadek syst\u00e9mu 1 pracovn\u00ed den. O\u010dek\u00e1van\u00fd zisk z vyu\u017e\u00edv\u00e1n\u00ed syst\u00e9mu \u010din\u00ed 40 miliard mongolsk\u00fdch tugrik\u016f ro\u010dn\u011b, frekvence hav\u00e1ri\u00ed se odhaduje na 1\/400, t\u00edm p\u00e1dem je riziko absence \u00fadr\u017eby odhadov\u00e1no p\u0159ibli\u017en\u011b na 100 milion\u016f mongolsk\u00fdch tugrik\u016f ro\u010dn\u011b. Je z\u0159ejm\u00e9, \u017ee 'o\u010dek\u00e1van\u00fd zisk' a 'odhadovan\u00e1 frekvence hav\u00e1ri\u00ed' jsou virtu\u00e1ln\u00ed hodnoty, ale je rozhodn\u011b lep\u0161\u00ed m\u00edt takov\u00fd model, ne\u017e \u017e\u00e1dn\u00fd.<\/p>\n<p>Ve skute\u010dnosti m\u016f\u017ee b\u00fdt syst\u00e9m p\u0159\u00edli\u0161 d\u016fle\u017eit\u00fd, a reputa\u010dn\u00ed ztr\u00e1ty zp\u016fsoben\u00e9 dlouh\u00fdm v\u00fdpadkem se uk\u00e1\u017eou jako nep\u0159ijateln\u00e9, proto bude pot\u0159ebn\u00e1 podpora. Pokud v\u0161ak v\u00fdpadek je p\u0159ijateln\u00fd, m\u016f\u017ee b\u00fdt odm\u00edtnut\u00ed podpory n\u011bkdy dobr\u00fdm zp\u016fsobem, jak u\u0161et\u0159it.<\/p>\n<p>P\u0159edpokl\u00e1dejme, \u017ee po v\u0161ech v\u00fdpo\u010dtech se n\u00e1klady na provoz platformy A za 5 let uk\u00e1zaly b\u00fdt 800 milion\u016f mongolsk\u00fdch tugrik\u016f, n\u00e1klady na provoz platformy B \u2013 650 milion\u016f tugrik\u016f a n\u00e1klady na provoz platformy C \u2013 600 milion\u016f tugrik\u016f. Platforma C jako v\u00edt\u011bz z\u00edsk\u00e1v\u00e1 za cenu pln\u00fd bod, whereas platformy A a B dost\u00e1vaj\u00ed o n\u011bco m\u00e9n\u011b bod\u016f, propor\u010dn\u011b k tomu, jak moc jsou dra\u017e\u0161\u00ed. V tomto p\u0159\u00edpad\u011b \u2013 0,75 a 0,92 bod\u016f.<\/p>\n<h4>Hodnocen\u00ed schopnost\u00ed<\/h4>\n<p>\nHodnocen\u00ed schopnost\u00ed se d\u011bl\u00ed na r\u016fzn\u00e9 skupiny, jejich\u017e po\u010det je omezen pouze fantazi\u00ed toho, kdo hodnocen\u00ed prov\u00e1d\u00ed. Optim\u00e1ln\u00edm \u0159e\u0161en\u00edm se zd\u00e1 b\u00fdt rozd\u011blen\u00ed schopnost\u00ed podle t\u00fdm\u016f, kter\u00e9 tyto schopnosti budou vyu\u017e\u00edvat; v na\u0161em p\u0159\u00edkladu to jsou v\u00fdvoj\u00e1\u0159i, administr\u00e1to\u0159i a specialist\u00e9 na informa\u010dn\u00ed bezpe\u010dnost. P\u0159edpokl\u00e1dejme, \u017ee v\u00e1hy t\u011bchto funkc\u00ed jsou rozd\u011bleny jako 40:40:20.<\/p>\n<p>Mezi funkce v\u00fdvoje pat\u0159\u00ed:<\/p>\n<ul>\n<li>pohodl\u00ed manipulace s daty;<\/li>\n<li>\u0161k\u00e1lovatelnost;<\/li>\n<li>existence sekund\u00e1rn\u00edch index\u016f.<\/li>\n<\/ul>\n<p>\nSeznam krit\u00e9ri\u00ed, stejn\u011b jako jejich v\u00e1hy, je velmi subjektivn\u00ed. I p\u0159i \u0159e\u0161en\u00ed stejn\u00e9ho \u00fakolu se tyto seznamy, v\u00e1hy polo\u017eek a odpov\u011bdi budou podstatn\u011b li\u0161it v z\u00e1vislosti na slo\u017een\u00ed va\u0161eho t\u00fdmu. Nap\u0159\u00edklad Facebook pro ukl\u00e1d\u00e1n\u00ed dat pou\u017e\u00edv\u00e1 MySQL, zat\u00edmco Instagram je postaven na b\u00e1z\u00ed Cassandra. Je nepravd\u011bpodobn\u00e9, \u017ee by v\u00fdvoj\u00e1\u0159i t\u011bchto aplikac\u00ed vyplnili takov\u00e9 tabulky. M\u016f\u017eeme se jen domn\u00edvat, \u017ee Mark Zuckerberg zvolil pln\u011b rela\u010dn\u00ed model, co\u017e si vy\u017e\u00e1dalo pot\u0159ebnost aplika\u010dn\u00edho shardingu, zat\u00edmco Kevin Systrom vsadil na \u0161k\u00e1lovatelnost prost\u0159edky platformy a ob\u011btoval pohodl\u00ed p\u0159\u00edstupu k dat\u016fm.<\/p>\n<p>Mezi funkce spr\u00e1vy pat\u0159\u00ed:<\/p>\n<ul>\n<li>schopnosti syst\u00e9mu z\u00e1lohov\u00e1n\u00ed;<\/li>\n<li>pohodl\u00ed monitorov\u00e1n\u00ed;<\/li>\n<li>pohodl\u00ed spr\u00e1vy kapacit \u2013 disk\u016f a uzl\u016f;<\/li>\n<li>schopnosti replikace dat.<\/li>\n<\/ul>\n<p>\nV\u0161imn\u011bte si, \u017ee formulace ot\u00e1zek by m\u011bla umo\u017e\u0148ovat kvantitativn\u00ed hodnocen\u00ed. M\u016f\u017eete se dokonce dohodnout, jak hodnotit ur\u010ditou funkci. Zkusme nap\u0159\u00edklad ohodnotit n\u00e1stroje pro z\u00e1lohov\u00e1n\u00ed na p\u0159\u00edkladu n\u00e1stroj\u016f dod\u00e1van\u00fdch s datab\u00e1zov\u00fdm syst\u00e9mem Oracle:<\/p>\n<p>N\u00e1klad<br \/>\nKoment\u00e1\u0159<br \/>\nHodnocen\u00ed<\/p>\n<p>imp\/exp<br \/>\nExport a import dat<br \/>\n0.1<\/p>\n<p>begin\/end backup<br \/>\nKop\u00edrov\u00e1n\u00ed soubor\u016f<br \/>\n0.3<\/p>\n<p>RMAN<br \/>\nMo\u017enost inkrement\u00e1ln\u00edho kop\u00edrov\u00e1n\u00ed<br \/>\n0.7<\/p>\n<p>ZDLRA<br \/>\nPouze inkrement\u00e1ln\u00ed kop\u00edrov\u00e1n\u00ed, nejrychlej\u0161\u00ed obnova do bodu<br \/>\n1.0<\/p>\n<p>\nPokud chyb\u00ed jasn\u00e1 krit\u00e9ria hodnocen\u00ed, m\u00e1 smysl po\u017e\u00e1dat n\u011bkolik odborn\u00edk\u016f, aby poskytli hodnocen\u00ed, a pot\u00e9 je pr\u016fm\u011brovat.<\/p>\n<p>Nakonec pouze vyjmenujeme funkce informa\u010dn\u00ed bezpe\u010dnosti:<\/p>\n<ul>\n<li>existence politiky spr\u00e1vy hesel;<\/li>\n<li>mo\u017enost p\u0159ipojen\u00ed extern\u00edch autentiza\u010dn\u00edch prost\u0159edk\u016f (LDAP, Kerberos);<\/li>\n<li>role-based access model;<\/li>\n<li>mo\u017enosti auditu;<\/li>\n<li>\u0161ifrov\u00e1n\u00ed dat na disku;<\/li>\n<li>\u0161ifrov\u00e1n\u00ed p\u0159i p\u0159enosu po s\u00edti (TLS);<\/li>\n<li>ochrana dat p\u0159ed administr\u00e1torem.<\/li>\n<\/ul>\n<p><\/p>\n<h4>Testov\u00e1n\u00ed v\u00fdkonu<\/h4>\n<p>\nR\u00e1d bych zvl\u00e1\u0161\u0165 varoval p\u0159ed pou\u017e\u00edv\u00e1n\u00edm v\u00fdsledk\u016f jak\u00fdchkoli z\u00e1t\u011b\u017eov\u00fdch test\u016f, kter\u00e9 neprovedli jste.<\/p>\n<p>Za prv\u00e9, struktura dat a profil z\u00e1t\u011b\u017ee testovan\u00fdch aplikac\u00ed se mohou v\u00fdrazn\u011b li\u0161it od \u00fakolu, kter\u00fd se chyst\u00e1te vy\u0159e\u0161it. P\u0159ed 10-15 lety v\u00fdrobci datab\u00e1z\u00ed r\u00e1di p\u0159edkl\u00e1dali v\u00fdsledky dosa\u017een\u00e9 v testech TPC, ale nyn\u00ed se zd\u00e1, \u017ee u\u017e nikdo tyto v\u00fdsledky nebere v\u00e1\u017en\u011b.<\/p>\n<p>Za druh\u00e9, v\u00fdkon syst\u00e9mu z\u00e1vis\u00ed do zna\u010dn\u00e9 m\u00edry na tom, pro kterou platformu byl k\u00f3d p\u016fvodn\u011b naps\u00e1n a na jak\u00e9m vybaven\u00ed byly testy prov\u00e1d\u011bny. Mnohokr\u00e1t jsem vid\u011bl testy, kde byl Oracle porovn\u00e1v\u00e1n s PostgreSQL. V\u00fdsledky \u2013 od bezpodm\u00edne\u010dn\u00e9 p\u0159evahy jednoho syst\u00e9mu po stejn\u011b bezpodm\u00edne\u010dnou p\u0159evahu druh\u00e9ho.<\/p>\n<p>A kone\u010dn\u011b, za t\u0159et\u00ed, nic nev\u00edte o tom, kdo test provedl. D\u016fle\u017eit\u00e1 je jak kvalifikace, kter\u00e1 ovliv\u0148uje kvalitu nastaven\u00ed OS a platformy, tak motivace, kter\u00e1 ovliv\u0148uje v\u00fdsledky testu siln\u011bji ne\u017e v\u0161echny ostatn\u00ed faktory dohromady.<\/p>\n<p>Pokud je v\u00fdkon kritick\u00fdm faktorem, prove\u010fte test sami, ide\u00e1ln\u011b s \u00fa\u010dast\u00ed specialist\u016f, kte\u0159\u00ed budou nastavovat a udr\u017eovat pr\u016fmyslov\u00fd syst\u00e9m.<\/p>\n<h4>V\u00fdsledek<\/h4>\n<p>\nNakonec v\u00fdsledkem ve\u0161ker\u00e9 pr\u00e1ce by m\u011bla b\u00fdt tabulka, ve kter\u00e9 jsou v\u0161echny zn\u00e1mky shrnuty, vyn\u00e1sobeny a se\u010dteny:<\/p>\n<p><img decoding=\"async\" alt=\"Co je lep\u0161\u00ed \u2013 Oracle nebo Redis, nebo jak od\u016fvodnit v\u00fdb\u011br platformy\" src=\"\/wp-content\/uploads\/2020\/07\/760bfe92d02865ec27ab6ac28d64e855.png\" style=\"display:block;margin: 0 auto;\" \/><br \/>\n<br \/>\nJak ch\u00e1pete, zm\u011bnou v\u00e1hy a \u00fapravou zn\u00e1mek lze dos\u00e1hnout jak\u00e9hokoli po\u017eadovan\u00e9ho v\u00fdsledku, ale to je u\u017e \u00fapln\u011b jin\u00fd p\u0159\u00edb\u011bh...<br \/>\n<br \/>Zdroj: <a content=\"nofollow\" rel=\"nofollow\" href=\"https:\/\/habr.com\/ru\/post\/510176\/\">habr.com<\/a> <\/p>","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"excerpt":{"rendered":"<p>\u2013\u00a0\u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e,\u00a0\u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430.\u00a0\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432\u00a0\u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432. \u041d\u0443 \u0432\u044b \u043f\u043e\u0434\u0443\u043c\u0430\u0439\u0442\u0435! \u041d\u0438\u0447\u0435\u0433\u043e \u043d\u0435 \u0431\u043e\u044f\u0442\u0441\u044f! \u042e\u043b\u0438\u0439 \u0414\u0443\u0431\u043e\u0432, \u00ab\u041c\u0435\u043d\u044c\u0448\u0435\u0435 \u0437\u043b\u043e\u00bb \u0423\u0432\u0438\u0434\u0435\u0432 \u0442\u0430\u043a\u043e\u0439 \u0437\u0430\u0433\u043e\u043b\u043e\u0432\u043e\u043a, \u0432\u044b \u043d\u0430\u0432\u0435\u0440\u043d\u044f\u043a\u0430 \u0443\u0436\u0435 \u0440\u0435\u0448\u0438\u043b\u0438, \u0447\u0442\u043e \u0441\u0442\u0430\u0442\u044c\u044f \u2013 \u0438\u043b\u0438 \u0433\u043b\u0443\u043f\u043e\u0441\u0442\u044c, \u0438\u043b\u0438 \u043f\u0440\u043e\u0432\u043e\u043a\u0430\u0446\u0438\u044f. \u041d\u043e \u043d\u0435 \u0441\u043f\u0435\u0448\u0438\u0442\u0435 \u0441 [&hellip;]<\/p>\n","protected":false,"gt_translate_keys":[{"key":"rendered","format":"html"}]},"author":1,"featured_media":87815,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[688],"tags":[],"class_list":["post-87814","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-administrirovanie"],"aioseo_notices":[],"aioseo_head":"\n\t\t<!-- All in One SEO 5.0.3 - aioseo.com -->\n\t<meta name=\"description\" content=\"\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e, \u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430. \u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432.\" \/>\n\t<meta name=\"robots\" content=\"max-image-preview:large\" \/>\n\t<meta name=\"author\" content=\"Yuri Gagarin\"\/>\n\t<link rel=\"canonical\" href=\"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy\" \/>\n\t\t<meta name=\"generator\" content=\"All in One SEO (AIOSEO) 5.0.3\" \/>\n\t\t<meta property=\"og:locale\" content=\"cs_CZ\" \/>\n\t\t<meta property=\"og:site_name\" content=\"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b\" \/>\n\t\t<meta property=\"og:type\" content=\"article\" \/>\n\t\t<meta property=\"og:title\" content=\"\ud83e\udd47\u0427\u0442\u043e \u043b\u0443\u0447\u0448\u0435 \u2013 Oracle \u0438\u043b\u0438 Redis \u0438\u043b\u0438 \u041a\u0430\u043a \u043e\u0431\u043e\u0441\u043d\u043e\u0432\u0430\u0442\u044c \u0432\u044b\u0431\u043e\u0440 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b | ProHoster\" \/>\n\t\t<meta property=\"og:description\" content=\"\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e, \u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430. \u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432.\" \/>\n\t\t<meta property=\"og:url\" content=\"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy\" \/>\n\t\t<meta property=\"og:image\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:secure_url\" content=\"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg\" \/>\n\t\t<meta property=\"og:image:width\" content=\"350\" \/>\n\t\t<meta property=\"og:image:height\" content=\"350\" \/>\n\t\t<meta property=\"article:published_time\" content=\"2020-07-10T11:42:14+00:00\" \/>\n\t\t<meta property=\"article:modified_time\" content=\"2020-07-10T11:42:14+00:00\" \/>\n\t\t<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<meta property=\"article:author\" content=\"https:\/\/www.facebook.com\/prohoster\" \/>\n\t\t<!-- All in One SEO -->\n\n","aioseo_head_json":{"title":"\ud83e\udd47Co je lep\u0161\u00ed \u2013 Oracle nebo Redis nebo Jak obh\u00e1jit v\u00fdb\u011br platformy | ProHoster","description":"\u2013 To je neskute\u010dn\u00e9, \u2013 \u0159ekla nahlas, ani\u017e by se na n\u011bkoho obr\u00e1tila. \u2013 To je neskute\u010dn\u00e9! Tak p\u0159\u00edmo je naps\u00e1no \u2013 hlavn\u00edm \u00fakolem spole\u010dnosti je vytv\u00e1\u0159et zisk v z\u00e1jmu akcion\u00e1\u0159\u016f.","canonical_url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","robots":"max-image-preview:large","keywords":"","webmasterTools":{"miscellaneous":""},"schema":null,"og:locale":"cs_CZ","og:site_name":"ProHoster | \u041a\u0443\u043f\u0438\u0442\u044c \u043d\u0430\u0434\u0435\u0436\u043d\u044b\u0439 \u0445\u043e\u0441\u0442\u0438\u043d\u0433 \u0434\u043b\u044f \u0441\u0430\u0439\u0442\u043e\u0432 \u0441 \u0437\u0430\u0449\u0438\u0442\u043e\u0439 \u043e\u0442 DDoS, VPS VDS \u0441\u0435\u0440\u0432\u0435\u0440\u044b","og:type":"article","og:title":"\ud83e\udd47\u0427\u0442\u043e \u043b\u0443\u0447\u0448\u0435 \u2013 Oracle \u0438\u043b\u0438 Redis \u0438\u043b\u0438 \u041a\u0430\u043a \u043e\u0431\u043e\u0441\u043d\u043e\u0432\u0430\u0442\u044c \u0432\u044b\u0431\u043e\u0440 \u043f\u043b\u0430\u0442\u0444\u043e\u0440\u043c\u044b | ProHoster","og:description":"\u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e, \u2014 \u043d\u0438 \u043a \u043a\u043e\u043c\u0443 \u043d\u0435 \u043e\u0431\u0440\u0430\u0449\u0430\u044f\u0441\u044c, \u0433\u0440\u043e\u043c\u043a\u043e \u0441\u043a\u0430\u0437\u0430\u043b\u0430 \u043e\u043d\u0430. \u2013 \u042d\u0442\u043e \u0436 \u043d\u0430\u0434\u043e! \u0422\u0430\u043a \u043f\u0440\u044f\u043c\u043e \u0438 \u043d\u0430\u043f\u0438\u0441\u0430\u043d\u043e \u2013 \u0433\u043b\u0430\u0432\u043d\u043e\u0439 \u0437\u0430\u0434\u0430\u0447\u0435\u0439 \u043e\u0431\u0449\u0435\u0441\u0442\u0432\u0430 \u044f\u0432\u043b\u044f\u0435\u0442\u0441\u044f \u0438\u0437\u0432\u043b\u0435\u0447\u0435\u043d\u0438\u0435 \u043f\u0440\u0438\u0431\u044b\u043b\u0438 \u0432 \u0438\u043d\u0442\u0435\u0440\u0435\u0441\u0430\u0445 \u0430\u043a\u0446\u0438\u043e\u043d\u0435\u0440\u043e\u0432.","og:url":"https:\/\/prohoster.info\/cs\/blog\/administrirovanie\/chto-luchshe-oracle-ili-redis-ili-kak-obosnovat-vybor-platformy","og:image":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:secure_url":"https:\/\/prohoster.info\/wp-content\/uploads\/2021\/11\/logo-350.jpg","og:image:width":350,"og:image:height":350,"article:published_time":"2020-07-10T11:42:14+00:00","article:modified_time":"2020-07-10T11:42:14+00:00","article:publisher":"https:\/\/www.facebook.com\/prohoster","article:author":"https:\/\/www.facebook.com\/prohoster"},"aioseo_meta_data":{"post_id":"87814","title":null,"description":null,"keywords":null,"keyphrases":null,"primary_term":null,"canonical_url":null,"og_title":null,"og_description":null,"og_object_type":"default","og_image_type":"default","og_image_url":null,"og_image_width":null,"og_image_height":null,"og_image_custom_url":null,"og_image_custom_fields":null,"og_video":null,"og_custom_url":null,"og_article_section":null,"og_article_tags":null,"twitter_use_og":false,"twitter_card":"default","twitter_image_type":"default","twitter_image_url":null,"twitter_image_custom_url":null,"twitter_image_custom_fields":null,"twitter_title":null,"twitter_description":null,"schema":{"blockGraphs":[],"customGraphs":[],"default":{"data":{"Article":[],"Course":[],"Dataset":[],"FAQPage":[],"Movie":[],"Person":[],"Product":[],"ProductReview":[],"Car":[],"Recipe":[],"Service":[],"SoftwareApplication":[],"WebPage":[]},"graphName":"","isEnabled":true},"graphs":[]},"schema_type":null,"schema_type_options":null,"pillar_content":false,"robots_default":true,"robots_noindex":false,"robots_noarchive":false,"robots_nosnippet":false,"robots_nofollow":false,"robots_noimageindex":false,"robots_noodp":false,"robots_notranslate":false,"robots_max_snippet":null,"robots_max_videopreview":null,"robots_max_imagepreview":"large","priority":null,"frequency":null,"local_seo":null,"seo_analyzer_scan_date":null,"breadcrumb_settings":null,"limit_modified_date":false,"reviewed_by":null,"ai":null,"created":"2021-02-28 13:42:29","updated":"2022-10-02 03:57:29","focus_keyword":null,"additional_keywords":null,"truseo_locale":null},"gt_translate_keys":[{"key":"link","format":"url"}],"_links":{"self":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/87814","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/comments?post=87814"}],"version-history":[{"count":0,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/posts\/87814\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media\/87815"}],"wp:attachment":[{"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/media?parent=87814"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/categories?post=87814"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/prohoster.info\/cs\/wp-json\/wp\/v2\/tags?post=87814"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}