# Percona XtraDB installation on Ubuntu 20 **URL:** \ **Category:** Percona XtraDB Cluster 8.x\ **Created:** [February 5, 2021, 6:44pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119 "2021-02-05T18:44:30Z")\ **Posts on this page:** 19\ **Page:** 1
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 5, 2021, 6:44pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/1 "2021-02-05T18:44:30Z")
Hi, I am following the installation documentation for the Unbuntu platform but am not able to bootstrap the first node in my cluster. When running /etc/init.d/mysql bootstrap-pxc I get a message saying: The server quit without creating a pif file. I am running Ubuntu 20 in VMWare and am at a bit of a loss here, I’m following the install steps directly from the Percona docs?? Any pointers would be great!? Thx ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [February 5, 2021, 6:57pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/2 "2021-02-05T18:57:22Z")
Hello @mikejhathaway , Why are you using sysV init scripts? Those died about 5-7 years ago. Where did you see this? At least since Ubuntu 14 systemd has been in control. `systemctl start mysql@bootstrap` is what you want. Additionally, for us to help, you need to give us details from the logs. `/var/log/mysqld.log` is typical. You might want to look in here yourself and see if you can gather any possible issue first. ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 5, 2021, 7:28pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/3 "2021-02-05T19:28:49Z")
Hi @matthewb, Thanks for replying! I am following the Percona docs, basically mysql@bootstrap returns the following! # systemctl start mysql@bootstrap.service Failed to start mysql@bootstrap.service: Unit mysql@bootstrap.service not found. ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [February 5, 2021, 8:21pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/4 "2021-02-05T20:21:53Z")
Can you provide the URL for the docs that still mentions sysV scripts? Please note what I said above. I did not say “mysql@bootstrap.service” ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 5, 2021, 9:13pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/5 "2021-02-05T21:13:11Z")
Here is the link to the docs: > **[Percona Software Documentation](https://docs.percona.com/percona-xtradb-cluster/5.7/bootstrap.html)** > > .container-box-download { justify-content: flex-start; } .container-button-learn-more { margin-bottom: 10px; } .logo-server-home { background: url(/img/product-logos/sprite.png) ``` Instead of changing the configuration, start the first node and use either of the following commands: [root@pxc1 ~]# /etc/init.d/mysql bootstrap-pxc or [root@pxc1 ~]# systemctl start mysql@bootstrap.service ``` Also, I did try your suggestion, the results are the same: ``` # systemctl start mysql@bootstrap Failed to start mysql@bootstrap.service: Unit mysql@bootstrap.service not found. ``` Nothing is being logged @ /var/log/mysqld.log other than when I shut down mysql earlier today ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [February 5, 2021, 9:26pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/6 "2021-02-05T21:26:21Z")
Thanks for that link. I’ll get with our docs team. How did you install PXC? The fact that the unit file does not exist tells me you did not install the packages correctly, or, if you installed via .tar binary, you did not complete all the steps to install the system scripts. I deliver a 2-day intensive PXC training here at Percona. I install PXC all the time via packages, albeit on CentOS, not Ubuntu, and it works fine. ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 5, 2021, 9:58pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/7 "2021-02-05T21:58:47Z")
Hi @matthewb, I am following all of the Percona docs, the install is coming from a repo, not a tar based install: > **[Configuring Percona Repositories with \`percona-release\` - Percona Software...](https://docs.percona.com/percona-software-repositories/percona-release.html)** > > Documentation > **[Percona Software Documentation](https://docs.percona.com/percona-xtradb-cluster/5.7/install/apt.html)** > > .container-box-download { justify-content: flex-start; } .container-button-learn-more { margin-bottom: 10px; } .logo-server-home { background: url(/img/product-logos/sprite.png) ---
**Author:** ![matthewb](https://sea1.discourse-cdn.com/flex019/user_avatar/forums.percona.com/matthewb/32/34_2.png) [@matthewb](https://forums.percona.com/u/matthewb)\ **Post date:** [February 5, 2021, 10:39pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/8 "2021-02-05T22:39:50Z")
Can you see if it is `systemctl start mysqld@bootstrap` ? I’ve seen that difference before: mysql vs mysqld ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 5, 2021, 10:55pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/9 "2021-02-05T22:55:50Z")
Doesnt seem so: ``` # systemctl start mysqld@bootstrap Failed to start mysqld@bootstrap.service: Unit mysqld@bootstrap.service not found ``` ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 5, 2021, 10:58pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/10 "2021-02-05T22:58:26Z")
If I run systemctl to list all services, mysqld is not listed! ---
**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:** [February 8, 2021, 1:37pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/11 "2021-02-08T13:37:46Z")
Hi @mikejhathaway I tried to reproduce the issue but without success. ``` vagrant@ubuntu-bionic:~$ sudo /etc/init.d/mysql bootstrap-pxc * Bootstrapping Percona XtraDB Cluster database server mysqld [OK] vagrant@ubuntu-bionic:~$ ``` What could be the issue. When you install PXC on ubuntu it automatically starts mysqld service. So you should firstly stop mysqld process and after that you should bootstrap node ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 8, 2021, 2:19pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/12 "2021-02-08T14:19:33Z")
Hi Evgeniy\_Patlan, Many Thanks for the reply. I am able to stop the MySQL Service Next I proceed to bootstrap the first node I get the errors?! ```auto # systemctl start mysql@bootstrap.service Failed to start mysql@bootstrap.service: Unit mysql@bootstrap.service not found. ``` ---
**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:** [February 8, 2021, 2:37pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/13 "2021-02-08T14:37:56Z")
@mikejhathaway Try to use initd script `sudo /etc/init.d/mysql bootstrap-pxc` For 5.7 we didn’t update init.d to systemd unitfiles. ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 8, 2021, 2:50pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/14 "2021-02-08T14:50:43Z")
Thanks, this is where I started, using init.d is the other example in the documentation of starting the bootstrap sequence, this fails with: ``` # sudo /etc/init.d/mysql bootstrap-pxc * Bootstrapping Percona XtraDB Cluster database server mysqld * The server quit without updating PID file (/var/run/mysqld/mysqld.pid). ``` ---
**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:** [February 8, 2021, 5:36pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/15 "2021-02-08T17:36:23Z")
@mikejhathaway Could you please show the mysqld.log and my.cnf file? ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 8, 2021, 6:07pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/16 "2021-02-08T18:07:13Z")
Hi, The my.cnf is off of the shelf: ``` # # The Percona XtraDB Cluster 5.7 configuration file. # # # * IMPORTANT: Additional settings that can override those from this file! # The files must end with '.cnf', otherwise they'll be ignored. # Please make any edits and changes to the appropriate sectional files # included below. # !includedir /etc/mysql/conf.d/ !includedir /etc/mysql/percona-xtradb-cluster.conf.d/ ``` I cannot attach the log file as I am a new user. The only error that stands out is: `2021-02-08T17:58:32.087342Z 0 [Warning] WSREP: Fail to access the file (/var/lib/mysql//gvwstate.dat) error (No such file or directory). It is possible if node is booting for first time or re-booting after a graceful shutdown` `2021-02-08T17:58:32.087351Z 0 [Note] WSREP: Restoring primary-component from disk failed. Either node is booting for first time or re-booting after a graceful shutdown` I also see ``` 2021-02-08T17:58:32.435093Z 0 [ERROR] unknown option '--Authentication for SST method' 2021-02-08T17:58:32.435114Z 0 [ERROR] Aborting ``` Here is the contents of wsrep.cnf: ``` [mysqld] # Path to Galera library wsrep_provider=/usr/lib/galera3/libgalera_smm.so # Cluster connection URL contains IPs of nodes #If no IP is found, this implies that a new cluster needs to be created, #in order to do that you need to bootstrap this node wsrep_cluster_address=gcomm://191.168.195.138 # In order for Galera to work correctly binlog format should be ROW binlog_format=ROW # MyISAM storage engine has only experimental support default_storage_engine=InnoDB # Slave thread to use wsrep_slave_threads= 8 wsrep_log_conflicts # This changes how InnoDB autoincrement locks are managed and is a requirement for Galera innodb_autoinc_lock_mode=2 # Node IP address #wsrep_node_address=192.168.70.63 # Cluster name wsrep_cluster_name=pxc-cluster #If wsrep_node_name is not specified, then system hostname will be used wsrep_node_name=pxc-cluster-node-1 wsrep_node_address=192.168.195.138 #pxc_strict_mode allowed values: DISABLED,PERMISSIVE,ENFORCING,MASTER pxc_strict_mode=ENFORCING # SST method wsrep_sst_method=xtrabackup-v2 Authentication for SST method wsrep_sst_auth=sstuser:caPassw0rd ``` ---
**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:** [February 8, 2021, 6:23pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/17 "2021-02-08T18:23:03Z")
@mikejhathaway Thanks for your reply. As I can see from the provided information you have uncommented comment line and mysqld tries to parse the option but it is just comment and there is no such option. So please comment line `Authentication for SST method` in wsrep.cnf (the last but one line) ---
**Author:** ![mikejhathaway](https://avatars.discourse-cdn.com/v4/letter/m/ecc23a/32.png) [@mikejhathaway](https://forums.percona.com/u/mikejhathaway)\ **Post date:** [February 8, 2021, 6:41pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/18 "2021-02-08T18:41:50Z")
Hi @Evgeniy_Patlan, Argh!!! D’ou!!! What a moron, I hadn’t spotted that!! As usual, the issue is between the keyboard and the chair! ``` # sudo /etc/init.d/mysql bootstrap-pxc * Bootstrapping Percona XtraDB Cluster database server mysqld [OK] ``` Thanks for pointing out my mistake! ---
**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:** [February 8, 2021, 6:57pm UTC](https://forums.percona.com/t/percona-xtradb-installation-on-ubuntu-20/9119/19 "2021-02-08T18:57:18Z")
@mikejhathaway I am glad I was able to help. If any questions appear - you know we are glad to help 🙂