tag:blogger.com,1999:blog-6480555434853676325.post7146216993375889740..comments2023-07-13T04:04:51.867-06:00Comments on MySQL DBA - An Oracle DBA's Journey: Installing MySQL 5.1 on Linux using MOCAAnonymoushttp://www.blogger.com/profile/00291214843973166978noreply@blogger.comBlogger11125tag:blogger.com,1999:blog-6480555434853676325.post-58406156149279859772012-05-25T10:55:54.505-06:002012-05-25T10:55:54.505-06:00After using these MOCA best practices on Red Hat 5...After using these MOCA best practices on Red Hat 5, how would I setup mysql.server in /etc/init.d/ as it should if I were use RPM install?<br /><br />I got it to stop and start but when starting it up, it is not grabbing my option file located in $MYSQL_HOME which specifies all my MOCA directories.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-38417857949174498412011-08-31T03:20:56.166-06:002011-08-31T03:20:56.166-06:00Just a simple suggestion, it's better to confi...Just a simple suggestion, it's better to configure expire_logs_days otherwise bin-logs will waste your free space.<br /><br />MarioAnonymousnoreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-8837330946596147552011-08-13T12:18:31.268-06:002011-08-13T12:18:31.268-06:00be wary of putting the multiple instances of mysql...be wary of putting the multiple instances of mysql on the same server, this does not fall in line with best practices for server architecture as it introduces "2" single points of failure. i.e if the os has issues then you have 2 instances down instead of 1.Unknownhttps://www.blogger.com/profile/12506501822156011532noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-88241618103818061122010-11-02T11:16:49.111-06:002010-11-02T11:16:49.111-06:00I have found your blog postings useful and informa...I have found your blog postings useful and informative, especially this one. Thank you.Felixhttps://www.blogger.com/profile/06974475385868964325noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-90561306273947243152010-09-07T14:46:04.671-06:002010-09-07T14:46:04.671-06:00Thanks for this post. One thing I observed is that...Thanks for this post. One thing I observed is that I had to add a socket command to the do_query function in teh bin/mysql_secure_installation, since I elected to move the socket file to a tmp dir in the context of mysql01 <br /><br />do_query() {<br /> echo "$1" >$command<br /> #sed 's,^,> ,' < $command # Debugging<br /> $mysql_client --defaults-file=$config Mark Butlerhttp://www.linkedin.com/in/markbutlernoreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-9622626740329802842010-08-24T16:07:20.944-06:002010-08-24T16:07:20.944-06:00I've got one issue and I'm curious how oth...I've got one issue and I'm curious how others handle it.<br /><br />I've got a MOCA install running on RHEL5.1 and need PHP support. However, YUM enforces dependencies. When I try to install php52-mysql.x86_64, it directly depends on MySQL 5.0.<br /><br />I'm curious how others handle issues surrounding the use of additional packages that use/require MySQL on RPM based systems Anonymoushttps://www.blogger.com/profile/05456375011361323272noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-29639614613537509062010-06-25T10:29:59.160-06:002010-06-25T10:29:59.160-06:00Yes, absolutely. You can definitely have multiple...Yes, absolutely. You can definitely have multiple MySQL database servers pointing to the same MySQL home directory. Obviously just make sure all other physical paths point to unique locations and names. If you ever upgrade one of the database servers, you just move the home directory for the upgraded server to point to new location. MOCA is very flexible.Anonymoushttps://www.blogger.com/profile/00291214843973166978noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-15365809211126031352010-06-16T11:03:15.196-06:002010-06-16T11:03:15.196-06:00I use something like MOCA for a long time. Can you...I use something like MOCA for a long time. Can you run multiple instances on the same server with this directory structure? I susally put the pid and the socket file in a separate dir, and I have a dir created for tmp, relay logs and log files too.Anonymousnoreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-81412057026696909312010-02-23T05:11:16.615-07:002010-02-23T05:11:16.615-07:00SiGiS, glad it helped. Very important to define s...SiGiS, glad it helped. Very important to define standards and guidelines for your configurations and deployments.Anonymoushttps://www.blogger.com/profile/00291214843973166978noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-45262298186792044382010-02-23T04:58:18.487-07:002010-02-23T04:58:18.487-07:00thank you very much, really helped.thank you very much, really helped.Unknownhttps://www.blogger.com/profile/03224869704335946928noreply@blogger.comtag:blogger.com,1999:blog-6480555434853676325.post-62375077801916202312010-01-14T10:32:25.747-07:002010-01-14T10:32:25.747-07:00The backup is no different to one made on the prim...The backup is no different to one made on the primary and can be restored to any node within the cluster.Storagecrafthttp://www.storagecraft.com.au/noreply@blogger.com