Hi all,
I'm trying to setup openser with mysql cluster.
I see that the default db engine used by openser tables is MyISAM, I need to change it with the ndbcluster engine or I can leave it as is?
Thanks.
Regards,
Antonio
On Thursday 06 March 2008, Antonio Reale wrote:
I'm trying to setup openser with mysql cluster.
I see that the default db engine used by openser tables is MyISAM, I need to change it with the ndbcluster engine or I can leave it as is?
Hi Antonio,
i think that you can't use MyISAM if you want to use MySQL cluster. But for information about setting this you should consult the MySQL documentation, there is also a cluster FAQ available.
Cheers,
Henning
2008/3/6, Henning Westerholt henning.westerholt@1und1.de:
i think that you can't use MyISAM if you want to use MySQL cluster. But for information about setting this you should consult the MySQL documentation, there is also a cluster FAQ available.
Probably I can use MyISAM, but tables using this engine are not clustered. Thanks.
Regards, Antonio.
MySQL has several storage engines where info is kept and if you want to implement MySQL cluster you MUST use the dedicated storage engine that provides de HA solution, ndbcluster.
If you have the cluster setup, you could try to use ALTER commands but it's not recommended...It's better you change the engine parameter in the MySQL creation scripts to use the MySQL cluster features.
Hope it helps, Samuel.
2008/3/10, Antonio Reale ant.reale@gmail.com:
2008/3/6, Henning Westerholt henning.westerholt@1und1.de:
i think that you can't use MyISAM if you want to use MySQL cluster. But for information about setting this you should consult the MySQL documentation, there is also a cluster FAQ available.
Probably I can use MyISAM, but tables using this engine are not clustered. Thanks.
Regards, Antonio.
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
Hi!
If you use openser_mysql script (version 1.2.x)
1) create a resource file /etc/openser/.opensermysqlrc and enter the following line: TABLE_TYPE="ENGINE=NDBCLUSTER"
2) run the script (don't forget to backup data): openser_mysql create or openser_mysql reinit,... The script (deletes and) creates all openser tables with table_type = ndbcluster
Regards, Sasa
On Mon, Mar 10, 2008 at 10:34 AM, samuel samu60@gmail.com wrote:
MySQL has several storage engines where info is kept and if you want to implement MySQL cluster you MUST use the dedicated storage engine that provides de HA solution, ndbcluster.
If you have the cluster setup, you could try to use ALTER commands but it's not recommended...It's better you change the engine parameter in the MySQL creation scripts to use the MySQL cluster features.
Hope it helps, Samuel.
2008/3/10, Antonio Reale ant.reale@gmail.com:
2008/3/6, Henning Westerholt henning.westerholt@1und1.de:
i think that you can't use MyISAM if you want to use MySQL cluster. But for information about setting this you should consult the MySQL documentation, there is also a cluster FAQ available.
Probably I can use MyISAM, but tables using this engine are not clustered. Thanks.
Regards, Antonio.
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
Users mailing list Users@lists.openser.org http://lists.openser.org/cgi-bin/mailman/listinfo/users
2008/3/10, Sasa Coh sasacoh@gmail.com:
Hi!
If you use openser_mysql script (version 1.2.x)
- create a resource file /etc/openser/.opensermysqlrc and enter the
following line: TABLE_TYPE="ENGINE=NDBCLUSTER"
2) run the script (don't forget to backup data): openser_mysql create or
openser_mysql reinit,... The script (deletes and) creates all openser tables with table_type = ndbcluster
Hi Sasa, I changed TABLE_TYPE="MyISAM" with TABLE_TYPE="NDBCLUSTER" directly in openser_mysql.sh (without create /etc/openser/.opensermysqlrc). I made it few minutes before your mail... but I think that it is the same.
Regards,
Sasa
Thanks. Antonio.
2008/3/10, samuel samu60@gmail.com: [CUT]
If you have the cluster setup, you could try to use ALTER commands but it's
not recommended...It's better you change the engine parameter in the MySQL creation scripts to use the MySQL cluster features.
I changed the TABLE_TYPE value in the mysql creation script because It is a new installation. But just to know... why ALTER command is not recommended?
Hope it helps,
Samuel.
Thanks. Bye. Antonio.
-
Antonio Reale -
Henning Westerholt -
samuel -
Sasa Coh