Skip to main content

Posts

Showing posts from May, 2015

MySQL Clustering

MySQL Cluster is a technology for automatically shared database management system. i.e this technology create two or more replicas of the same data base in different nodes.  Basically mysql clustering is asynchronous communication technology. The basics steps for establish mysql clustering is given below: Step 1:  Download supported version of mysql clustering installation zip file from       http://www.mysql.com/downloads/cluster/ Step 2:   Extract the zip file and copy the contents inside the folder to  c:\Users\user1\mysqlc Step 3: Run the command prompt window as administrator role, And execute the following commands for create clustering directories     C:\Users\user1> mkdir my_cluster my_cluster\ndb_data my_cluster\mysqld_data my_cluster\conf C:\Users\user1> mkdir my_cluster\mysqld_data\mysql my_cluster\mysqld_data\ndbinfo my_cluster\mysqld_data\performance_schema Step 4: Create configuration files for clustering; here I am using two systems