4259 links
  • Arnaud's links
  • Home
  • RSS Feed
  • Tag cloud
  • Login
search: tag:mysql — newest first
  • PyMySQL · PyPI
    September 25, 2018 - permalink - https://pypi.org/project/PyMySQL/
    mysql python
  • zzmysqldump/README.md at master · TurboLabIt/zzmysqldump · GitHub
    May 28, 2017 - permalink - https://github.com/TurboLabIt/zzmysqldump/blob/master/README.md
    mysql mysqldump
  • mycli/README.md at master · dbcli/mycli · GitHub
    May 7, 2017 - permalink - https://github.com/dbcli/mycli/blob/master/README.md
    client mysql
  • MySQL :: MySQL 5.7 Reference Manual :: 5.6.6 mysql_config_editor — MySQL Configuration Utility

    Exactement ce que je cherchais

    You can use the mysql_config_editor utility to store authentication credentials in an encrypted login path file named .mylogin.cnf.

    To create a new set of credentials run:

    mysql_config_editor set --host=db.host.org --user=dbuser --password

    and enter your password when prompted.

    This will store your authentication credentials in the default client login path.

    You can store multiple authentication credentials by specifying a different --login-path option:

    mysql_config_editor set --login-path=db2 --host=db2.host.org --user=dbuser --password

    By default, the mysql client reads the [client] and [mysql] groups from other option files, so it reads them from the login path file as well. With a --login-path option, client programs additionally read the named login path from the login path file. The option groups read from other option files remain the same. Consider this command:

    mysql --login-path=db2

    The mysql client reads [client] and [mysql] from other option files, and [client], [mysql], and [mypath] from the login path file.

    To print out all the information stored in the configuration file run:

    mysql_config_editor print --all=true

    More information about the utility can be found at "mysql_config_editor — MySQL Configuration Utility".

    May 3, 2017 - permalink - https://dev.mysql.com/doc/refman/5.7/en/mysql-config-editor.html
    auth mysql
  • Note: mysql

    do not use utf8, its not "real utf8"

    CREATE DATABASE foo DEFAULT CHARACTER SET utf8 DEFAULT COLLATE utf8_general_ci;

    use this :

    https://mathiasbynens.be/notes/mysql-utf8mb4#utf8-to-utf8mb4

    CREATE DATABASE foo DEFAULT CHARACTER SET utf8mb4 DEFAULT COLLATE utf8mb4_unicode_ci;

    CREATE USER 'foo'@'%' IDENTIFIED BY "password";

    GRANT ALL ON foo.* TO "foo"@"%";

    convert :

    For each database:

    ALTER DATABASE database_name CHARACTER SET = utf8mb4 COLLATE = utf8mb4_unicode_ci;

    For each table:

    ALTER TABLE table_name CONVERT TO CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

    For each column:

    ALTER TABLE table_name CHANGE column_name column_name VARCHAR(191) CHARACTER SET utf8mb4 COLLATE utf8mb4_unicode_ci;

    (Don’t blindly copy-paste this! The exact statement depends on the column type, maximum length, and other properties. The above line is just an example for a VARCHAR column.)

    May 3, 2017 - permalink - https://links.infomee.fr/shaare/kmGPew
    memo mysql nomarkdown
  • wildcard - Grant permissions to a set of databases matching a pattern in MysQL 5.0 - Stack Overflow

    Use ` instead of ' in the database name, and escape the _

    GRANT ALL PRIVILEGES ON xian\_%.* TO xian@'192.168.1.%';

    December 14, 2016 - permalink - http://stackoverflow.com/questions/2469119/grant-permissions-to-a-set-of-databases-matching-a-pattern-in-mysql-5-0
    mysql
  • Note: mysqldump

    Options interessantes : --quick --single-transaction

    October 10, 2016 - permalink - https://links.infomee.fr/shaare/AwRWHg
    mysql rtfm
  • Aurora on Amazon RDS - Amazon Relational Database Service

    Pour un cluster Aurora donné, 3 endpoints :
    - cluster endpoint : pointe toujours sur le master
    - reader endpoint : pointe toujours sur un slave
    - instance endpoint : permet de pointer spécifiquement une instance donnée. Ne garantit pas que cette instance restera un slave ou un master.

    You can determine which DB instance in an Aurora DB cluster that a connection is connected to by checking the innodb_read_only global variable, as shown in the following example.
    SHOW GLOBAL VARIABLES LIKE 'innodb_read_only';
    The innodb_read_only variable will be set to ON if you are connected to an Aurora Replica and OFF if you are connected to the primary instance.

    October 3, 2016 - permalink - http://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/CHAP_Aurora.html
    aurora aws mysql
  • gh-ost: GitHub’s online schema migration tool for MySQL - GitHub Engineering
    August 2, 2016 - permalink - http://githubengineering.com/gh-ost-github-s-online-migration-tool-for-mysql/
    db github migration mysql
  • MySQL Back-up: Take a mysqldump with each database in its own SQL File

    mysql -N -e 'show databases' | while read dbname; do mysqldump --complete-insert --routines --triggers --single-transaction "$dbname" > "$dbname".sql; done

    todo : regarder les options

    June 19, 2016 - permalink - https://ma.ttias.be/mysql-back-up-take-a-mysqldump-with-each-database-in-its-own-sql-file/
    backup dump mysql
  • MySQL :: MySQL 5.7 Reference Manual :: 13.4.1.3 SET sql_log_bin Syntax

    To disable bin log for the current session

    January 18, 2016 - permalink - http://dev.mysql.com/doc/refman/5.7/en/set-sql-log-bin.html
    bin log mysql
  • 10 MySQL settings to tune after installation
    December 19, 2015 - permalink - https://www.percona.com/blog/2014/01/28/10-mysql-settings-to-tune-after-installation/
    mysql percona production
  • MySQL's INNODB_METRICS: How much is the overhead?
    December 16, 2015 - permalink - https://www.percona.com/blog/2014/11/18/mysqls-innodb_metrics-table-how-much-is-the-overhead/
    metric mysql
  • Get started with InnoDB Metrics Table (Transactions on InnoDB)
    December 16, 2015 - permalink - https://blogs.oracle.com/mysqlinnodb/entry/get_started_with_innodb_metrics
    metric mysql
  • MySQL :: MySQL 5.6 Reference Manual :: 21.29.19 The INFORMATION_SCHEMA INNODB_METRICS Table
    December 16, 2015 - permalink - http://dev.mysql.com/doc/refman/5.6/en/innodb-metrics-table.html
    metric mysql
  • Slow query graphs using Performance Schema and Graphite

    via skunnyk

    October 21, 2015 - permalink - https://www.percona.com/blog/2015/10/20/slow-query-graphs-using-performance-schema-and-graphite/
    graphite mysql percona query slow sql
  • MySQL Cluster with Galera - Nouvelles idées

    via arnaudb

    September 26, 2015 - permalink - http://nouvellesidees.info/blog/mysql-cluster-with-galera/
    cluster galera mysql
  • Containing your logical backups: mydumper in docker
    September 22, 2015 - permalink - https://www.percona.com/blog/2015/09/21/containing-logical-backups-mydumper-docker/
    backup docker mysql
  • Introducing mysqlpump | MySQL Server Blog
    September 8, 2015 - permalink - http://mysqlserverteam.com/introducing-mysqlpump/
    dump mysql
  • My SQL Dump - Take the long view on the MySQL PERFORMANCE_SCHEMA with ps_history and sys_history
    February 12, 2015 - permalink - http://swanhart.livejournal.com/137743.html
    information_schema mysql
  • MySQL Query Performance Statistics In The Performance Schema - VividCortex
    January 23, 2015 - permalink - https://vividcortex.com/blog/2014/11/03/mysql-query-performance-statistics-in-the-performance-schema/
    mysql stat
  • Terrible choices: MySQL | ionel's codelog

    Dans l'idéal il ne faudrait pas utiliser les paramètres par défauts et lire 100 de la doc pour faire sa propre conf... dans l'idéal.

    January 18, 2015 - permalink - http://blog.ionelmc.ro/2014/12/28/terrible-choices-mysql/
    mysql
  • Non-blocking INSERT with mysqlnd | Ulf WendelUlf Wendel
    January 1, 2015 - permalink - http://blog.ulf-wendel.de/2012/non-blocking-insert-with-mysqlnd/
    mysql
  • Managing shards of MySQL databases with MySQL Fabric
    January 1, 2015 - permalink - http://www.percona.com/blog/2014/07/11/managing-shards-mysql-databases-mysql-fabric-2/
    mysql
  • PHP and MySQL communication, mysqlnd
    January 1, 2015 - permalink - http://jpauli.github.io/2014/07/21/php-and-mysql-communication-mysqlnd.html
    mysql
  • Les index MySQL : types, placements, efficacité « dbnewz
    January 1, 2015 - permalink - http://www.dbnewz.com/2008/06/27/les-index-mysql-types-placements-efficacite/
    index mysql
  • MySQL 5.7 multi-source replication
    January 1, 2015 - permalink - http://www.percona.com/blog/2013/10/02/mysql-5-7-multi-source-replication/
    mysql
  • Connexion sécurisé base de donnée sans mot de passe depuis compte linux

    via sebsauvage

    October 1, 2014 - permalink - http://www.mon-code.net/article/72/utiliser-le-compte-linux-pour-se-connecter-de-facon-securise-a-mariadb-et-mysql-sans-mot-de-passe
    auth mariadb mysql
  • Mysql Indexing Tips - CodeSamplez

    via mickael

    August 11, 2014 - permalink - http://codesamplez.com/database/mysql-indexing-tips
    index mysql
  • Percona XtraDB Cluster 5.6, HAProxy and Debian Wheezy 7.0
    July 21, 2014 - permalink - http://www.mikemead.me/blog/percona-xtradb-cluster-debian-wheezy
    cluster haproxy mysql
  • User Statistics — Percona Server 5.5 Documentation

    Peut servir pour auditer les comptes utilisés

    July 10, 2014 - permalink - http://www.percona.com/doc/percona-server/5.5/diagnostics/user_stats.html?id=percona-server:features:userstatv2
    audit mysql stat user
  • MySQL :: MySQL 5.6 Reference Manual :: 17 Replication

    Chapter 17 de la doc MySQL : toread

    July 9, 2014 - permalink - http://dev.mysql.com/doc/refman/5.6/en/replication.html
    mysql replication
  • Top 20+ MySQL Best Practices - Tuts+ Code Tutorial
    May 21, 2014 - permalink - http://code.tutsplus.com/tutorials/top-20-mysql-best-practices--net-7855
    mysql
  • GTIDs in MySQL 5.6: New replication protocol, ways to break replication

    nouveau protocole de replication mysql

    via Skunnyk

    May 12, 2014 - permalink - http://www.mysqlperformanceblog.com/2014/05/09/gtids-in-mysql-5-6-new-replication-protocol-new-ways-to-break-replication/
    gtid mysql sys
  • Restoring The MySQL Root User | Code Enigma

    peut servir ^^

    via arnaudb

    April 28, 2014 - permalink - http://www.codeenigma.com/en/blog/restoring-mysql-root-user
    mysql root
  • Keynotes Recordings | Percona Live MySQL Conference & Expo 2014
    April 7, 2014 - permalink - https://www.percona.com/live/mysql-conference-2014/keynotes-recordings
    mysql percona video
  • DBA 101: Sometimes forgotten functionality in the MySQL client

    Deux trois fonctions utiles/méconnues côté client

    via Skunnyk

    March 24, 2014 - permalink - http://www.mysqlperformanceblog.com/2014/02/27/dba-101-sometimes-forgotten-functionality-mysql-client/
    mysql
  • PHP :: Bug #52434 :: mysqlnd: host cannot be "localhost" when connecting to tcp port

    Point de vue différents :)

    Ici, lorsqu'on utilise "localhost", la connexion va se faire par une socket et lorsqu'on utilise "127.0.0.1", la connexion se fera par tcp. On pourrait se dire que le comportement est anormal, mais en fait, non :

    "The patch won't be added as then "localhost" has two meanings - one time meaning "use the unixdomain socket in the default location" and one time actually "resolve localhost and use TCP" as it is taught in many places that "localhost" in MySQL has the first meaning we keep it there."

    La socket est déterminée ici dans le php.ini :
    ; Default socket name for local MySQL connects. If empty, uses the built-in
    ; MySQL defaults.
    mysql.default_socket =

    January 3, 2014 - permalink - https://bugs.php.net/bug.php?id=52434
    bug mysql php socket
  • Comprendre les jointures avec MySQL | Epershand

    Très bon article sur les jointures

    December 10, 2013 - permalink - http://www.epershand.net/developpement/mysql-bdd/comprendre-jointures-inner-left-right-join-mysql
    inner join left mysql outer right
  • MySQL Database Dump Splitter

    Je me garde ça au chaud, ça peut servir

    December 7, 2013 - permalink - https://github.com/sadreck/mysqldbsplit
    mysql script
  • MySQL :: MySQL Workbench 6.0
    December 1, 2013 - permalink - http://www.mysql.fr/products/workbench/
    mysql tools
  • Warning: Skipping the data of table mysql.event. | Linux BrigadeWarning: Skipping the data of table mysql.event. - Linux Brigade

    Todo sur mon dump pour ne plus avoir le warning

    November 30, 2013 - permalink - http://www.linuxbrigade.com/warning-skipping-data-table-mysql-event/#more-135
    dump mysql
  • Overview - mysql-master-ha - MHA for MySQL: Master High Availability Manager and tools for MySQL - Google Project Hosting

    MHA performs automating master failover and slave promotion with minimal downtime, usually within 10-30 seconds. MHA prevents replication consistency problems and saves on expenses of having to acquire additional servers. All this with zero performance degradation, no complexity (easy-to-install) and requiring no change to existing deployments.

    Problème des caches ARP ? Les clients ont l'adresse MAC du serveur qui est tombé, quand le serveur ne répond pas en face, est-ce que le client va refaire une arp request ? sinon peut-on forcer les clients à le faire ? sinon peut-on utiliser un ARP gratuitous ? Comment de manière sécurisée ?

    EDIT : une solution avec les ARP gratuitous : https://devcentral.f5.com/articles/the-limits-of-cloud-gratuitous-arp-and-failover#.UnoP_kO4DRY

    November 6, 2013 - permalink - http://code.google.com/p/mysql-master-ha/wiki/Overview
    ha mysql nv
  • RESET SLAVE vs. RESET SLAVE ALL: Disconnecting a replication slave is easier with MySQL 5.5+
    November 4, 2013 - permalink - http://www.mysqlperformanceblog.com/2013/04/17/reset-slave-vs-reset-slave-all-disconnecting-a-replication-slave-is-easier-with-mysql-5-5/
    mysql nv
  • MySQL :: MySQL 5.6 Reference Manual :: 14.2.13.2 InnoDB Performance and Scalability Enhancements
    November 4, 2013 - permalink - http://dev.mysql.com/doc/refman/5.6/en/innodb-performance.html#innodb-undo-tablespace
    mysql nv
  • Why is the ibdata1 file continuously growing in MySQL?
    November 4, 2013 - permalink - http://www.mysqlperformanceblog.com/2013/08/20/why-is-the-ibdata1-file-continuously-growing-in-mysql/
    mysql nv
  • Innotop - a real-time, advanced investigation tool for MySQL
    October 29, 2013 - permalink - http://www.mysqlperformanceblog.com/2013/10/14/innotop-real-time-advanced-investigation-tool-mysql/
    debug mysql perf tool
  • How to setup a slave for replication in 6 simple steps with Percona XtraBackup — Percona XtraBackup Documentation

    Comment mettre en place un slave qui réplique avec percona

    October 24, 2013 - permalink - http://www.percona.com/doc/percona-xtrabackup/2.1/howtos/setting_up_replication.html
    cluster master mysql percona replication slave
  • Le sharding de base de données expliqué aux enfants

    Qu'est ce que le sharding ?
    Peut servir à scale

    October 21, 2013 - permalink - http://petitcodeur.fr/architecture/sharding-base-de-donnees.html
    db mysql scale
  • Backup (mysql dump) all your MySQL databases in separate files | Running with Rails - Dev Blog not only for Rails fanatics!

    Script pour backup toutes ses bases dans des fichiers séparés

    October 9, 2013 - permalink - http://dev.mensfeld.pl/2013/04/backup-mysql-dump-all-your-mysql-databases-in-separate-files/
    mysql script
▼ Load 50 more