(Peter Gulutzan) The following statement usually is valid and the function returns 1. But sometimes it is invalid and sometimes the function returns 0.
Tag: Open Source
Monitoring S.M.A.R.T. Metrics with Prometheus and PMM
(Peter Zaitsev) In his excellent blog post, Pavel Trukhanov showed the value of S.M.A.R.T. metric collections, so I wondered how hard would it be to enable their collection in Percona Monitoring and Management (PMM)
Awesome MySQL Shell Prompt
(Jesper Krogh) A month ago, I wrote a blog on how you can configure the MySQL Shell prompt to suit your needs. One thing I did not go into details with are the prompt templates prompt_256pl.json and prompt_256pl+aw.json.
How to Compile Percona Server for MySQL 5.7 in Raspberry Pi 3
(Walter Garcia) In this post I’ll give to you the steps to compile Percona Server for MySQL 5.7.22 in Raspberry Pi 3. Why? Well because in general this little computer is cheap, has low power consumption, and is great to use as a test machine for developers.
Configuring GTID and binary logging
(Gabriela D’Ávila) This tutorial demands a service restart since some flags here presented can not be dynamically changed
MySQL NDB Cluster: Never Install a Management Node on the Same Host as a Data Node
(Jesper Krogh) In MySQL NDB Cluster, the management node (ndb_mgmd) is a lightweight process that among other things handles the configuration of the cluster. Since it is lightweight. It can be tempting to install it with one of the other nodes.
ProxySQL Series : Percona Cluster/MariaDB Cluster (Galera) Read-write Split
(kabilesh) ProxySQL is the most preferred and is widely used for load-balancing MySQL workload, thanks to Rene Cannon & Team for the great tool, and kudos on the recent release of ProxySQL 1.4.10, with a lot of bug fixes.
Database Security Monitoring for MySQL and MariaDB
(Bart Oles) Data protection is one of the most significant aspects of administering a database. Depending on the organizational structure, whether you are a developer, sysadmin or DBA, if you are managing the production database, you must monitor data for unauthorized access and usage.
How to setup a Replication User
(Gabriela D’Ávila) A replication user is necessary to set up the relationship Primary/Replica. This is a short step but it needs a bit more of attention.
Using AWS EC2 instance store vs EBS for MySQL: how to increase performance and decrease cost
(Alexander Rubin) If you are using large EBS GP2 volumes for MySQL (i.e. 10TB+) on AWS EC2, you can increase performance and save a significant amount of money by moving to local SSD (NVMe) instance storage. Interested?