Web Applications do not receive all data in Galera Cluster - Source

Revision: 18830
User: Tim Rice
Date: 2013-08-25 10:52

Hello,

I have a real strange issue.

I have a web application that appears to not show the correct records.

I am using a load balancer for a web farm for a billing system.  I am also using a load balancer for the Galera cluster.

When a trouble ticket is generated, sometimes that ticket is not available on all the web servers, but when I look at each individual MariaDB server, I see the record.

Data commits are synced and all looks good from the cluster side of things.  I can perform a mysqldump to another database and point the billing system to that database and all is good.

If I reboot each MariaDB server one by one, things start working again.  It almost seems like there is some caching where the database cluster at times only shows records that were generated by that web server.

I did check that all the web servers in the farm are using the same load balanced ip address for the MariaDB farm and they are.

I have replicated this on two different web applications (A CRM & Billing system) both on different web farms.

Answer

Content reproduced on this site is the property of its respective owners, and this content is not reviewed in advance by MariaDB. The views, information and opinions expressed by this content do not necessarily represent those of MariaDB or any other party.

Web Applications do not receive all data in Galera Cluster - Source

Answer

Products

Services

Pricing

Resources

About Us

Download MariaDB