hi! Can I start Fleet with Percona XtraDB Cluster? I am trying create

fleet prepare db

but get error:

2023/07/10 17:53:29 FAIL 20220704101843_AddSoftwareIDInSoftwareCVE.go (adding software_id to software_cve: Error 1845: LOCK=NONE is not supported for this operation. Try LOCK=SHARED.), quitting migration.

How can fix this? mysql Ver 8.0.32-24.2 for Linux on x86_64 (Percona XtraDB Cluster (GPL), Release rel24, Revision 2119e75, WSREP version 26.1.4.3) fleet version 4.33.1

Hey @Lili! While MySQL clusters are not officially supported, I can bring this to the team to see if we can modify the way those locks are handled.

@Kathy Satterlee that will be good, thanks

Redis is in place to help with high speed data access. A MySQL read replica can also be used to help spread the load if you experience bottlenecks on the database side.

@Kathy Satterlee thanks, but if MySQL DB is failed, new agents cant's enroll to Fleet. After if MySQL start, agents enrolled but send to log files messages "INF periodic check of token failed, initiating rotation error="missing or invalid license"" . How we can avoid this errors?

Hi @Lili what version of Fleet are you running? Are you using Fleet Desktop? If so, do you have an update channel set for that?

@Kathy Satterlee orbit 1.12.1 , Fleet 4.34.1 • Go go1.20.1 . No we are dont use Fleet Desktop.

@Grant Bilstad Can you take a look at this? ^

Hi @Lili, apologies for missing your response! Can you check your Fleet configuration to see if you have a value set for the transparency URL?

fleet_desktop:
    transparency_url: <https://fleetdm.com/transparency>

The easiest way to grab the current config is with fleetctl:

fleetctl get config --include-server-config

@Kathy Satterlee hello! i am run

fleetctl get config --include-server-config

in the output i see this config:

fleet_desktop:
    transparency_url: <https://fleetdm.com/transparency>

Would you mind sending over the full config? You're welcome to redact any sensitive information (just make a note if you do) and/or DM that to me.

@Kathy Satterlee i send to DM

Thanks again for sending that over. Everything looks good there. There are a couple of queries I'd like you to run in Fleet to look for any potential outliers: 1. Check for hosts not running the current fleetd:

SELECT * FROM orbit_info where version !="1.17.0";

2. Check for hosts running Fleet Desktop:

SELECT * FROM processes where name="fleet-desktop";

@Kathy Satterlee hello!