…#560)

* added github action for Docker Scout compare
* added Docker Scout step
* set correct secrets for DOCKERHUB
* upgrade git version
* (2.45.1-r0) is not available in the Alpine repositories, and a newer version (2.45.2-r0) is available instead
* changed dockerhub secrets to readonly

Replace yaml.v2 with yaml.v3

### Commit Title: Implement Multi-Proxy and Load Balancer Strategy Support

This commit introduces significant enhancements to the server configuration by supporting multiple proxies and load balancing strategies.

#### Key Changes:

- **API Tests**: Updated to reflect the change from a single `Proxy` to a list of `Proxies`.
- **Initialization and Configuration**: Modified `run.go` to support multiple proxies and load balancer strategies.
- **Configuration Files**: Updated to include fields for multiple proxies and load balancer strategies.
- **Global Configuration Validation**: Enhanced for clients, pools, and proxies.
- **Load Balancer Configuration**: Added a new `loadBalancer` section in `gatewayd.yaml` for rules and strategies.
- **Load Balancing Strategies**: Implemented strategy selection and the Round Robin strategy.
- **Testing**: Added tests for load balancer strategies and updated existing tests.
- **Error Handling**: Introduced a new error type `ErrorCodeLoadBalancerStrategyNotFound`.
- **Proxy Connection Handling**: Improved and added informative comments.

#### Configuration Example:

- **gatewayd.yaml**: Updated to reflect support for multiple proxies and load balancer strategies. Ensure to update your configuration files accordingly.

#### Testing:

- Updated existing tests and added new tests for multi-proxy and load balancing functionality.
- Verified configuration validation for proxies and load balancers.

#### Impact:

- Improved flexibility and scalability of server configuration.
- Enabled robust proxy management and efficient load distribution.

### Additional Changes:

- **Nested Map Structure**: Refactored maps to use nested structures for pools, clients, and proxies.
- **Variable Names**: Refactored for consistency and clarity across multiple files.
- **YAML Tags**: Added to struct fields for `Client`, `Pool`, and `Proxy` types to ensure compatibility with YAML parsers.
- **Configuration Block Names**: Changed from kebab-case to camelCase.
- **Tracing**: Avoided using the request context for tracing in the `GetPools` method.
- **GetServers API**: Enhanced to include load balancer configuration and updated tests.

### Minor Fixes:

- Corrected typos and resolved lint warnings.
- Added comments and fixed formatting issues in configuration files.

### Sign-offs and Co-authors:

- Co-authored-by: Mostafa Moradian <[email protected]>
- Signed-off-by: sina <[email protected]>

…ata type (#584)

* Update golangci-lint in CI
* Remove deprecated linters
* Disable fatcontext
* Remove copied function, because CGO is no longer used in the SDK

…ble parsing (#588)

* Added mapenv JSON tag function and unit tests for server load balancer strategy configuration
* Added `transformEnvVariable` function to format environment variable names based on JSON tags
* Modified `loadEnvVars` to use the new `transformEnvVariable` function
* Added `generateTagMapping` to create mappings from struct fields' JSON tags
* Added unit test `ServerLoadBalancerStrategyOverwrite` to verify that the server load balancer strategy is set and loaded correctly from environment variables
* Added unit test `pluginDefaultPolicyOverwrite` to verify that the plugin default policy is set and loaded correctly from environment variables
* Added `initializeConfig` helper function to simplify configuration setup for tests
* Updated `TestLoadEnvVariables` to include a scenario for server load balancer strategy overwrite
* Updated comment for `generateTagMapping` function to clarify tag case handling

* Added function to Convert Keys To Lowercase
* added check config block to validation
* convert all refrereced configblock to lowercase
* fixed lint issues
* Fix error wrapping to create new instances for each error
* added testcases for LoadEnvVariables
* added testcase for ConvertKeysToLowercase
* refactor  lowerKey to lowercaseKey
* refactor active-writes to writes and standby-reads to reads
* set env var for test cases from cons
* fixed lint issues

* Renamed the `postgres` service to `write-postgres` and added configuration for the write database.
* Added a new `read-postgres` service to handle read database operations.
* Updated `gatewayd` environment variables to support separate read and write addresses.
* Updated `gatewayd` links and dependencies to include `write-postgres` and `read-postgres`.

* Introduced `RANDOM` strategy in `constants.go` and `loadbalancer.go`.
* Updated `gatewayd.yaml` to use the new `RANDOM` strategy as an option.

* Added ConsistentHash
* changed net conn into Iconnwrapper
* added test cases for onsistentHash
* fixed lint issues
* replace RWMutex to Mutex and added test case for concurency access
* added github.com/spaolacci/murmur3 into depguard

* Update deps
* Update Go version
* Regen stubs
* Add mentioned in awesome badge
* Update testcontainers-go dep
* Fix linter errors
* Tidy deps
* Use the latest version of golangci-lint (as of now)