(Lalit) As a part database administration, DBA has to take care of sub-components of database like server logs and has to plan for maintenance activity for these components regularly.
Tag: Open Source
MySQL super_read_only Bugs
(Juan Arruti and Marcelo Altmann) This blog we describe an issue with MySQL 5.7’s super_read_only feature when used alongside with GTID in chained slave instances.
Upgrading your MySQL Server Farm
(Geir Hoydalsvik) There are several advantages to keeping up to date with the latest major versions of MySQL. To provide a short example using MySQL 5.7:
A Metric for Tuning Parallel Replication in MySQL 5.7
(Jean-François Gagné) MySQL 5.7 introduced the LOGICAL_CLOCK type of multi-threaded slave (MTS). When using this type of parallel replication (and when slave_parallel_workers is greater than zero), slaves use information from the binary logs (written by the master) to run transactions in parallel.
Analyzing Changing Workloads with the USL
(Baron Schwartz) Production servers often have much more dynamic, complex workload and behaviors than you might be accustomed to seeing, because most monitoring products aggregate system behavior into high-level global metrics, losing all the detail.
Customizing pt-stalk to Capture the Diagnostics Data You Really Need
(Fernando Ipar) Valeriy Kravchuk’s great recent post on using oprofile to profile MySQL mentioned how pt-stalk, the script from Percona Toolkit to capture diagnostics data based on a detected condition, currently does not support the new operf comand, and relies instead on the deprecated and soon to
Overview of Different MySQL Replication Solutions
(Dimitri Vanoverbeke) In this blog post, I will review some of the MySQL replication concepts that are part of the MySQL environment (and Percona Server for MySQL specifically). I will also try to clarify some of the misconceptions people have about replication.
Why MyRocks?
(Mark Callaghan) This is yet another attempt to explain why MyRocks is interesting. MySQL continues to get more popular and should soon become #1 on the db-engines ranking.
Testing performance of MySQL Group Replication
(René Cannaò) MySQL Group Replication is a hot topic in MySQL ecosystem.
WAN Synchronous Clusters: Dealing with Latency Using Concurrency
(Przemys³aw Malkowski) In this blog, we’ll discuss how to use concurrency to help with WAN latency when using synchronous clusters.
