LinuxQuestions.org
Help answer threads with 0 replies.
Go Back   LinuxQuestions.org > Forums > Linux Forums > Linux - Newbie
User Name
Password
Linux - Newbie This Linux forum is for members that are new to Linux.
Just starting out and have a question? If it is not in the man pages or the how-to's this is the place!

Notices


Reply
  Search this Thread
Old 04-24-2013, 03:59 AM   #1
h.dilshad
LQ Newbie
 
Registered: Jan 2013
Posts: 17

Rep: Reputation: Disabled
Has anyone created a MySql cluster with MYIASM and InnoDB Tables


Has any created a MySql cluster with MYIASM and InnoDB Tables. If yes... Please tell me the steps.
 
Old 04-24-2013, 10:14 AM   #2
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,343

Rep: Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906
Quote:
Originally Posted by h.dilshad View Post
Has any created a MySql cluster with MYIASM and InnoDB Tables. If yes... Please tell me the steps.
First, this is NOT the place to come for people to give you step-by-step directions and how-to's. If you have a specific question, please post it.

Second, did you try to do ANY research on this question first??? Do you understand what MySQL clustering is, how it works, and why it does what it does?
http://docs.oracle.com/cd/E17952_01/...-compared.html

From the documentation:
Quote:
Originally Posted by MySQL Docs
While it is possible to use InnoDB tables with MySQL Cluster, such tables are not clustered.
So...if you want a clustered database that doesn't cluster your data, feel free to use InnoDB.
 
Old 04-25-2013, 01:32 AM   #3
h.dilshad
LQ Newbie
 
Registered: Jan 2013
Posts: 17

Original Poster
Rep: Reputation: Disabled
Smile

Hi TB0ne,

First......
I know that where I am. This is a community and everybody has right to ask questions at their own pattern. Who are you to decide the pattern of question. If you are not able to answer, please don't. You ask me questions I will give you all steps.

Second..
It is really good, That you think, you are the best. But this is bad to think that everyone is a fool. I don't know you or your background. May be you are really guru of MySQL. But for you information, I joined this community as newbie but I have a experience of 13 years and I am an Oracle DBA at senior level since 8 years. I have designed many databases, Implemented many RACs. But It doesn't matter. I have researched on MySQL cluster and found that you can use MySQL cluster either with innodb or with MyISAM. But I have some specific requirement and some where I saw that, the MySQL cluster is configured with Both Innodb and MyISAM. That's why I am asking.. I am working on that may be one day I will post the steps.



Quote:
Originally Posted by TB0ne View Post
First, this is NOT the place to come for people to give you step-by-step directions and how-to's. If you have a specific question, please post it.

Second, did you try to do ANY research on this question first??? Do you understand what MySQL clustering is, how it works, and why it does what it does?
http://docs.oracle.com/cd/E17952_01/...-compared.html

From the documentation:

So...if you want a clustered database that doesn't cluster your data, feel free to use InnoDB.
 
Old 04-25-2013, 10:54 AM   #4
TB0ne
LQ Guru
 
Registered: Jul 2003
Location: Birmingham, Alabama
Distribution: SuSE, RedHat, Slack,CentOS
Posts: 18,343

Rep: Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906Reputation: 3906
Quote:
Originally Posted by h.dilshad View Post
Hi TB0ne,
First......
I know that where I am. This is a community and everybody has right to ask questions at their own pattern. Who are you to decide the pattern of question. If you are not able to answer, please don't. You ask me questions I will give you all steps.
Yep...and everyone also has the right to answer how they want to. If you want how-to guides, I'm not going to re-type step-by-step directions for you, when you can look them up. If you want to, feel free.
Quote:
Second..
It is really good, That you think, you are the best. But this is bad to think that everyone is a fool. I don't know you or your background. May be you are really guru of MySQL. But for you information, I joined this community as newbie but I have a experience of 13 years and I am an Oracle DBA at senior level since 8 years. I have designed many databases, Implemented many RACs. But It doesn't matter. I have researched on MySQL cluster and found that you can use MySQL cluster either with innodb or with MyISAM. But I have some specific requirement and some where I saw that, the MySQL cluster is configured with Both Innodb and MyISAM. That's why I am asking.. I am working on that may be one day I will post the steps.
Great...so then you understood the link I looked up for you, and what it told you. Since you have 13 years experience with Oracle, RAC, etc., then perhaps you can explain why you'd like to implement a clustered database, with tables that can't be clustered??? Yes, InnoDB does have a cluster plug-in, but it has the aforementioned limitation.

You say you've got many years of experience...shouldn't you then also know how to provide details when asking a question, such as what your requirement IS? Shouldn't you be able to (since you're using Oracle and RAC), call Oracle support (since they own MySQL, and you're obviously paying for Oracle...), and ask them how to do what you're after?
 
Old 04-26-2013, 12:34 AM   #5
h.dilshad
LQ Newbie
 
Registered: Jan 2013
Posts: 17

Original Poster
Rep: Reputation: Disabled
Smile

Quote:
Originally Posted by TB0ne View Post
Yep...and everyone also has the right to answer how they want to. If you want how-to guides, I'm not going to re-type step-by-step directions for you, when you can look them up. If you want to, feel free.

Great...so then you understood the link I looked up for you, and what it told you. Since you have 13 years experience with Oracle, RAC, etc., then perhaps you can explain why you'd like to implement a clustered database, with tables that can't be clustered??? Yes, InnoDB does have a cluster plug-in, but it has the aforementioned limitation.

You say you've got many years of experience...shouldn't you then also know how to provide details when asking a question, such as what your requirement IS? Shouldn't you be able to (since you're using Oracle and RAC), call Oracle support (since they own MySQL, and you're obviously paying for Oracle...), and ask them how to do what you're after?
Thanks TB0ne for your comments...
I have already discussed with Oracle team. They are saying that by default it is not possible but Its not impossible as I said previously.. I saw some where....... MySQL development team is working on a new and powerful solution but that will take some more time to come in feature.
although thanks
 
Old 04-26-2013, 04:21 AM   #6
chrism01
LQ Guru
 
Registered: Aug 2004
Location: Sydney
Distribution: Centos 6.8, Centos 5.10
Posts: 17,260

Rep: Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328Reputation: 2328
Clusters are supposed to use the NDB (aka NDBcluster) engine as far as I can tell (& remember) https://dev.mysql.com/doc/mysql-clus...b-engines.html
 
  


Reply


Thread Tools Search this Thread
Search this Thread:

Advanced Search

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is Off
HTML code is Off



Similar Threads
Thread Thread Starter Forum Replies Last Post
Recover MySQL Innodb from /var/lib/mysql/ backup? eteck Linux - Server 1 01-31-2011 02:36 AM
MySQL InnoDB Failover and Red Hat Cluster Suite stefano65 Red Hat 1 11-18-2006 02:35 PM
Mysql -- Grant tables not installed & Innodb configuration ttumelty Linux - Software 0 06-22-2006 10:41 AM
MySQL Innodb troubles Baltasar Linux - Software 1 04-20-2005 10:01 AM
InnoDB problem with MySQL jerry_redhat Linux - Software 2 07-09-2003 01:20 AM


All times are GMT -5. The time now is 10:02 PM.

Main Menu
Advertisement
My LQ
Write for LQ
LinuxQuestions.org is looking for people interested in writing Editorials, Articles, Reviews, and more. If you'd like to contribute content, let us know.
Main Menu
Syndicate
RSS1  Latest Threads
RSS1  LQ News
Twitter: @linuxquestions
Facebook: linuxquestions Google+: linuxquestions
Open Source Consulting | Domain Registration