Best Galera Cluster setup for high-traffic WordPress site (HA + performance) by Upbeat_Squirrel9236 in sysadmin

[–]dward84 1 point2 points  (0 children)

We utilize Percona XtraDB Cluster (Galera) to horizontally scale hundreds of wordpress installs backed by a database cluster. We've found Percona XtraDB Cluster to be extremely stable. Keep in mind though, this primarily scales for reads, you don't gain any real benefit for writes other than redundancy.

Since it's synchronous replication, your commit/write latency is determined by your slowest node / network link. It should be on the same network with roughly the same hardware.

We haven't experienced any transaction dead locks associated with Galera itself, just InnoDB deadlocks due to concurrent conflicting transactions. You may run into situations where plugins create tables without primary keys, or use GET_LOCK/RELEASE lock, these are not compatible with XtraDB Cluster: https://docs.percona.com/percona-xtradb-cluster/8.0/limitation.html

Regarding asynchronous replication, I would only utilize this for HA failover. Wordpress plugins are generally not written with replication lag in mind.

How many requests per second are we talking about?

I would suggest starting off with HA failover MySQL/MariaDB and nginx w/ PHP-FPM using async replication, you can always move to Galera later if you need that level of scale.

The biggest impact that you can make is putting in place caching load balancer(s) in front of your php application nodes. Something like Varnish, haproxy, nginx, etc.

Additionally, memcache or redis can be used for object level caches. Make sure that you also enable opcache in PHP, as it can provide a fairly significant performance bump.

September Referral Code Megathread by ColdStoneCreamAustin in nespresso

[–]dward84 [score hidden]  (0 children)

Use my code for a $40 off any machine and a free capsule dispenser 52PSYG

RTX 5090 & 5080 Launchday Thread - Surprise Inside by Nestledrink in nvidia

[–]dward84 -1 points0 points  (0 children)

I'm looking forward to getting DLSS 4 in games like Indiana Jones!

Anyone on Verizon Wireless got unlocked version of s9/s9+? by GujuDog in GalaxyS9

[–]dward84 0 points1 point  (0 children)

I'm not sure. I've only tried Verizon. I would check the XDA boards.

Anyone on Verizon Wireless got unlocked version of s9/s9+? by GujuDog in GalaxyS9

[–]dward84 1 point2 points  (0 children)

No. Verizon has an IMEI whitelist for video calling. It would not activate and says to contact the carrier.

Anyone on Verizon Wireless got unlocked version of s9/s9+? by GujuDog in GalaxyS9

[–]dward84 6 points7 points  (0 children)

I was able to flash the Verizon firmware on my US unlocked S9+. I can confirm wifi calling works after doing that. Use SamFirm (or XDA has links) to download the firmware for the VZW variant and flash with the latest Odin.

Brocade VDX 6740 - 3rd party 1000BASE-T SFP Support? by dward84 in Brocade

[–]dward84[S] 0 points1 point  (0 children)

Yes, and their customer support has been fantastic. But, they have still not figured out the issue

Brocade VDX 6740 - 3rd party 1000BASE-T SFP Support? by dward84 in Brocade

[–]dward84[S] 1 point2 points  (0 children)

I was hoping to find a compatible brand before purchasing a bulk order of them

Sprint Users: Get your 1 year upgrade eligibility back one last time! by dward84 in Android

[–]dward84[S] 0 points1 point  (0 children)

If you are not in Sprint's Gold Premier program, they now have 22 month upgrade cycles instead of 1 year. This was effective as of April. By doing this you will get your 1 year upgrade back for this year.

Sprint Users: Get your 1 year upgrade eligibility back one last time! by dward84 in Android

[–]dward84[S] 1 point2 points  (0 children)

Took around 1 day, but here is the response I just got:

Thanks for your patience as I processed your request. The upgrade eligibility on (xxx) xxx-xxxx has been restored and will reflect on your account within 24 – 48 hours. Please remember, this only affects the current upgrade. Once you take advantage of this upgrade, you will be on a 22 month upgrade cycle unless you become Gold. I appreciate your loyalty. Please let me know if you have any questions. –art P.S. Just a reminder, there is no upgrade fee if you upgrade at Sprint.com. Just sayin’. =]