{"id":223,"date":"2007-11-06T17:40:56","date_gmt":"2007-11-06T16:40:56","guid":{"rendered":"http:\/\/www3.nazca.hu\/?p=223"},"modified":"2012-01-15T22:39:38","modified_gmt":"2012-01-15T21:39:38","slug":"mysql-adatbazis-konyvtaranak-athelyezese","status":"publish","type":"post","link":"http:\/\/dev.nazca.hu\/www\/2007\/11\/06\/mysql-adatbazis-konyvtaranak-athelyezese\/","title":{"rendered":"MySQL adatb\u00e1zis k\u00f6nyvt\u00e1r\u00e1nak \u00e1thelyez\u00e9se"},"content":{"rendered":"<p>Ha a kiszolg\u00e1l\u00f3 egyn\u00e9l t\u00f6bb merevlemezzel vagy RAID k\u00f6tettel rendelkezik, akkor aj\u00e1nlatos a MySQL adatb\u00e1zisokat \u00e1thelyezni a m\u00e1sodik merevlemezre. \u00cdgy nagy terhelts\u00e9g\u0171 adatb\u00e1zis eset\u00e9n megn\u00f6velhet\u0151 az I\/O sebess\u00e9g, mellyel lecs\u00f6kkenthet\u0151 az ebb\u0151l ad\u00f3d\u00f3 sz\u0171k keresztmetszet.<\/p>\n<p>A m\u0171velet v\u00e9grehajtsa el\u0151tt le kell \u00e1ll\u00edtani a MySQL kiszolg\u00e1l\u00f3t (biztons\u00e1gi ment\u00e9st sem \u00e1rt k\u00e9sz\u00edteni az adatokr\u00f3l!):<\/p>\n<p>[bash]# \/usr\/local\/etc\/rc.d\/mysql-server.sh stop[\/bash]<\/p>\n<p>A MySQL Server 5.0 (FreeBSD eset\u00e9n) a <em>\/var\/db\/mysql<\/em> \u00fatvonalat haszn\u00e1lja alap\u00e9rtelemez\u00e9sk\u00e9nt az adatb\u00e1zisok t\u00e1rol\u00e1s\u00e1ra. Tov\u00e1bb\u00e1, minden f\u00e1jlt \u00e9s mapp\u00e1t a <em>mysql <\/em>csoportnak \u00e9s <em>mysql<\/em> felhaszn\u00e1l\u00f3nak kell tulajdonolnia, ez\u00e9rt a m\u00e1sol\u00e1st <em>-p<\/em> opci\u00f3val kell v\u00e9grehajtani a be\u00e1ll\u00edt\u00e1sok meg\u0151rz\u00e9se v\u00e9gett. A MySQL az adatb\u00e1zisokat k\u00fcl\u00f6n k\u00f6nyvt\u00e1rakban t\u00e1rolja ez\u00e9rt rekurz\u00edv m\u00e1sol\u00e1st (<em>-R<\/em>) kell v\u00e9grehajtani:<\/p>\n<p>[bash]# cp -Rp \/var\/db\/mysql\/ \/export\/mysql\/db[\/bash]<\/p>\n<p>Az <em>\/etc\/rc.conf<\/em> f\u00e1jlt ki kell eg\u00e9sz\u00edteni a k\u00f6vetkez\u0151 sorral:<\/p>\n<p>[bash]mysql_dbdir=&quot;\/export\/msql\/db&quot;<br \/>\nmysql_enable=&quot;YES&quot;[\/bash]<\/p>\n<p>A MySQL kiszolg\u00e1l\u00f3t \u00fajra el kell ind\u00edtani.<\/p>\n<p>[bash]# \/usr\/local\/etc\/rc.d\/mysql-server.sh start[\/bash]<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ha a kiszolg\u00e1l\u00f3 egyn\u00e9l t\u00f6bb merevlemezzel vagy RAID k\u00f6tettel rendelkezik, akkor aj\u00e1nlatos a MySQL adatb\u00e1zisokat \u00e1thelyezni a m\u00e1sodik merevlemezre. \u00cdgy nagy terhelts\u00e9g\u0171 [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[26,11],"tags":[27,6,5],"_links":{"self":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/223"}],"collection":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/comments?post=223"}],"version-history":[{"count":5,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/223\/revisions"}],"predecessor-version":[{"id":1962,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/posts\/223\/revisions\/1962"}],"wp:attachment":[{"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/media?parent=223"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/categories?post=223"},{"taxonomy":"post_tag","embeddable":true,"href":"http:\/\/dev.nazca.hu\/www\/wp-json\/wp\/v2\/tags?post=223"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}