{"id":154,"date":"2009-11-08T09:07:53","date_gmt":"2009-11-08T07:07:53","guid":{"rendered":"http:\/\/code.openark.org\/forge\/?page_id=154"},"modified":"2010-11-08T12:27:04","modified_gmt":"2010-11-08T10:27:04","slug":"installation","status":"publish","type":"page","link":"https:\/\/code.openark.org\/forge\/mycheckpoint\/documentation\/installation","title":{"rendered":"Installation"},"content":{"rendered":"<p><em>mycheckpoint<\/em> downloads in the following flavors:<\/p>\n<ul>\n<li>.deb package<\/li>\n<li>.rpm package (noarch)<\/li>\n<li>python install package<\/li>\n<li>script source<\/li>\n<\/ul>\n<p>The entire tool lies withing a single python script, which make it easy to install or use.<\/p>\n<h4>Package requirements<\/h4>\n<p>To run <em>mycheckpoint<\/em>, you must have the python (&gt;= <strong>2.4<\/strong>) and the <a href=\"http:\/\/sourceforge.net\/projects\/mysql-python\/files\/\">python-mysql<\/a> module installed.<\/p>\n<p>On any reasonably recent Linux distribution, python (&gt;= <strong>2.4<\/strong>) should already be installed. However, the python-mysql driver does not come installed by default on all common Linux distros. Recent RedHat, Fedora, CentOS should include it by default.<\/p>\n<p>On Debian, Ubuntu and derived distros, one can install the python-mysql module with:<\/p>\n<blockquote>\n<pre>sudo apt-get install python-mysqldb<\/pre>\n<\/blockquote>\n<p>On RedHat, CentOS and derived distros, one can:<\/p>\n<blockquote>\n<pre>yum install MySQL-python<\/pre>\n<\/blockquote>\n<p>For other distros, BSD, etc, please refer to the python-mysql README file.<\/p>\n<h4>Installing <em>mycheckpoint<\/em><\/h4>\n<p>Using .deb package:<\/p>\n<blockquote>\n<pre>sudo dpkg -i mycheckpoint-XXX.deb<\/pre>\n<\/blockquote>\n<p>Using .rpm package:<\/p>\n<blockquote>\n<pre>sudo rpm -i mycheckpoint-xxx.rpm\r\n<\/pre>\n<\/blockquote>\n<p>Using python package:<\/p>\n<blockquote>\n<pre>tar xzfv mycheckpoint-XXX.tar.gz\r\ncd mycheckpoint-XXX\r\nsudo python setup.py install<\/pre>\n<\/blockquote>\n<p>If you choose to download the script file, there&#8217;s not much to do; it&#8217;s ready for use. You may choose to:<\/p>\n<blockquote>\n<pre>chmod +x mycheckpoint-XXX\r\nsudo mv mycheckpoint-XXX \/usr\/bin\/mycheckpoint<\/pre>\n<\/blockquote>\n<h4>Schema, accounts and privileges<\/h4>\n<p>By default, <em>mycheckpoint<\/em> uses the &#8216;<strong>mycheckpoint<\/strong>&#8216; schema. The schema must exist beforehand. You may choose to use another schema with <strong>&#8211;database=<em>some_other_schema<\/em><\/strong>.<\/p>\n<p><em>mycheckpoint<\/em> runs under the privileges of some user. It can use the &#8216;root&#8217; account or any other existing or specially created account. Whatever the account, it must have full privileges on the designated schema.<\/p>\n<h5><em>Must have<\/em><\/h5>\n<p>Assuming you do not change the default &#8216;mycheckpoint&#8217; schema, the following are required:<\/p>\n<blockquote>\n<pre>CREATE DATABASE mycheckpoint;\r\nGRANT ALL PRIVILEGES ON mycheckpoint.* TO 'monitoring_user'@'localhost' IDENTIFIED BY 'some_password';<\/pre>\n<\/blockquote>\n<p>Edit the above settings as you see fit.<\/p>\n<h5><em>Optional<\/em><\/h5>\n<p>To monitor slave replication status, the user must also be granted with either the <strong>REPLICATION CLIENT<\/strong> or <strong>SUPER<\/strong> privileges; the former being safer to grant. For example:<\/p>\n<blockquote>\n<pre>GRANT REPLICATION CLIENT ON *.* TO 'monitoring_user'@'localhost'<\/pre>\n<\/blockquote>\n<p>To monitor master status, the user must be granted with the <strong>SUPER<\/strong> privilege:<\/p>\n<blockquote>\n<pre>GRANT SUPER ON *.* TO 'monitoring_user'@'localhost'<\/pre>\n<\/blockquote>\n<p>If the account has the <strong>SUPER<\/strong> privilege, all is well; if it only has <strong>REPLICATION CLIENT<\/strong>, then master status will not be monitored. If none of these privileges are defined, neither slave nor master status will be monitored, but no error is thrown.<\/p>\n<p>By default, <em>mychckpoint<\/em> allows for binary logging. If you wish to disable binary logging for insert\/purge statements, use <strong>&#8211;disable-bin-log<\/strong>; the account must then have the <strong>SUPER<\/strong> privilege.<\/p>\n<p>For future revisions, prepare the account by allowing it to issue <strong>SHOW PROCESSLIST<\/strong>:<\/p>\n<blockquote>\n<pre>GRANT PROCESS ON *.* TO 'monitoring_user'@'localhost'<\/pre>\n<\/blockquote>\n","protected":false},"excerpt":{"rendered":"<p>mycheckpoint downloads in the following flavors: .deb package .rpm package (noarch) python install package script source The entire tool lies withing a single python script, which make it easy to install or use. Package requirements To run mycheckpoint, you must have the python (&gt;= 2.4) and the python-mysql module installed. On any reasonably recent Linux [&hellip;]<\/p>\n","protected":false},"author":2,"featured_media":0,"parent":147,"menu_order":-10,"comment_status":"open","ping_status":"open","template":"","meta":{"footnotes":""},"class_list":["post-154","page","type-page","status-publish","hentry"],"_links":{"self":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages\/154","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages"}],"about":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/types\/page"}],"author":[{"embeddable":true,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/comments?post=154"}],"version-history":[{"count":15,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages\/154\/revisions"}],"predecessor-version":[{"id":173,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages\/154\/revisions\/173"}],"up":[{"embeddable":true,"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/pages\/147"}],"wp:attachment":[{"href":"https:\/\/code.openark.org\/forge\/wp-json\/wp\/v2\/media?parent=154"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}