{"id":28,"date":"2019-06-08T17:56:00","date_gmt":"2019-06-08T15:56:00","guid":{"rendered":"http:\/\/blog.fresel.at\/?p=28"},"modified":"2020-03-22T16:32:21","modified_gmt":"2020-03-22T15:32:21","slug":"percona-mysqld","status":"publish","type":"post","link":"https:\/\/blog.koeckeis-fresel.net\/?p=28","title":{"rendered":"percona mysqld"},"content":{"rendered":"\n<pre class=\"wp-block-preformatted\"><strong>CentOS<\/strong>\nyum install https:\/\/repo.percona.com\/yum\/percona-release-latest.noarch.rpm -y\n\npercona-release setup ps80\n\nyum install -y percona-server-server\n\ncat > \/root\/.my.cnf\u00a0\u00a0&lt;&lt; EOF\n[client] \nuser=root\nEOF\necho password=`grep password \/var\/log\/mysqld.log|cut -d \"@\" -f 2-|cut -d \" \" -f2- ` >> \/root\/.my.cnf\n\nmysql_secure_installation -p<\/pre>\n\n\n\n<pre class=\"wp-block-preformatted\"><strong>Debian<\/strong>\nwget https:\/\/repo.percona.com\/apt\/percona-release_latest.$(lsb_release -sc)_all.deb\ndpkg -i percona-release_latest.$(lsb_release -sc)_all.deb\npercona-release setup ps80\napt-get install percona-server-server -y\necho -> Add twice a good password for mysql-user-root\necho -> wait for end\n\n\necho [client] > \/root\/.my.cnf\necho user=root >> \/root\/.my.cnf\necho password= >> \/root\/.my.cnf\n\necho -> edit \/root\/.my.cnf and add your root password\n\nmysql -e \"CREATE FUNCTION fnv1a_64 RETURNS INTEGER SONAME 'libfnv1a_udf.so'\"\nmysql -e \"CREATE FUNCTION fnv_64 RETURNS INTEGER SONAME 'libfnv_udf.so'\"\nmysql -e \"CREATE FUNCTION murmur_hash RETURNS INTEGER SONAME 'libmurmur_udf.so'\"\n\nmysql_secure_installation<\/pre>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>CentOS yum install https:\/\/repo.percona.com\/yum\/percona-release-latest.noarch.rpm -y percona-release setup ps80 yum install -y percona-server-server cat > \/root\/.my.cnf\u00a0\u00a0&lt;&lt; EOF [client] user=root EOF echo password=`grep password \/var\/log\/mysqld.log|cut -d &#8220;@&#8221; -f 2-|cut -d &#8221; &#8221; -f2- ` >> \/root\/.my.cnf mysql_secure_installation -p Debian wget https:\/\/repo.percona.com\/apt\/percona-release_latest.$(lsb_release -sc)_all.deb dpkg -i percona-release_latest.$(lsb_release -sc)_all.deb percona-release setup ps80 apt-get install percona-server-server -y echo -> Add twice [&hellip;]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"advanced_seo_description":"","jetpack_seo_html_title":"","jetpack_seo_noindex":false,"_jetpack_memberships_contains_paid_content":false,"footnotes":""},"categories":[4],"tags":[],"class_list":["post-28","post","type-post","status-publish","format-standard","hentry","category-sql"],"jetpack_featured_media_url":"","jetpack_sharing_enabled":true,"jetpack_likes_enabled":true,"jetpack-related-posts":[],"_links":{"self":[{"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=\/wp\/v2\/posts\/28","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=28"}],"version-history":[{"count":0,"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=\/wp\/v2\/posts\/28\/revisions"}],"wp:attachment":[{"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=28"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=28"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.koeckeis-fresel.net\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=28"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}