(Giuseppe Maxia) MySQL Group Replication was released as GA with MySQL 5.7.17. It is essentially a plugin that, when enabled, allows users to set replication with this new way.
Tag: Open Source
PHP and MySQL Basics III — Resulting Results
(Dave Stokes) In the first two blogs entries on this series we set up a connection to MySQL and sent off a query. Now we need to get the data back from the database and into the application.
The Impact of Swapping on MySQL Performance
(Peter Zaitsev) In this blog, I’ll look at the impact of swapping on MySQL performance.
Sushi = Beer ?! An introduction of UTF8 support in MySQL 8.0
(Manyi Lu) In MySQL 8.0 our plan is to drastically improve support for utf8. While utf8 support itself dates back to MySQL 4.1, there exist some limitations. The “sushi = beer” problem in the title refers to Bug #76553.
Online schema change with gh-ost – throttling and changing configuration at runtime
(Krzysztof Ksiazek) In previous posts, we gave an overview of gh-ost and showed you how to test your schema changes before executing them. One important feature of all schema change tools is their ability to throttle themselves.
MySQL replication with filtering is dangerous
(Shinguz) From time to time we see in customer engagements that MySQL Master/Slave replication is set-up doing schema or table level replication filtering.
PHP and MySQL Basics II – Case Sense
(Dave Stokes) Last time we set up a connection from a PHP program to a MySQL server. This time we will progress a little further in that direction.
How to Replace MySQL with Percona Server on a CPanel, WHM VPS or Dedicated Server
(Manjot Singh) In this blog post, we’ll look at how to replace MySQL with Percona Server for MySQL on a CPanel, WHM VPS or dedicated server.
How to use the ClusterControl Query Monitor for MySQL, MariaDB and Percona Server
(Ashraf Sharif) The MySQL database workload is determined by the number of queries that it processes. There are several situations in which MySQL slowness can originate.
Reinstall MySQL and Preserve All MySQL Grants and Users
(Peter Zaitsev) In this blog post, we’ll look at how to preserve all MySQL grants and users after reinstalling MySQL.
