Not the answer you need?
Register and ask your own question!

How to bootstrap with "--lower-case-table-names=1"

BschwarzerBschwarzer Current User Role Novice
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.cnf
The bootstrap fails. (sudo systemctl start [email protected])
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 [email protected] has begun start-up
-- Defined-By: systemd
--
-- Unit [email protected] has begun starting up.
Jun 05 15:11:56 db1 systemd[1]: [email protected]: Main process exited, code=killed, status=6/ABRT
Jun 05 15:11:56 db1 mysql-systemd[3636]:  WARNING: mysql pid file /var/run/mysqld/mysqld.pid empty or not readable
Jun 05 15:11:56 db1 mysql-systemd[3636]:  WARNING: mysql may be already dead
Jun 05 15:11:56 db1 systemd[1]: [email protected]: 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 [email protected] has failed
-- Defined-By: systemd
--
-- Unit [email protected] has failed.
--
-- The result is RESULT.
####

Best Answer

Answers

  • BschwarzerBschwarzer Current User Role Novice
    Thank you for the answer. It works. Is there a simpler way to achieve the same end result starting from a completely new server?
  • Evgeniy PatlanEvgeniy Patlan Percona Percona Staff Role
    @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
  • BschwarzerBschwarzer Current User Role Novice
    Thank you very much for your support and the Jira ticket.
Sign In or Register to comment.

MySQL, InnoDB, MariaDB and MongoDB are trademarks of their respective owners.
Copyright ©2005 - 2020 Percona LLC. All rights reserved.