{"id":2254,"date":"2013-07-12T15:21:24","date_gmt":"2013-07-12T07:21:24","guid":{"rendered":"http:\/\/rmohan.com\/?p=2254"},"modified":"2013-07-12T15:23:22","modified_gmt":"2013-07-12T07:23:22","slug":"how-to-install-mysql-with-partition-enabled","status":"publish","type":"post","link":"https:\/\/mohan.sg\/?p=2254","title":{"rendered":"How to install Mysql with partition enabled"},"content":{"rendered":"
We can check how can we able to setting up mysql server with partition enabled. Lets see what is mysql partition means.<\/div>\n

 <\/p>\n

A partition is a division of a logical database or its constituting elements into distinct independent parts. Database partitioning is normally done for manageability, performance or availability reasons.<\/div>\n

 <\/p>\n

A popular and favourable application of partitioning is in a distributed database management system. Each partition may be spread over multiple nodes, and users at the node can perform local transactions on the partition. This increases performance for sites that have regular transactions involving certain views of data, whilst maintaining availability and security.<\/div>\n

 <\/p>\n

The partitioning can be done by either building separate smaller databases (each with its own tables, indices, and transaction logs), or by splitting selected elements.<\/div>\n
<\/div>\n
<\/div>\n

Follow the steps to install mysql server with partition enabled<\/p>\n

First get a package<\/p>\n

<\/div>\n
# gunzip mysql-5.5.12.tar.gz<\/div>\n
# tar -xvf mysql-5.5.12.tar<\/div>\n
<\/div>\n
# cd mysql-5.5.12<\/div>\n
# mysql-5.5.12 > cmake . -LH<\/div>\n
# mysql-5.5.12 > cmake .<\/div>\n
# mysql-5.5.12 > make<\/div>\n
<\/div>\n
# mysql-5.5.12 > make install<\/div>\n
# cd \/usr\/local\/mysql\/<\/div>\n
# chown mysql:mysql . -R<\/div>\n
# scripts\/mysql_install_db –datadir=\/usr\/local\/mysql\/data\/ –user=mysql<\/div>\n

—-
\nInstalling MySQL system tables…
\nOK
\nFilling help tables…
\nOK<\/p>\n

To start mysqld at boot time you have to copy
\nsupport-files\/mysql.server to the right place for your system<\/p>\n

PLEASE REMEMBER TO SET A PASSWORD FOR THE MySQL root USER !
\nTo do so, start the server, then issue the following commands:<\/p>\n

.\/bin\/mysqladmin -u root password ‘new-password’
\n.\/bin\/mysqladmin -u root -h systemspfx4 password ‘new-password’<\/p>\n

Alternatively you can run:
\n.\/bin\/mysql_secure_installation<\/p>\n

which will also give you the option of removing the test
\ndatabases and anonymous user created by default.\u00a0 This is
\nstrongly recommended for production servers.<\/p>\n

See the manual for more instructions.<\/p>\n

You can start the MySQL daemon with:
\ncd . ; .\/bin\/mysqld_safe &<\/p>\n

You can test the MySQL daemon with mysql-test-run.pl
\ncd .\/mysql-test ; perl mysql-test-run.pl<\/p>\n

Please report any problems with the .\/bin\/mysqlbug script!
\n——<\/p>\n

create a my.cnf file, here i copied from another system and added the needed parameters including the port which the server want to start.<\/div>\n
<\/div>\n
# scp my.cnf\u00a0 root@IP:\/usr\/local\/mysql\/<\/div>\n
<\/div>\n
Start the server<\/div>\n
#.\/bin\/mysqld_safe –defaults-file=\/usr\/local\/mysql\/my.cnf &<\/div>\n
<\/div>\n
We can login using<\/div>\n
# \/usr\/local\/mysql\/bin\/mysql -uroot -h 127.0.0.1 -P3307<\/div>\n
<\/div>\n
We can start the server in some other ways also<\/div>\n
Start the server in background<\/div>\n
# nohup sh \/usr\/local\/mysql\/bin\/mysqld_safe –defaults-file=\/usr\/local\/mysql\/my.cnf\u00a0 &<\/div>\n
<\/div>\n
Enabled the general log and slow queries<\/div>\n
# nohup sh \/usr\/local\/mysql\/bin\/mysqld_safe –general_log=1 –log-slow-queries=\/usr\/local\/mysql\/data\/RHEL664PFMX-SLOW.log &<\/div>\n
<\/div>\n
And we can see the server is up and running in port 3307<\/div>\n","protected":false},"excerpt":{"rendered":"

We can check how can we able to setting up mysql server with partition enabled. Lets see what is mysql partition means. <\/p>\n

 <\/p>\n

A partition is a division of a logical database or its constituting elements into distinct independent parts. Database partitioning is normally done for manageability, performance or availability reasons. <\/p>\n

 <\/p>\n

A popular and […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"_links":{"self":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2254"}],"collection":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=2254"}],"version-history":[{"count":3,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2254\/revisions"}],"predecessor-version":[{"id":2256,"href":"https:\/\/mohan.sg\/index.php?rest_route=\/wp\/v2\/posts\/2254\/revisions\/2256"}],"wp:attachment":[{"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=2254"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=2254"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/mohan.sg\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=2254"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}