# Mysql not starting, no wsrep

**URL:** <https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733>\
**Category:** Percona Server for MySQL 5.6\
**Created:** [October 26, 2021, 12:28am UTC](https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733 "2021-10-26T00:28:14Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Aaron1](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@Aaron1](https://forums.percona.com/u/Aaron1)\
**Post date:** [October 26, 2021, 12:28am UTC](https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733/1 "2021-10-26T00:28:14Z")

</div>

Hello!

I’m trying to startup percona + mysql + galera on FreeBSD 13. I am using the packages from pkg.

I can start my database without any wsrep settings in my my.cnf file. As soon as I add the wsrep settings, mysql won’t start, failing on the first wsrep setting listed. E.g.

> [ERROR] /usr/local/libexec/mysqld: unknown variable ‘wsrep\_on=ON’

I saw another post of someone having similar issues, and their suggestion was that the libgalera\_smm.so was in the wrong place on their system. Is this library where mysqld gets the wsrep settings? I tried linking this library several places on my system, but it didn’t help.

Thanks for any ideas that you have!

Cheers, Aaron

---

<div class="post-metadata">

**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:** [October 26, 2021, 12:51am UTC](https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733/2 "2021-10-26T00:51:54Z")

</div>

Correct. This is the typical setting when using the package installer:

```
wsrep_provider = /usr/lib64/galera3/libgalera_smm.so

```

Find this library, wherever it is on your system (check the package metadata to see where it was installed) and use that path in your my.cnf Don’t symlink, just use the path directly.

---

<div class="post-metadata">

**Author:** ![Aaron1](https://avatars.discourse-cdn.com/v4/letter/a/b5a626/32.png) [@Aaron1](https://forums.percona.com/u/Aaron1)\
**Post date:** [October 26, 2021, 11:26pm UTC](https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733/3 "2021-10-26T23:26:36Z")

</div>

I did include the wsrep\_provider, and even included the flag on the command line to set it. Still no soup.

After digging around more, it appears that mysql needs to be compiles with -DWITH\_WSREP=ON. Otherwise, I believe, the wsrep variables and that functionality will not be available.

Here is my reference: [Has anyone setup MariaDB 5.5 with Galera on FreeBSD 10? | The FreeBSD Forums](https://forums.freebsd.org/threads/has-anyone-setup-mariadb-5-5-with-galera-on-freebsd-10.50602/)

---

<div class="post-metadata">

**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:** [October 27, 2021, 1:28am UTC](https://forums.percona.com/t/mysql-not-starting-no-wsrep/12733/4 "2021-10-27T01:28:00Z")

</div>

> [@Aaron1](#):
>
> I am using the packages from pkg.

I assumed you were using the official Percona XtraDB Cluster packages which natively includes Galera libraries. I recommend that instead of compiling from source, you use the packages we provide.

> **[Percona XtraDB Cluster - MySQL Clustering Solution](https://www.percona.com/mysql/software/percona-xtradb-cluster)**
>
> Experience high availability and scalability with Percona’s MySQL Cluster alternative. Automate database management with ease. Get started today!