Understand HAProxy to load balance on a Galera Cluster
I am a newbie in software architecture and I have some question:
I don't understand which requests is sent to the HAProxy on this image.
I mean: if one "Application" Server (backend) want to save data in the Galera Cluster
what is the request that will be sent to the HAProxy?
Is it an sql query "request"?
If it is an sql query should the HAProxy server needs a mysql-server to "handle" the connection?
Should Application Server needs to be configured to make an sql connection to the HAProxy?
from: https://fromdual.com/making-haproxy-high-available-for-mysql-galera-cluster
Thanks!
The application only needs to know the IP address of the VIP in this architecture. The app connects to that VIP using a MySQL connector, as if it is a MySQL Server.
The "requests" are then stateful TCP/IP connections using the MySQL protocol, just as if the app were connected directly to a MySQL node.
This is not a series of stateless http requests. You might be assuming that HAProxy is only for load-balancing http requests. In fact, HAProxy can be used for other protocols than http.
- How/when mysql compiles stored procedures?
- UPDATE column with Y or N if data exists in another table
- #1273 – Unknown collation: ‘utf8mb4_unicode_520_ci’
- How to get Python MYSQL connection username and password?
- Table is marked as crashed and should be repaired
- Coverting a .BAK file into a .SQL for use in XAMPP phpmyadmin
- Query through JSON Array with multiple values in MySQL
- Housing Society management system database structure
- MySQL DROP all tables, ignoring foreign keys
- When to use prepared statements?
- When *not* to use prepared statements?
- Are Prepared Statements a waste for normal queries? (PHP)
- Deleting rows in mysql table that contain an empty field where more complete rows exist
- MySQL given date between monday and sunday
- JSON_TABLE - how to access fields inside escaped quotes?
- mysqldump - maintain character set and collations
- Why can't a text column have a default value in MySQL?
- Using Hibernate's ScrollableResults to slowly read 90 million records
- Foreign key in the child table is null after persisting @OneToMany
- How to fix products without cover image in PrestaShop
- Laravel Eloquent Query Using Case/When to apply conditions dynamically
- MySQL SELECT a field as NULL if not existent in table
- How can I show all duplicate value from a specific column in MySQL
- Declaring 2 Cursors in a Stored Procedure | SQL Error [1338] [42000]: Cursor declaration after handler declaration
- PHP mySQL - Insert new record into table with auto-increment on primary key
- IF ROW_COUNT() return error
- Date column with associated MAX count value
- Drop Column from Large Table
- MySQL - 'Using index condition' vs 'Using where; Using index'
- Conversion issues in sql - GREATEST(CEILING())