(Shinguz) The PAM authentication plug-in is an extension included in MySQL Enterprise Edition (since 5.5) and in MariaDB (since 5.2).
Tag: Open Source
(Baron Schwartz) If you’ve been watching the evolution of database technologies over the past few years, you’ve seen how quickly JSON has quickly cemented its position in major database servers. Due to its use in the web front-end, JSON has overtaken XML in APIs, and it’s spread through all the laye
(Krzysztof Ksiazek) MySQL replication setups can take different shapes. The main topology is probably a simple master-slave setup. But it is also possible to construct more elaborate setups with multiple masters and chained setups.
(Mark Callaghan) This is yet another result to understand an insert-only workload. In this case the database is small enough to be cached by the storage engine.
(Dave Stokes) MySQL 8 features invisible indexes. But what good is an index if you can see it?
(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.
(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.
(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:
(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.
(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