Category Archives: database

Is Mysql Cluster Production ready

Is Mysql Cluster Production ready? Setting up a mysql cluster is kind of easy on non-cloud environment by following http://dev.mysql.com/doc/mysql-cluster-excerpt/5.1/en/mysql-cluster-multi-install.html. But when you try to install on cloud (Amazon ec2) for a production environment with auto scale or at least auto heal it is not as straight as it looks, mainly because of few reasons, […]

Connecting to a mysql cluster

Without a load balancer (ELB ) , you can connect to the mysql cluster through a datasource configured in your servlet container or in your spring config , basically you will need a apache commons datasource driver or something similar which support auto health check of the connections in your pool. At a minimum , […]

Migrating Mysql innoDB or MyISAM database to NDB or mysql cluster

Migrating Mysql innoDB or MyISAM database to NDB or mysql cluster Create users and schema create database clusterdb; CREATE USER ‘user’@’localhost’ IDENTIFIED BY ‘pass’; GRANT ALL PRIVILEGES ON *.* TO ‘ ‘user’@’localhost’ WITH GRANT OPTION; GRANT ALL PRIVILEGES ON *.* TO ‘user’@’%’ WITH GRANT OPTION; FLUSH PRIVILEGES; commit; exit; In your existing sql dumps , […]

Mysql cluster setup on amazon cloud

Setting up 6 node Mysql Cluster Read thro http://dev.mysql.com/doc/mysql-cluster-excerpt/5.1/en/mysql-cluster-multi-install.html , there is not much after that. This is just a dump referring to auto scaling mysql cluster This setup has 2 mgmt nodes on 2 different boxes, 2 data+api nodes on another 2 boxes. In brief , you will need to Get mysql mgmt installed […]