On 5/6/22 11:08, Niels Kobschätzki wrote: > Hi, > > I have a setup where the spamassassin-servers have actually no access to the > data of the mail-servers. Now I was looking into having per user > bayes-databases and saw that I can do that with a SQL-database. I have > already a small galera-cluster and I wonder if spamassassin will work with it > because of the limitations galera has. > The limitations are: > > * only innodb > * unsupported explicit locking > * a primary key on all tables is necessary > * no XA transactions > * no reliance on auto-increment > > Does anyone have experience with such a setup? > Few things to consider: bayes_expire has no primary key. bayes_vars MySQL table has the id defined as "id int(11) NOT NULL AUTO_INCREMENT".
Actually I have no idea if this could be a blocker for you, there should be no problem if you do not use Bayes anyway. Giovanni
OpenPGP_signature
Description: OpenPGP digital signature
