mysql.server start error!!!

Discussion in 'HOWTO-Related Questions' started by sanocli, Jun 16, 2008.

  1. sanocli

    sanocli New Member

    Hello everybody,

    I tried to install a mysql cluster on a single machine for testing the application. To do that I've followed this How to => http://www.howtoforge.com/loadbalanced_mysql_cluster_debian. Everything is okay for the management node but when I try to lunch the mysql server for data/sql node I've this error :
    Starting MySQL
    kill: 412: No such process

    *

    I use the version 6.2 of mysql-cluster maybe this is the reason of this failure.
    Below you will find my config.ini and my my.cnf.

    Config.ini
    Code:
    [NDBD DEFAULT]
    NoOfReplicas=1
    
    # Section for the cluster management node
    [NDB_MGMD]
    # IP address of the management node (this system)
    HostName=127.0.0.1
    
    # Section for the storage nodes
    [NDBD]
    # IP address of the first storage node
    HostName=127.0.0.1
    DataDir= /var/lib/mysql-cluster
    
    # one [MYSQLD] per storage node
    [MYSQLD]
    my.cnf
    Code:
    [MYSQLD]
    user=mysql
    basedir=/usr/local/mysql/
    datadir=/data/mysql/
    ndb-cluster-connection-pool=1
    ndbcluster
    ndb-connectstring="127.0.0.1"
    ndb-force-send=1
    ndb-use-exact-count=0
    ndb-extra-logging=1
    ndb-autoincrement-prefetch-sz=256
    engine-condition-pushdown=1
    
    #REPLICATION SPECIFIC - GENERAL
    #server-id must be unique across all mysql servers participating in replication.
    #server-id=X
    #REPLICATION SPECIFIC - MASTER
    #log-bin
    #REPLICATION SPECIFIC - SLAVE
    #slave-allow-batching
    #skip-slave-start
    

    Thank you for helping me and have a good day.
     
  2. falko

    falko Super Moderator ISPConfig Developer

    What's the output of
    Code:
    netstat -tap
    ? Are there any MySQL errors in your logs?
     
  3. sanocli

    sanocli New Member

    Hello,

    I have solved the problem. I have reinstalled mysql server and know it's works.
    But I still have a problem. I don't manage to connect an API node to the cluster.

    If someone know what could be wrong, can he tell me what is it?

    Thank you. Have a good day ;)
     
  4. falko

    falko Super Moderator ISPConfig Developer

    Did you check your logs?
     

Share This Page