MySQL Forums
Forum List  »  Install & Repo

MySQL Cluster doesn't read MY.CNF parameters
Posted by: Prajeet Kahlon
Date: July 06, 2012 11:20AM

Hi,

I am a fresher to Mysql(Mysql Cluster) but need an urgent help.

For our new project in our company, we are going to use MySQL Cluster. I have never worked on it before but after reading manuals and reading some blogs, I was able to configure Mysql Cluster.

My problem is that, whatever parameter I set in my.cnf for [mysqld], these are not read reflected at session level.

Ex:
my.cnf
-------
[mysqld]
ndbcluster
ndb-connectstring='host=192.***.**.***'
basedir=/home/mysql/mysqlc
datadir=/home/mysql/mysqlcluster_home/mysqld_data
tmpdir=/tmp
socket=/tmp/mysql.sock
init_connect='SET autocommit=0'
ndb_force_send=OFF
transaction_allow_batching=1
ndb-batch-size=131072
ndb_cluster_connection_pool=6

-- Like ndb_cluster_connection_pool=6 in my.cnf, but it shows default value at sessio level, even though I have 14 slots available in config.ini and I can verify these through "show" in management server.

mysql> select @@ndb_cluster_connection_pool;
+-------------------------------+
| @@ndb_cluster_connection_pool |
+-------------------------------+
| 1 |
+-------------------------------+

mysql> select @@autocommit;
+--------------+
| @@autocommit |
+--------------+
| 1 |
+--------------+

Operating System is:
Linux 2.6.32-41-generic-pae #91-Ubuntu SMP i686 GNU/Linux

Mysql Cluster version is:
mysql> select @@version;
5.5.20-ndb-7.2.5-gpl

===========================================
Update:

After pasting above query, i did some google on this issue and found parameter --defaults-file, now I am able to point to the my.cnf that I am using.
But getting a new error now:

[ERROR] Fatal error: Can't open and lock privilege tables: Table 'mysql.host' doesn't exist

i reran mysql_install_db with datadir and basedir options but unable to solve this issue.

=================================================

Next Update:

After googling some more and tweaking some parameters, it is working fine now.
Still testing some more stuff. Will put next update soon.
===================================================
Will appreciate your any help on it.

Thanks very much in advance.



Edited 2 time(s). Last edit at 07/06/2012 09:45PM by Prajeet Kahlon.

Options: ReplyQuote


Subject
Written By
Posted
MySQL Cluster doesn't read MY.CNF parameters
July 06, 2012 11:20AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.