# How to bootstrap with "--lower-case-table-names=1" **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Created:** [June 5, 2020, 10:26am UTC](https://forums.percona.com/t/how-to-bootstrap-with-lower-case-table-names-1/7666 "2020-06-05T10:26:54Z")\ **Posts on this page:** 5\ **Page:** 1
**Author:** ![Bschwarzer](https://avatars.discourse-cdn.com/v4/letter/b/a698b9/32.png) [@Bschwarzer](https://forums.percona.com/u/Bschwarzer)\ **Post date:** [June 5, 2020, 10:26am UTC](https://forums.percona.com/t/how-to-bootstrap-with-lower-case-table-names-1/7666/1 "2020-06-05T10:26:54Z")
For a POC I’m trying to conpare Percona XtraDB Cluster 8 on Ubuntu 18.04 and Kubernetes. Using the documentation everything works fine and I’m able to setup a 3 node cluster on both. Our devs came back with the requirement of “lower\_case\_table\_names=1” Kubernetes works by adding in the deploy/cr.yaml:  [mysqld] lower-case-table-names=1 However a a new VM Ubuntu 18.04 cluster this does not work by adding the same to /etc/mysql/mysql.conf.d/mysqld.cnfThe bootstrap fails. (sudo systemctl start mysql@bootstrap.service) Even if I change it to lower\_case\_table\_names=1 What am I doing wrong? #### Jun 05 15:11:51 db1 systemd[1]: Starting Percona XtraDB Cluster with config /etc/default/mysql.bootstrap…-- Subject: Unit mysql@bootstrap.service has begun start-up-- Defined-By: systemd-- Support: [http://www.ubuntu.com/support----](http://www.ubuntu.com/support----) Unit mysql@bootstrap.service has begun starting up.Jun 05 15:11:56 db1 systemd[1]: mysql@bootstrap.service: Main process exited, code=killed, status=6/ABRTJun 05 15:11:56 db1 mysql-systemd[3636]:  WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readableJun 05 15:11:56 db1 mysql-systemd[3636]:  WARNING: mysql may be already deadJun 05 15:11:56 db1 systemd[1]: mysql@bootstrap.service: Failed with result ‘signal’.Jun 05 15:11:56 db1 systemd[1]: Failed to start Percona XtraDB Cluster with config /etc/default/mysql.bootstrap.-- Subject: Unit mysql@bootstrap.service has failed-- Defined-By: systemd-- Support: [http://www.ubuntu.com/support----](http://www.ubuntu.com/support----) Unit mysql@bootstrap.service has failed.---- The result is RESULT. #### ---
**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\ **Post date:** [June 8, 2020, 4:48pm UTC](https://forums.percona.com/t/how-to-bootstrap-with-lower-case-table-names-1/7666/2 "2020-06-08T16:48:05Z")
Hi @Bschwarzer I was able to reproduce your issue on ubuntu 18.04  If you check the error.log you will see message [ERROR] [MY-011087] [Server] Different lower\_case\_table\_names settings for server (‘1’) and data dictionary (‘0’).If you try to start MySQL 8 with a different value of lower\_case\_table\_names than MySQL was initialized, you will get this message. So you need to re-initialize data directory.  ---
**Author:** ![Bschwarzer](https://avatars.discourse-cdn.com/v4/letter/b/a698b9/32.png) [@Bschwarzer](https://forums.percona.com/u/Bschwarzer)\ **Post date:** [June 9, 2020, 2:47pm UTC](https://forums.percona.com/t/how-to-bootstrap-with-lower-case-table-names-1/7666/3 "2020-06-09T14:47:00Z")
Thank you for the answer. It works. Is there a simpler way to achieve the same end result starting from a completely new server? ---
**Author:** ![Evgeniy\_Patlan](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/evgeniy_patlan/32/41_2.png) [@Evgeniy\_Patlan](https://forums.percona.com/u/Evgeniy_Patlan)\ **Post date:** [June 9, 2020, 3:29pm UTC](https://forums.percona.com/t/how-to-bootstrap-with-lower-case-table-names-1/7666/4 "2020-06-09T15:29:34Z")
@Bschwarzer For now the only way is to re-init data directory after the installation. I have created Jira ticket to improve this case and add the ability to define this before installing package. So it should be fixed for next releases ---
**Author:** ![Bschwarzer](https://avatars.discourse-cdn.com/v4/letter/b/a698b9/32.png) [@Bschwarzer](https://forums.percona.com/u/Bschwarzer)\ **Post date:** [June 10, 2020, 2:07am UTC](https://forums.percona.com/t/how-to-bootstrap-with-lower-case-table-names-1/7666/5 "2020-06-10T02:07:08Z")
Thank you very much for your support and the Jira ticket.