LinuxQuestions.org

LinuxQuestions.org (/questions/)
-   Linux - Newbie (https://www.linuxquestions.org/questions/linux-newbie-8/)
-   -   Has anyone created a MySql cluster with MYIASM and InnoDB Tables (https://www.linuxquestions.org/questions/linux-newbie-8/has-anyone-created-a-mysql-cluster-with-myiasm-and-innodb-tables-4175459399/)

h.dilshad 04-24-2013 02:59 AM

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.

TB0ne 04-24-2013 09:14 AM

Quote:

Originally Posted by h.dilshad (Post 4937791)
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.

h.dilshad 04-25-2013 12:32 AM

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 (Post 4937996)
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.


TB0ne 04-25-2013 09:54 AM

Quote:

Originally Posted by h.dilshad (Post 4938409)
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?

h.dilshad 04-25-2013 11:34 PM

Quote:

Originally Posted by TB0ne (Post 4938689)
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 :)

chrism01 04-26-2013 03:21 AM

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


All times are GMT -5. The time now is 03:30 PM.