# run DDL on 3 nodes production cluster with multiple schema

**URL:** <https://forums.percona.com/t/run-ddl-on-3-nodes-production-cluster-with-multiple-schema/6242>\
**Category:** Percona XtraDB Cluster 5.x\
**Created:** [March 10, 2018, 7:18am UTC](https://forums.percona.com/t/run-ddl-on-3-nodes-production-cluster-with-multiple-schema/6242 "2018-03-10T07:18:56Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![notonlyforweb](https://avatars.discourse-cdn.com/v4/letter/n/aca169/32.png) [@notonlyforweb](https://forums.percona.com/u/notonlyforweb)\
**Post date:** [March 10, 2018, 7:18am UTC](https://forums.percona.com/t/run-ddl-on-3-nodes-production-cluster-with-multiple-schema/6242/1 "2018-03-10T07:18:56Z")

</div>

Hi,  
I couldn’t find anywhere any answer how to run DDL on production cluster with multiple schema.

Environment:  
In 3 nodes production cluster I have about 10 schema, each one is dedicated for different Client. Databases are rather big, there are tables which have over 7mln of records.

Problem:  
From time to time there is a need to alter table. Unfortunately wherever I have to make something like that not only one schema is not available but all databases 😕 All environment is being blocked by DDL operation which is dramatic and has nothing common with HA idea.

My temporary solution which I don’t like:  
I disconnect one node from the cluster, run DDL on this disconnected node, then I make a dump and recovery it on running DB Cluster. After all this steps I am preparing disconnected node to connect to cluster with SST.

During this all horrible steps all databases are on-line which is the most important for me.

What I would like to have:  
Please is there any other better solution to run DDL without affecting any others DATABASES except this one on each DDL is running ?

Regards,  
M.J.

---

<div class="post-metadata">

**Author:** ![Kenn\_Takara](https://avatars.discourse-cdn.com/v4/letter/k/b2d939/32.png) [@Kenn\_Takara](https://forums.percona.com/u/Kenn_Takara)\
**Post date:** [March 13, 2018, 6:41pm UTC](https://forums.percona.com/t/run-ddl-on-3-nodes-production-cluster-with-multiple-schema/6242/2 "2018-03-13T18:41:34Z")

</div>

Here is a blog post from severalnines that may help. It has a good description of the options available for schema upgrades with Galera (the technology that PXC uses).

[url][https://severalnines.com/blog/online-schema-upgrade-mysql-galera-cluster-using-toi-method[/url]](https://severalnines.com/blog/online-schema-upgrade-mysql-galera-cluster-using-toi-method%5B/url%5D)
