Take the 2-minute tour ×
Server Fault is a question and answer site for system and network administrators. It's 100% free, no registration required.

I currently have mysql clustering up and running. For high scalability is there a way to include either mysql node, data nodes, or management nodes without restarting the entire cluster. I wish to understand how is it implement or is there a documentation I can read. I believe only the latest version can support this. I am running NDB 7.0. I am aware that I am able to add the nodes online, but it requires me perform a rolling restart.

What other approach I can take to implement this without restarting in my network?

share|improve this question

migrated from superuser.com Mar 27 '12 at 3:58

This question came from our site for computer enthusiasts and power users.

2 Answers 2

up vote 0 down vote accepted

If you pre-defined the MySQL Server slots in your config.ini file then you don't need a rolling restart when you actually run your mysqld process. If you didn't include the empty slots then you'd need a rolling restart after adding them

note that the rolling restart doesn't bring the cluster down - it can continue to serve read and write requests while adding nodes

share|improve this answer

As Mat said, you must predict how many new data nodes you'll have in your cluster and avoid to perform a cluster rolling restart. You must pay more attention regarding the cluster security when you have many [ndbd] sections in config file.

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.