Backups, Replication, and More (Paperback)
===== Tools =====
==== Myterm ====
[[https://launchpad.n... urself running the same query over and over again to see if a table has got new content, just waiting for that magic row to appear? The tail command will watch for new lines... lMyqlWorkbenchPlugin]]
===== Tips =====
==== How to select random rows in MySQL ====
The easiest way
replication ======
Des questions:
* vérifier automatiquement que la réplication fonctionne
* le s... * Définissez **expire_logs_days** plus long que tout décalage possible du replica.
* max_binlog_... ely Purging Binary Log Files While Replicating]]
To be sure replication is not broken while deleting ... e primary by running **SHOW BINARY LOGS**.
* Go to each replica server and run **SHOW SLAVE STATUS**
root password =====
<code bash>
sudo systemctl stop mariadb.service
sudo mysqld_safe --skip-grant-tables
mysql -u root
# Important to avoid without grant table error !
MariaDB [(none)... ocalhost' identified by 'secret' ;
</code>
then stop ''mysqld_safe'' and restart service.
==== Instal... mise à jour intégrée avec les système Debian, CentOS, Ubuntu...
* [[https://downloads.mariadb.org/m
======
https://redis.io/
* [[https://redis.io/topics/benchmarks|How fast is Redis?]] (doc latest)
... s. Ils disent qu'il est plus performant. 😉
===== Tools =====
* https://github.com/erikdubbelboer/
