Hybris and proxysql integration

[Former Member]

Hi There,

Is proxysql supported by Hybris? Basically, we need to split read/write operations on proxy level and not at application level. As haproxy does not support this feature, we are wondering if hybris can be used whith proxysql and what are the possible issues. From help pages, we saw that Haproxy is full supported and recommended but unfortunately that's not what we need.

Thanks.

[liu_chun_yin]

Hi,

I am configing proxysql to hybris 1811, but when server startup throw below, do you encounter this and what causing that?
full stacktrace:
https://answers.sap.com/questions/13014616/hybris-1811-server-start-up-throw-error-code-0-col.html

org.springframework.jdbc.UncategorizedSQLException: ConnectionCallback; uncategorized SQLException for SQL []; SQL state [S0022]; error code [0]; Column 'Collation' not found.; nested exception is java.sql.SQLException: Column 'Collation' not found.

[eric_rosfelder]

Hi ,

We try to use proxysql, but we faced some exception when using it.

Like :

 Caused by: [de.hybris.platform.servicelayer.exceptions.ModelSavingException - Entity not found ( pk = 9029434376222 name = 'de.hybris.platform.persistence.core_Media' type code = '30' db table = 'medias'): object no longer valid]

The PK 9029434376222 exist, but i think when proxysql try to read it, he try to read it on a mysql node that haven't yet this data. But 1 second later, it should be OK...

We don't find how to fix it.

Notes :

• we have 3 nodes MySQL working with master/master.

• with haproxy we have no theses type of errors.

If you have somes feedbacks, it will be appreciate.

Thanks, Eric