(kabilesh) We have been working with PMM for quite a long time, we do most of the performance analysis with PMM for most of our clients. It also provides the flexibility that we have built our own custom dashboard.
Tag: Open Source
Automatic member fencing with OFFLINE_MODE in Group Replication
(Nuno Carvalho) Group Replication enables you to create fault-tolerant systems with redundancy by replicating the system state to a set of servers. Even if some of the servers subsequently fail, as long it is not all or a majority, the system is still available.
Dirty reads in High Availability solution
(Marco Tusa) Recently I had been asked to dig a bit about WHY some user where getting dirty reads when using PXC and ProxySQL.
MySQL EXPLAIN ANALYZE
(Norvald H. Ryeng) MySQL 8.0.18 was just released, and it contains a brand new feature to analyze and understand how queries are executed: EXPLAIN ANALYZE.
MySQL load data infile made faster
(Sri Sakthivel) Loading any large file into MySQL server using the LOAD DATA INFILE is a time consuming process , because it is single threaded and it is a single transaction too. But with modern hardwares system resource is not a bottle neck.
MySQL Shell 8.0.18 – What’s New?
(Rene Ramirez) The MySQL Development team is proud to announce a new version of the MySQL Shell with the following major improvements:
Support for TLS 1.3 in Group Replication
(Tiago J.) In MySQL 8.0.18, we enhanced the Group Communication System (GCS) layer used by Group Replication (GR) with the ability to use and configure member-to-member connections using TLS v1.3.
Foreign Key bugs in MySQL and MariaDB
(Federico Razzoli) Foreign keys are a controversial topic. Some developers love them, because they make the database more robust. Some DBAs forbid them, because they propagate locks, increase the number of reads, and pollute the buffer pool.
Replication with restricted privileges
(Pedro Figueiredo) Up until MySQL 8.0.18, the slave executes replicated transactions without checking privileges. It does so to be able to apply everything that its upstream server (the master) tells it to. In practice this means that the slave fully trusts its master.
MySQL InnoDB Cluster – What’s new in Shell AdminAPI 8.0.18 release
(Miguel Araújo) The MySQL Development Team is very happy to announce a new 8.0 Maintenance Release of InnoDB Cluster – 8.0.18.