Activity in MySQL Cluster
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-12-2011 12:49 PM
Has anybody tried to run activity on a MySQL Cluster?
I have tried dumping the schema, needed to change the engine type to ndbcluster and some VARCHARs to TEXT to be able to import it, but i am still getting problems with it.
I have tried dumping the schema, needed to change the engine type to ndbcluster and some VARCHARs to TEXT to be able to import it, but i am still getting problems with it.
Labels:
- Labels:
-
Archive
5 REPLIES 5
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎08-13-2011 03:36 AM
What kind of problems? Rabbits popping out of hats?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-21-2011 02:20 AM
How to resolve this problem ?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-21-2011 04:23 PM
First would be to add some information that makes sense, helps us get a clearer picture etc… Just 'I have a problem' does not help.
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎12-21-2011 09:35 PM
It seems that mysql cluster doesn't support foreign key.How can we combine Activiti with Mysql cluster?
Options
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
‎05-08-2014 06:21 AM
I'd like to see a clear answer to this question not talk of rabbits, even though the original poster seems to have given up long long ago.
mysql-cluster (multi master) is not the same as mysql in a (master-slave) cluster, the stock mysql offers scale out but a read-only copy of the master, via the binary replication log, and can not tolerate loss of the master, or promote the slave to a master (without a lot of manual pain). The slave cannot tolerate even a short outage to master (with a high database write rate), the slave will stop receiving changes and become a static snapshot in time, and requires manual re-syncing of the correct position of the change log on the master. So it is not robust at all, except for having a backup, maybe.
mysql-cluster is a different product, it offers redundancy, not just scale-out, if a master dies another server can take on the role, and clients can be failed over (via a content switch, or software appliance, to another server. But as the writer above said, it used the clustered database storage engine ndbcluster (whereas on mysql you have InnoDB / MyISAM the storage engines are compatible and only slightly different) which has some significant syntactical differences.
It would be a relatively simple answer, if the mysql supported was the standard mysql (master-slave) or clustered mysql-cluster (master-master).. if this were true there would need to be a specific schema written for it, as it is different to regular mysql. If there is only a single mysql schema, then I'm assuming mysql-cluster not tested, but it might work with a little (maybe a lot?) of tweaking.
mysql-cluster (multi master) is not the same as mysql in a (master-slave) cluster, the stock mysql offers scale out but a read-only copy of the master, via the binary replication log, and can not tolerate loss of the master, or promote the slave to a master (without a lot of manual pain). The slave cannot tolerate even a short outage to master (with a high database write rate), the slave will stop receiving changes and become a static snapshot in time, and requires manual re-syncing of the correct position of the change log on the master. So it is not robust at all, except for having a backup, maybe.
mysql-cluster is a different product, it offers redundancy, not just scale-out, if a master dies another server can take on the role, and clients can be failed over (via a content switch, or software appliance, to another server. But as the writer above said, it used the clustered database storage engine ndbcluster (whereas on mysql you have InnoDB / MyISAM the storage engines are compatible and only slightly different) which has some significant syntactical differences.
It would be a relatively simple answer, if the mysql supported was the standard mysql (master-slave) or clustered mysql-cluster (master-master).. if this were true there would need to be a specific schema written for it, as it is different to regular mysql. If there is only a single mysql schema, then I'm assuming mysql-cluster not tested, but it might work with a little (maybe a lot?) of tweaking.
