Topics

1

MySQL / Galera (mariaDB) configuration recommendations

« on: March 15, 2025, 12:27:20 PM »

Hello all

I've been tinkering with the latest version of Gemini 2.0 and it gave me pretty solid instructions about custom configuration settings on our MariaDB 11.4.5

The performance has improved by a lot, and there is no more lag from slow queries.

Now taking it one step further, Gemini suggests to edit some rows on the [galera] section.

Here's the recommendation:

[galera]
# Mandatory settings
wsrep_on=ON
wsrep_provider="/usr/lib64/galera/libgalera_smm.so"  # Update with the correct path wsrep_cluster_address="gcomm://node1.example.com,node2.example.com,node3.example.com"  # Replace with your node addresses binlog_format=row
default_storage_engine=InnoDB
innodb_autoinc_lock_mode=2

# Allow server to accept connections on all interfaces.
bind-address = 0.0.0.0 # Optional settings (adjust values based on your needs and environment)
wsrep_slave_threads=4  # Increase for better replication performance
innodb_flush_log_at_trx_commit=2  # Balance performance and data durability

# Other important Galera settings (add and customize as needed)
wsrep_node_name = "node1"  # Set a unique name for each node
wsrep_sst_method = rsync  # Recommended SST method
wsrep_certify_nonpk = 1  # Enable if you have many non-primary key updates
wsrep_max_ws_rows = 128  # Adjust based on your transaction sizes
wsrep_max_ws_size = 1073741824  # Adjust based on your transaction sizes and network bandwidth

# ... other Galera settings ...

Key changes and explanations:
Uncomment and complete mandatory settings:
wsrep_provider: Provide the actual path to your Galera library file.
wsrep_cluster_address: List the IP addresses or hostnames of all nodes in your Galera cluster.
   
Adjust optional settings:
wsrep_slave_threads: Increase from the default 1 to improve replication performance. Start with a moderate value and monitor for optimal results.
innodb_flush_log_at_trx_commit: Set to 2 for a balance between performance and data durability in Galera.
   
Add other important Galera settings:
wsrep_node_name: Assign a unique name to each node in your cluster.
wsrep_sst_method: Use rsync as the recommended SST method for efficiency.
wsrep_certify_nonpk: Enable if your workload involves many non-primary key updates.
wsrep_max_ws_rows and wsrep_max_ws_size: Adjust these based on your typical transaction sizes and network bandwidth.
   

Anyone has experience with this?


Any suggestions? Is this a feasible configuration?


How can I locate the mentioned files?


Thank you very much

2

Addons / WordPress Management Tool (i.e. WP-Toolkit)

« on: March 12, 2025, 04:54:22 AM »

Hi all

Feel free to move this thread to another section of the forum if it is not related here.

When I was using cPanel to manage our client websites, I was using WP-Toolkit solution for centralized updates and security suggestions.

Is there a similar add-on for CWP? (server-side)

Note, my question refers to centralized management like plugin updates, etc. Not about installing/removing Wordpress.

Thank you very much.

3

CSF Firewall / CSF and CloudFlare Integration

« on: December 30, 2024, 12:16:18 PM »

Hello there

So I went through the configuration of CloudFlare following the guidelines here:
https://download.configserver.com/csf/readme.txt

I'm using the "ANY" method since I have many domains under my CloudFlare account.

I've already configured and running mod_remoteip with all CloudFlare IPs on my Apache server.

Questions:
1) How can I actually verify that the CloudFlare Integration is working as intended?

2) Could I add a second API + credentials under the csf.cloudflare file since I have access and manage multiple accounts?

Thank you very much

4

Apache / Apache 2.4.62 configuration with module socache redis

« on: December 29, 2024, 01:31:27 PM »

Hello there, first post here, congratulations for the excellent work.

So I’m running Apache 2.4.62 + suPHP 0.72 on my CWP Pro server and I would like to activate the

Code: [Select]

module_socache_redis since I’m using Redis.

However I haven't found any opinion if that would create any positive benefit or not.

I tried this configuration as a starting point (based on the Gemini Advanced suggestion)

Code: [Select]

LoadModule socache_redis_module modules/mod_socache_redis.so

<IfModule socache_redis_module>

RedisConnectionPool 127.0.0.1:6379 10 keepalive 10000 300

RedisTimeout 1000

</IfModule>
Is that a good starting point?

I'm looking for a performance optimization.

Looking forward to your thoughts.

5

CSF Firewall / Load CSF statistics on CWP

« on: December 29, 2024, 01:26:44 PM »

Hello all

I was wondering how can I enable the appearance of CSF Statistics on CWP

According to CSF section Statistics:

# Statistics
#
# Some of the Statistics output requires the gd graphics library and the
# GD::Graph perl module with all dependent modules to be installed for the UI
# for them to be displayed

So I have enabled the mentioned libraries (or I believe I have).

And I have enabled the Statistics gathering and displaying options under the configuration section.

Now what? Where would I see the statistics showing up?

At the moment I don't see anything and my CSF is on fire "event-wise"

Looking forward to your feedback

Thank you very much.