6 Mar
2008
6 Mar
'08
9:06 a.m.
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
6 Mar
6 Mar
11:22 a.m.
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
10 Mar
10 Mar
5:21 a.m.
2008/3/6, Henning Westerholt <henning.westerholt(a)1und1.de>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.
5:34 a.m.
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(a)gmail.com>om>:
2008/3/6, Henning Westerholt <henning.westerholt(a)1und1.de>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(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
12:13 p.m.
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(a)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(a)gmail.com>om>:
2008/3/6, Henning Westerholt <henning.westerholt(a)1und1.de>de>:
_______________________________________________
Users mailing list
Users(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
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(a)lists.openser.org
http://lists.openser.org/cgi-bin/mailman/listinfo/users
12:28 p.m.
2008/3/10, Sasa Coh <sasacoh(a)gmail.com>om>:
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
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.
12:33 p.m.
2008/3/10, samuel <samu60(a)gmail.com>om>:
[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.
6136
days inactive
6140
days old
6 comments
4 participants
participants (4)
-
Antonio Reale -
Henning Westerholt -
samuel -
Sasa Coh