-
-
Save upamune/39a99a52b398e83299ca99a4fecb2bf6 to your computer and use it in GitHub Desktop.
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
| $ kubectl get pod | |
| No resources found. | |
| $ kubectl apply -f mysql-master.yaml | |
| service "mysql-master" created | |
| statefulset "mysql-master" created | |
| $ kubectl get pod | |
| NAME READY STATUS RESTARTS AGE | |
| mysql-master-0 1/1 Running 0 38s | |
| $ kubectl apply -f mysql-master.yaml | |
| service "mysql-master" unchanged | |
| statefulset "mysql-master" configured | |
| $ kubectl apply -f mysql-slave.yaml | |
| service "mysql-slave" created | |
| statefulset "mysql-slave" created | |
| $ stern mysql | |
| + mysql-master-0 › mysql | |
| + mysql-slave-0 › mysql | |
| + mysql-slave-1 › mysql | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.891343Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.893095Z 0 [Note] mysqld (mysqld 5.7.21-log) starting as process 1 ... | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.899347Z 0 [Note] InnoDB: PUNCH HOLE support available | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.899542Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.899618Z 0 [Note] InnoDB: Uses event mutexes | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.899657Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.899726Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.899782Z 0 [Note] InnoDB: Using Linux native AIO | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.900134Z 0 [Note] InnoDB: Number of pools: 1 | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.900342Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.902439Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.910765Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.913218Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.938896Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.961486Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
| mysql-slave-1 mysql 2018-07-14T15:46:41.961779Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
| mysql-slave-1 mysql 2018-07-14T15:46:42.162434Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
| mysql-slave-0 mysql-slave-1 mysql mysql2018-07-14T15:46:20.467407Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). | |
| 2018-07-14T15:46:42.164429Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
| mysql-slave-0 mysqlmysql-slave-1 2018-07-14T15:46:20.473983Z 0 [Note] mysqld (mysqld 5.7.21-log) starting as process 1 ... | |
| mysqlmysql-slave-0 2018-07-14T15:46:42.164595Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
| mysqlmysql-slave-1 2018-07-14T15:46:20.480233Z 0 [Note] InnoDB: PUNCH HOLE support available | |
| mysql 2018-07-14T15:46:42.165194Z 0 [Note] InnoDB: Waiting for purge to start | |
| mysql-slave-0 mysql-slave-1 mysqlmysql 2018-07-14T15:46:20.480413Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| 2018-07-14T15:46:42.215637Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 12319053 | |
| mysql-slave-0 mysql-slave-1 mysql mysql2018-07-14T15:46:20.480450Z 0 [Note] InnoDB: Uses event mutexes | |
| 2018-07-14T15:46:42.216379Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
| mysql-slave-0 mysql-slave-1 mysql mysql2018-07-14T15:46:20.480504Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
| 2018-07-14T15:46:42.216890Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
| mysql-slave-0 mysqlmysql-slave-1 2018-07-14T15:46:20.480535Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |
| mysql mysql-slave-02018-07-14T15:46:42.260185Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. | |
| mysqlmysql-slave-1 2018-07-14T15:46:20.480587Z 0 [Note] InnoDB: Using Linux native AIO | |
| mysqlmysql-slave-0 2018-07-14T15:46:42.262807Z 0 [Warning] CA certificate ca.pem is self signed. | |
| mysql 2018-07-14T15:46:20.480923Z 0 [Note] InnoDB: Number of pools: 1 | |
| mysql-slave-1 mysql-slave-0mysql 2018-07-14T15:46:42.265561Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 | |
| mysql 2018-07-14T15:46:20.481111Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
| mysql-slave-1 mysql-slave-0 mysqlmysql 2018-07-14T15:46:42.265945Z 0 [Note] IPv6 is available. | |
| 2018-07-14T15:46:20.483002Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
| mysql-slave-0mysql-slave-1 mysql mysql2018-07-14T15:46:20.494219Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
| 2018-07-14T15:46:42.266026Z 0 [Note] - '::' resolves to '::'; | |
| mysql-slave-0 mysql-slave-1 mysqlmysql 2018-07-14T15:46:20.499780Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
| 2018-07-14T15:46:42.266116Z 0 [Note] Server socket created on IP: '::'. | |
| mysql-slave-0 mysql-slave-1 mysql 2018-07-14T15:46:20.530115Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
| mysql mysql-slave-02018-07-14T15:46:42.266984Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180714 15:46:42 | |
| mysql-slave-1mysql 2018-07-14T15:46:20.555501Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
| mysql 2018-07-14T15:46:42.276037Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql-slave-1 mysqlmysql 2018-07-14T15:46:20.555787Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
| 2018-07-14T15:46:42.276299Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql-slave-1 mysql mysql 2018-07-14T15:46:20.744406Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
| 2018-07-14T15:46:42.276372Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql-slave-1 mysqlmysql 2018-07-14T15:46:20.745339Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
| 2018-07-14T15:46:42.277063Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0mysql-slave-1 mysql mysql2018-07-14T15:46:20.745352Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
| 2018-07-14T15:46:42.277157Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql-slave-1 mysqlmysql 2018-07-14T15:46:20.745612Z 0 [Note] InnoDB: Waiting for purge to start | |
| 2018-07-14T15:46:42.277721Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-1mysql-slave-0 mysqlmysql 2018-07-14T15:46:42.298127Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| 2018-07-14T15:46:20.795823Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 12319203 | |
| mysql-slave-1mysql-slave-0 mysqlmysql 2018-07-14T15:46:20.796225Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
| 2018-07-14T15:46:42.298340Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql-slave-1 mysql 2018-07-14T15:46:20.796493Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
| mysql mysql-slave-02018-07-14T15:46:42.319503Z 2 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. | |
| mysql-slave-1mysql 2018-07-14T15:46:20.828822Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. | |
| mysql 2018-07-14T15:46:42.320808Z 1 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 | |
| mysql-slave-0 mysql-slave-1 mysql mysql2018-07-14T15:46:20.831112Z 0 [Warning] CA certificate ca.pem is self signed. | |
| 2018-07-14T15:46:42.321078Z 1 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000003' at position 3133, relay log './mysqld-relay-bin.000003' position: 320 | |
| mysql-slave-0 mysql-slave-1 mysqlmysql 2018-07-14T15:46:42.323011Z 1 [ERROR] Slave SQL for channel '': Error 'Unknown table 'tododb.todo'' on query. Default database: 'tododb'. Query: 'DROP TABLE `todo` /* generated by server */', Error_code: 1051 | |
| 2018-07-14T15:46:20.835816Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 | |
| mysql-slave-1mysql-slave-0 mysqlmysql 2018-07-14T15:46:42.323208Z 1 [Warning] Slave: Unknown table 'tododb.todo' Error_code: 1051 | |
| 2018-07-14T15:46:20.836104Z 0 [Note] IPv6 is available. | |
| mysql-slave-1mysql-slave-0 mysqlmysql 2018-07-14T15:46:42.323447Z 1 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000003' position 3133 | |
| 2018-07-14T15:46:20.836229Z 0 [Note] - '::' resolves to '::'; | |
| mysql-slave-1mysql-slave-0 mysql mysql 2018-07-14T15:46:42.324232Z 2 [ERROR] Slave I/O for channel '': error connecting to master 'repl@mysql-master:3306' - retry-time: 60 retries: 1, Error_code: 1045 | |
| 2018-07-14T15:46:20.836495Z 0 [Note] Server socket created on IP: '::'. | |
| mysql-slave-1 mysql 2018-07-14T15:46:42.387811Z 0 [Note] Event Scheduler: Loaded 0 events | |
| mysql-slave-1 mysql 2018-07-14T15:46:42.388471Z 0 [Note] mysqld: ready for connections. | |
| mysql-slave-1 mysql Version: '5.7.21-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) | |
| mysql-slave-1 mysql 2018-07-14T15:47:42.325645Z 2 [ERROR] Slave I/O for channel '': error connecting to master 'repl@mysql-master:3306' - retry-time: 60 retries: 2, Error_code: 1045 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.844101Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180714 15:46:20 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.853366Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.853684Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.853754Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.854478Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.854555Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.855260Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.878519Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.878547Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.898892Z 2 [Warning] Storing MySQL user name or password information in the master info repository is not secure and is therefore not recommended. Please consider using the USER and PASSWORD connection options for START SLAVE; see the 'START SLAVE Syntax' in the MySQL Manual for more information. | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.899571Z 1 [Warning] Slave SQL for channel '': If a crash happens this configuration does not guarantee that the relay log info will be consistent, Error_code: 0 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.899638Z 1 [Note] Slave SQL thread for channel '' initialized, starting replication in log 'mysql-bin.000003' at position 3133, relay log './mysqld-relay-bin.000003' position: 769 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.900659Z 1 [ERROR] Slave SQL for channel '': Error 'Unknown table 'tododb.todo'' on query. Default database: 'tododb'. Query: 'DROP TABLE `todo` /* generated by server */', Error_code: 1051 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.900699Z 1 [Warning] Slave: Unknown table 'tododb.todo' Error_code: 1051 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.900702Z 1 [ERROR] Error running query, slave SQL thread aborted. Fix the problem, and restart the slave SQL thread with "SLAVE START". We stopped at log 'mysql-bin.000003' position 3133 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.904212Z 2 [ERROR] Slave I/O for channel '': error connecting to master 'repl@mysql-master:3306' - retry-time: 60 retries: 1, Error_code: 1045 | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.976528Z 0 [Note] Event Scheduler: Loaded 0 events | |
| mysql-slave-0 mysql 2018-07-14T15:46:20.976950Z 0 [Note] mysqld: ready for connections. | |
| mysql-slave-0 mysql Version: '5.7.21-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) | |
| mysql-slave-0 mysql 2018-07-14T15:47:20.907986Z 2 [ERROR] Slave I/O for channel '': error connecting to master 'repl@mysql-master:3306' - retry-time: 60 retries: 2, Error_code: 1045 | |
| mysql-master-0 mysql 2018-07-14T15:45:17.427631Z 0 [Warning] TIMESTAMP with implicit DEFAULT value is deprecated. Please use --explicit_defaults_for_timestamp server option (see documentation for more details). | |
| mysql-master-0 mysql 2018-07-14T15:45:17.431853Z 0 [Note] mysqld (mysqld 5.7.21-log) starting as process 1 ... | |
| mysql-master-0 mysql 2018-07-14T15:45:17.440031Z 0 [Note] InnoDB: PUNCH HOLE support available | |
| mysql-master-0 mysql 2018-07-14T15:45:17.440213Z 0 [Note] InnoDB: Mutexes and rw_locks use GCC atomic builtins | |
| mysql-master-0 mysql 2018-07-14T15:45:17.440283Z 0 [Note] InnoDB: Uses event mutexes | |
| mysql-master-0 mysql 2018-07-14T15:45:17.440371Z 0 [Note] InnoDB: GCC builtin __atomic_thread_fence() is used for memory barrier | |
| mysql-master-0 mysql 2018-07-14T15:45:17.440409Z 0 [Note] InnoDB: Compressed tables use zlib 1.2.3 | |
| mysql-master-0 mysql 2018-07-14T15:45:17.440466Z 0 [Note] InnoDB: Using Linux native AIO | |
| mysql-master-0 mysql 2018-07-14T15:45:17.440789Z 0 [Note] InnoDB: Number of pools: 1 | |
| mysql-master-0 mysql 2018-07-14T15:45:17.441000Z 0 [Note] InnoDB: Using CPU crc32 instructions | |
| mysql-master-0 mysql 2018-07-14T15:45:17.443551Z 0 [Note] InnoDB: Initializing buffer pool, total size = 128M, instances = 1, chunk size = 128M | |
| mysql-master-0 mysql 2018-07-14T15:45:17.455714Z 0 [Note] InnoDB: Completed initialization of buffer pool | |
| mysql-master-0 mysql 2018-07-14T15:45:17.460993Z 0 [Note] InnoDB: If the mysqld execution user is authorized, page cleaner thread priority can be changed. See the man page of setpriority(). | |
| mysql-master-0 mysql 2018-07-14T15:45:17.490466Z 0 [Note] InnoDB: Highest supported file format is Barracuda. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.516026Z 0 [Note] InnoDB: Creating shared tablespace for temporary tables | |
| mysql-master-0 mysql 2018-07-14T15:45:17.516308Z 0 [Note] InnoDB: Setting file './ibtmp1' size to 12 MB. Physically writing the file full; Please wait ... | |
| mysql-master-0 mysql 2018-07-14T15:45:17.714629Z 0 [Note] InnoDB: File './ibtmp1' size is now 12 MB. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.716210Z 0 [Note] InnoDB: 96 redo rollback segment(s) found. 96 redo rollback segment(s) are active. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.716303Z 0 [Note] InnoDB: 32 non-redo rollback segment(s) are active. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.716789Z 0 [Note] InnoDB: Waiting for purge to start | |
| mysql-master-0 mysql 2018-07-14T15:45:17.767098Z 0 [Note] InnoDB: 5.7.21 started; log sequence number 12347454 | |
| mysql-master-0 mysql 2018-07-14T15:45:17.767740Z 0 [Note] Plugin 'FEDERATED' is disabled. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.768242Z 0 [Note] InnoDB: Loading buffer pool(s) from /var/lib/mysql/ib_buffer_pool | |
| mysql-master-0 mysql 2018-07-14T15:45:17.798330Z 0 [Note] Found ca.pem, server-cert.pem and server-key.pem in data directory. Trying to enable SSL support using them. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.802422Z 0 [Warning] CA certificate ca.pem is self signed. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.806505Z 0 [Note] Server hostname (bind-address): '*'; port: 3306 | |
| mysql-master-0 mysql 2018-07-14T15:45:17.806873Z 0 [Note] IPv6 is available. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.807149Z 0 [Note] - '::' resolves to '::'; | |
| mysql-master-0 mysql 2018-07-14T15:45:17.807363Z 0 [Note] Server socket created on IP: '::'. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.816103Z 0 [Note] InnoDB: Buffer pool(s) load completed at 180714 15:45:17 | |
| mysql-master-0 mysql 2018-07-14T15:45:17.823515Z 0 [Warning] 'user' entry 'root@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.823776Z 0 [Warning] 'user' entry 'mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.823853Z 0 [Warning] 'user' entry 'mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.824667Z 0 [Warning] 'db' entry 'performance_schema mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.824757Z 0 [Warning] 'db' entry 'sys mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.825383Z 0 [Warning] 'proxies_priv' entry '@ root@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.841351Z 0 [Warning] 'tables_priv' entry 'user mysql.session@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.841624Z 0 [Warning] 'tables_priv' entry 'sys_config mysql.sys@localhost' ignored in --skip-name-resolve mode. | |
| mysql-master-0 mysql 2018-07-14T15:45:17.913761Z 0 [Note] Event Scheduler: Loaded 0 events | |
| mysql-master-0 mysql 2018-07-14T15:45:17.914151Z 0 [Note] mysqld: ready for connections. | |
| mysql-master-0 mysql Version: '5.7.21-log' socket: '/var/run/mysqld/mysqld.sock' port: 3306 MySQL Community Server (GPL) | |
| mysql-master-0 mysql 2018-07-14T15:46:20.903744Z 2 [Note] Access denied for user 'repl'@'10.52.0.12' (using password: YES) | |
| mysql-master-0 mysql 2018-07-14T15:46:42.323833Z 3 [Note] Access denied for user 'repl'@'10.52.2.11' (using password: YES) | |
| mysql-master-0 mysql 2018-07-14T15:47:20.907790Z 4 [Note] Access denied for user 'repl'@'10.52.0.12' (using password: YES) | |
| mysql-master-0 mysql 2018-07-14T15:47:42.325524Z 5 [Note] Access denied for user 'repl'@'10.52.2.11' (using password: YES) | |
| $ kubectl exec -it mysql-master-0 bash | |
| root@mysql-master-0:/# mysql -u root -pgihyo -e "SELECT user, host FROM mysql.user;" | |
| mysql: [Warning] Using a password on the command line interface can be insecure. | |
| +---------------+-----------+ | |
| | user | host | | |
| +---------------+-----------+ | |
| | gihyo | % | | |
| | root | % | | |
| | repl | 10.52.0.9 | | |
| | repl | 10.52.2.7 | | |
| | mysql.session | localhost | | |
| | mysql.sys | localhost | | |
| | root | localhost | | |
| +---------------+-----------+ | |
| $ kubectl describe pod mysql-slave-0 | grep IP | |
| IP: 10.52.0.12 | |
| $ kubectl describe pod mysql-slave-1 | grep IP | |
| IP: 10.52.2.11 | |
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment