I am trying to setup
ubuntu 10.04 server for the past 3 weeks and not successful yet.
The links I followed are:
All the configurations in the above links are almost same with some slight changes and I just gave a try of all if any works but none.
I already made a post in serverfault but I am still could not able to make it work.
I always come back here if nothing works out after many tries and now I am.
Also I am not understanding whether
mysql-client need to be installed along with
mysql-cluster alone is enough for running
mysqld on SQL nodes. In my case the setup is
3 nodes=(data1+sql1 + data2+sql2 + mgmt node).
Starting MySQL * Couldn't find MySQL manager (/usr/bin/mysqlmanager) or server (/usr/bin/mysqld_safe)
I even tried copying
/usr/bin but still no use as it was telling
. * Manager of pid-file quit without updating file. while trying to start!
While trying to start mysql daemon on data/sql node
./bin/mysqld_safe --user=mysql --defaults-file=/etc/my.cnf &
 2338 root@web2:/usr/local/mysql# 111208 15:53:47 mysqld_safe Logging to syslog. 111208 15:53:47 mysqld_safe Starting mysqld daemon with databases from /var/lib/mysql 111208 15:53:47 mysqld_safe mysqld from pid file /var/lib/mysql/web2.pid ended + Done ./bin/mysqld_safe --user=mysql --defaults-file=/etc/my.cnf
Anybody take up and help me here please?. Anybody clarify if there is any problem with ubuntu or with cluster config?. I have to implement this on cloud servers once I am successful.
Now on SQL/Data nodes I have had already removed
mysql-client which I generally install as a basic package of any fresh installation. I removed them by running following command and on both of the nodes only
mysql-cluster is available which I could not able to setup:
apt-get remove mysql-client mysql-client-5.1 mysql-client-core-5.1 mysql-common mysql-server mysql-server-5.1 mysql-server-core-5.1
I have fixed the issues I had. Now I have the following things left to be done.
What is the best method to Add/Remove
SQL/DATAnodes being online?
EDIT: I tried mysql docs for adding nodes online but confused and didn't work unless I shutdown all the nodes and remove the logs under
/var/lib/mysql-clusteron all the nodes.
What additional configurations should I include in my
my.conffile for best performance tuning like
IndexMemory, if anybody using for production, can recommend or paste it here please?
How to convert all the table engines of the database to NDB which are having foreign keys also?
EDIT: I found a script for converting all the table engines but all the tables of my database are not converted as for the error: ERROR 1217 (23000) at line 11: Cannot delete or update a parent row: a foreign key constraint fails
Is there a way to possess both the features of NDB & InnoDB with cluster and multi-master replication with no risk(down time)?