node HostName=192.168.0.7 DataDir=/var/lib/mysql-cluster # one [MYSQLD] per storage node [MYSQLD] [MYSQLD] Customize those IP address above with your own configuration. NoOfReplicas=2 Number of MySQL Nodes Node #1 : 192.168.0.6 and Node #2 : 192.168.0.7 192.168.0.5 is Management Node Then we start the cluster management server: ndb_mgmd…
–initial only run when the start MySQL for the first time, and if you change configuration at /var/lib/mysql-cluster/config.ini file. MySQL probably won’t start with the following message Starting MySQL Couldn’t find MySQL manager (./bin/mysmanager) or server (./bin/mysqld_safe) Edit a few line of /etc/init.d/mysql.server basedir=/usr/ datadir=/usr/local/mysql/data/ pid_file=/usr/local/mysqld.pid server_pid_file=/usr/local/mysqld.server.pid Restart mysql nodes…
Having a huge concurrent user connections are a rare condition, usually this is happening for forums, mailing list websites. Bottleneck of this issue are Need a huge bandwidth Need to load balance the web server. Need to load balance the MySQL Database server. Now let’s learn more…
Now I am going to brief how to install drupal easily first need to check for few update of the OS. yum update Install pre-requisites application for drupal # wget http://prdownloads.sourceforge.net/webadmin/webmin-1.440-1.noarch.rpm # wget http://webmin.com/jcameron-key.asc # rpm –import jcameron-key.asc # yum install webmin-1.440-1.noarch.rpm Restart APM ( Apache PHP and Mysql…