?
Solved

MySQL 6 Cluster Install in Linux environment

Posted on 2012-09-13
4
Medium Priority
?
567 Views
Last Modified: 2013-11-14
Greetings,

We are looking for some advice to see if this is a good approach in regards to installing MySQL Cluster on 6 nodes. Each node will be setup with SAN attached storage which will have 3 mounts that will be in it's on disk group so mount point 1 will be used to install the MySQL Cluster  binaries and library files, mount point two will be used to install the MySQL Cluster database files, mount point 3 will be used to install the MySQL Cluster bin logs files. Is this a good idea in regards to this approach? Also in regards to backups, are backups performed on each node or is there only one unified backup for a MySQL Cluster? Also what is the comparison function thats found in Oracle in regards to redo log that MySQL uses in comparison to Oracle's redo mechanism? How does the MySQL Cluster work in regards to recovery and node crashes?
2012-09-13 at 12:13:02
0
Comment
Question by:Omega002
2 Comments
 

Author Comment

by:Omega002
ID: 38400079
Can I get someone to comment on my question that was posted yesterday? Hello hello!
0
 
LVL 27

Accepted Solution

by:
skullnobrains earned 1500 total points
ID: 38513650

Is this a good idea in regards to this approach?

i do not know why you are doing this but i'd say no

if the idea is to remove spofs by using a cluster, using a single san backend will only move the spof from the frontend servers to the backend storage

if the idea is about speed, the cluster itself produces speed issues because of locks. it is generally fatser to have a fast machine than several slow ones on a single storage backend

please no flame wars here, but it is also nowadays provably faster, less expensive and much better performance-wise to setup a machine with proper raid than use an expensive SAN (let's say a machine worth 2.5k and another 2k worth of disks will likely give you better speed and more space than a fast machine plugged to a 50k worth SAN)


Also in regards to backups, are backups performed on each node or is there only one unified backup for a MySQL Cluster

all the nodes share the same data so backuping any node will backup the cluster

i believe that setting up replication associated with snapshots is usually better than performing frequent backups but the choice would depend on many parameters


Also what is the comparison function thats found in Oracle in regards to redo log that MySQL uses in comparison to Oracle's redo mechanism

i do not understand this question. i can only tell you that the mysql binary log is more or less the equivalent of the oracle redo log. mysql has features to replicate up to a certain point in time or rollback the same but no feature to rollback or replicate specific transactions as far as i know.


How does the MySQL Cluster work in regards to recovery and node crashes?

node crashes should be transparent : as long as the node comes back online, you should not have anything to do. using mysql-proxy will help you not miss transactions when a node goes up and down frequently. recovery is out-of-scope there since mysql is properly synchronous : either the transaction has been successfully commited and it has been written on disk, or it has not and your application never got a confirmation
0

Featured Post

Free learning courses: Active Directory Deep Dive

Get a firm grasp on your IT environment when you learn Active Directory best practices with Veeam! Watch all, or choose any amount, of this three-part webinar series to improve your skills. From the basics to virtualization and backup, we got you covered.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

What we learned in Webroot's webinar on multi-vector protection.
How much do you know about the future of data centers? If you're like 50% of organizations, then it's probably not enough. Read on to get up to speed on this emerging field.
Learn how to find files with the shell using the find and locate commands. Use locate to find a needle in a haystack.: With locate, check if the file still exists.: Use find to get the actual location of the file.:
In this video, Percona Solution Engineer Dimitri Vanoverbeke discusses why you want to use at least three nodes in a database cluster. To discuss how Percona Consulting can help with your design and architecture needs for your database and infras…
Suggested Courses
Course of the Month13 days, 15 hours left to enroll

809 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question