VirtualTam's bookmarks

1. dev-sec/ansible-collection-hardening - Hardening for Linux, SSH, Apache HTTPD, Nginx, MySQL 2024-03-31

   tags: configuration-management/ansible, database/mysql, linux, network/http-server/apache-httpd, network/http-server/nginx, network/ssh

   [ permalink ]
2. pgloader - load data from various sources into PostgreSQL 2022-04-17

   tags: command-line, database/mysql, database/postgresql, database/sqlite, linux, programming/csv, programming/lisp

   [ permalink ]

   • dimitri/pgloader
   • MySQL to PostgreSQL
   • pgloader#645 - How to import into public schema
3. Percona Toolkit Documentation 2020-01-21

   tags: database, database/mysql, observability/logging, performance, programming/sql, query

   [ permalink ]

   • https://www.percona.com/blog/2018/09/13/analyzing-amazon-aurora-slow-logs-pt-query-digest/
   • https://www.jeffgeerling.com/blog/2018/analyzing-mysql-slow-query-log-pt-query-digest
4. pspg: Unix pager designed for work with tables. Designed for PostgreSQL, but MySQL is supported too. Now it can be used as CSV or TSV viewer. 2020-01-10

   tags: command-line, database, database/mysql, database/postgresql, pager, programming/csv, table

   [ permalink ]

   • https://okbob.blogspot.com/2017/07/i-hope-so-every-who-uses-psql-uses-less.html
5. MySQL High Availability at GitHub 2019-12-31

   tags: consul, database, database/mysql, distributed-system/cluster, high-availability, source-code-management/github

   [ permalink ]

   • https://github.blog/2017-10-13-mitigating-replication-lag-and-reducing-read-load-with-freno/
   • https://github.com/github/freno
   • https://github.blog/2016-12-08-orchestrator-github/
   • https://github.com/github/orchestrator
   • https://raft.github.io/
6. Building and Testing a REST API in GoLang using Gorilla Mux and MySQL 2019-04-01

   tags: database, database/mysql, database/postgresql, network/http, programming/go, programming/sql, programming/testing

   [ permalink ]

   • https://github.com/kaihendry/GoApiTutorial
   • https://semaphoreci.com/community/tutorials/building-and-testing-a-rest-api-in-go-with-gorilla-mux-and-postgresql
   • https://www.youtube.com/watch?v=ynUUGWvqA4c
7. Audit a MySQL or MariaDB database 2019-02-19

   tags: database, database/mariadb, database/mysql, observability, performance, security/audit

   [ permalink ]

   • https://vincent.composieux.fr/article/auditer-une-base-de-donnees-mysql-ou-mariadb
8. Monitoring OS metrics for Amazon RDS with Grafana - Percona Database Performance Blog 2019-02-14

   tags: cloud/aws, database, database/mysql, observability, observability/grafana

   [ permalink ]

   • https://grafana.com/dashboards/707
   • https://grafana.com/dashboards/702
9. How to collect RDS MySQL metrics | Datadog 2019-02-05

   tags: cloud/aws, database, database/mysql, database/postgresql, observability

   [ permalink ]
10. TiDB - a distributed HTAP database compatible with the MySQL protocol 2019-01-15

    tags: database, database/mysql, distributed, programming/go

    [ permalink ]
11. Vitess | A database clustering system for horizontal scaling of MySQL 2018-12-12

    tags: database, database/mysql, distributed-system/cluster, google, programming/sql, shard

    [ permalink ]

    • https://github.com/vitessio/vitess
    • https://www.reddit.com/r/programming/comments/qakq4/google_releases_vitess_used_in_the_core_of/
12. DBCLI - Commandline Database Clients with Autocompletion and Syntax Highlighting 2018-12-05

    tags: command-line, database, database/mariadb, database/mysql, database/postgresql, database/sqlite, programming/python, terminal

    [ permalink ]

    • https://github.com/dbcli/litecli
    • https://www.mycli.net/
    • https://www.pgcli.com/
    • https://web-techno.net/mysql-command-line-tool-mycli/
13. mysql - What column type/length should I use for storing a Bcrypt hashed password in a Database? - Stack Overflow 2018-10-21

    tags: cryptography/hash, database, database/mariadb, database/mysql, programming/sql, security/password

    [ permalink ]

    • https://stackoverflow.com/questions/51008351/bcrypt-hashedsecret-too-short-to-be-a-bcrypted-password
    • https://stackoverflow.com/questions/247304/what-data-type-to-use-for-hashed-password-field-and-what-length
14. python-sqlparse - a non-validating SQL parser module for Python 2018-10-21

    tags: database, database/mariadb, database/mysql, database/postgresql, database/sqlite, parser, programming/python, programming/sql

    [ permalink ]

    • https://github.com/andialbrecht/sqlparse
15. MySQL configuration: when to use hyphen and when to use underscore - Stack Overflow 2018-08-29

    tags: configuration, database, database/mariadb, database/mysql

    [ permalink ]
16. Migrating a 130TB Cluster from Elasticsearch 2 to 5 in 20 Hours with 0 Downtime and a Rollback… 2018-01-31

    tags: data, database, distributed-system/cluster, index, observability/elastic, observability/elastic/elasticsearch, search

    [ permalink ]

    • https://thoughts.t37.net/how-we-reindexed-36-billions-documents-in-5-days-within-the-same-elasticsearch-cluster-cd9c054d1db8
    • https://thoughts.t37.net/how-we-upgraded-a-22tb-mysql-cluster-from-5-6-to-5-7-in-9-months-cc41b391895d
    • https://www.elastic.co/blog/hot-warm-architecture-in-elasticsearch-5-x
    • https://www.graylog.org/post/back-to-basics-using-a-hot-warm-elasticsearch-cluster
    • https://github.com/mraad/es-hot-warm
17. Django, Docker and MySQL 2017-11-29

    tags: database, database/migration, database/mysql, framework/django, linux/container/docker, programming/python, programming/sql

    [ permalink ]

    Django ORM:

    • https://docs.djangoproject.com/en/1.11/ref/databases/#mysql-notes
    • https://stackoverflow.com/questions/34777755/how-to-config-django-using-pymysql-as-driver
    • https://stackoverflow.com/questions/19189813/setting-django-up-to-use-mysql

    MySQL / MariaDB / Percona connectors:

    • https://stackoverflow.com/questions/4960048/python-3-and-mysql
    • https://github.com/PyMySQL/PyMySQL
    • https://pypi.python.org/pypi/mysql-connector-python

    Docker images:

    • https://store.docker.com/images/mariadb
    • https://store.docker.com/images/mysql
    • https://store.docker.com/images/percona

    Compose and Django ORM database migrations:

    • https://docs.docker.com/compose/django/
    • https://stackoverflow.com/questions/33992867/how-do-you-perform-django-database-migrations-when-using-docker-compose
    • https://www.stavros.io/posts/how-deploy-django-docker/
    • https://docs.docker.com/compose/startup-order/
18. Change MySQL default character set to UTF-8 in my.cnf? - Stack Overflow 2017-09-05

    tags: database, database/mysql, text/unicode

    [ permalink ]
19. Ansible setup mysql root password - Stack Overflow 2017-06-26

    tags: configuration-management/ansible, database/mysql, security/password

    [ permalink ]

    • https://docs.ansible.com/ansible/mysql_user_module.html
    • https://docs.ansible.com/ansible/ini_file_module.html