Open Dental Forum

Thanks!

Thanks @jsalmon, a couple more questions: When the Open Dental application inserts a row and then immediately selects it, does that operation occur within the same database connection as the insert or does OD run that select using a separate connection? Does Open Dental use prepared statements? Does...

Thanks for the quick reply. So if the proxy classifies queries before sending them to the cluster and decides to route a SELECT to one of the non-writing cluster nodes, that operation would be incompatible with Open Dental? I understand that at the application level but it seems to me that if the pr...

I have a client who runs OD with a MariaDB Galera cluster and ProxySQL as a database proxy layer. It is not optimally configured for high availability. I was told that in the past they tried to do read/write splitting through ProxySQL in order to leverage the read capabilities of the cluster but tha...