Uploaded image for project: 'Percona Server'
  1. Percona Server
  2. PS-5477

MyRocks - Cannot configure myrocks in percona docker instance

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: On Hold
    • Priority: Medium
    • Resolution: Unresolved
    • Affects Version/s: 5.7.25-28
    • Fix Version/s: None
    • Component/s: MyRocks
    • Labels:

      Description

      I'm currently exploring myrocks in docker and have discovered that I'm not able to pass in any configuration that's specific to myrocks. Please see below for terminal output that shows rocksdb_db_write_buffer_size not being accepted in the volume mapped my.cnf. One all myrocks variables were commented out the docker instance started with no issues.

      [vagrant@control myrocks57]$ cat ./mysql3.cnf
      [mysqld]
      server-id = 3
      log-bin
      binlog-format=mixed
      log-slave-updates
      skip-name-resolve
      #log_error = /var/log/mysqld.log#rocksdb_default_cf_options = block_based_table_factory={filter_policy=bloomfilter:10:false};compression_per_level=kNoCompression:kNoCompression:kLZ4Compression:kLZ4Compression:kLZ4Compression:kLZ4Compression:kZSTD;num_levels=7;
      rocksdb_db_write_buffer_size = 64M
      rocksdb_block_cache_size = 500M[vagrant@control myrocks57]$ docker start -i mysql3
      ERROR: mysqld failed while attempting to check config
      command was: "mysqld --verbose --help"2019-03-12T13:12:14.586400Z 0 [ERROR] unknown variable 'rocksdb_db_write_buffer_size=64M'
      2019-03-12T13:12:14.591054Z 0 [ERROR] Aborting
      [vagrant@control myrocks57]$ cat ./docker-compose.yml
      version: '2'
      services:
        mysqlmaster:
          image: percona/percona-server:5.7
          container_name: mysql1
          environment:
            - MYSQL_ALLOW_EMPTY_PASSWORD=yes
          mem_limit: 1073741824
          volumes:
            - ./mysql1.cnf:/etc/mysql/my.cnf  mysqlreplica:
          image: percona/percona-server:5.7
          container_name: mysql2
          environment:
            - MYSQL_ALLOW_EMPTY_PASSWORD=yes
          depends_on:
            - mysqlmaster
          mem_limit: 1073741824
          volumes:
            - ./mysql2.cnf:/etc/mysql/my.cnf  mysqlreplica2:
          image: percona/percona-server:5.7
          container_name: mysql3
          environment:
            - MYSQL_ALLOW_EMPTY_PASSWORD=yes
          depends_on:
            - mysqlreplica
          mem_limit: 1073741824
          volumes:
            - ./mysql3.cnf:/etc/mysql/my.cnf
      [vagrant@control myrocks57]$ cat ./mysql3.cnf
      [vagrant@control myrocks57]$ vi ./mysql3.cnf
      [vagrant@control myrocks57]$ cat ./mysql3.cnf
      [mysqld]
      server-id = 3
      log-bin
      binlog-format=mixed
      log-slave-updates
      skip-name-resolve
      #log_error = /var/log/mysqld.log#rocksdb_default_cf_options = block_based_table_factory={filter_policy=bloomfilter:10:false};compression_per_level=kNoCompression:kNoCompression:kLZ4Compression:kLZ4Compression:kLZ4Compression:kLZ4Compression:kZSTD;num_levels=7;
      #rocksdb_db_write_buffer_size = 64M
      #rocksdb_block_cache_size = 500M
      [vagrant@control myrocks57]$ docker start mysql3
      mysql3
      [vagrant@control myrocks57]$ docker exec -it mysql3 mysql -u root -p
      Enter password:
      Welcome to the MySQL monitor.  Commands end with ; or \g.
      Your MySQL connection id is 5
      Server version: 5.7.25-28-log Percona Server (GPL), Release 28, Revision c335905Copyright (c) 2009-2019 Percona LLC and/or its affiliates
      Copyright (c) 2000, 2019, Oracle and/or its affiliates. All rights reserved.Oracle is a registered trademark of Oracle Corporation and/or its
      affiliates. Other names may be trademarks of their respective
      owners.Type 'help;' or '\h' for help. Type '\c' to clear the current input statement.mysql> show engines;
      +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
      | Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |
      +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
      | ROCKSDB            | YES     | RocksDB storage engine                                                     | YES          | YES  | YES        |
      | MRG_MYISAM         | YES     | Collection of identical MyISAM tables                                      | NO           | NO   | NO         |
      | CSV                | YES     | CSV storage engine                                                         | NO           | NO   | NO         |
      | BLACKHOLE          | YES     | /dev/null storage engine (anything you write to it disappears)             | NO           | NO   | NO         |
      | InnoDB             | DEFAULT | Percona-XtraDB, Supports transactions, row-level locking, and foreign keys | YES          | YES  | YES        |
      | MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         |
      | ARCHIVE            | YES     | Archive storage engine                                                     | NO           | NO   | NO         |
      | MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         |
      | FEDERATED          | NO      | Federated MySQL storage engine                                             | NULL         | NULL | NULL       |
      | PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         |
      +--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+
      10 rows in set (0.00 sec)mysql> show plugins;
      +-------------------------------+----------+--------------------+---------------+---------+
      | Name                          | Status   | Type               | Library       | License |
      +-------------------------------+----------+--------------------+---------------+---------+
      | binlog                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | mysql_native_password         | ACTIVE   | AUTHENTICATION     | NULL          | GPL     |
      | sha256_password               | ACTIVE   | AUTHENTICATION     | NULL          | GPL     |
      | PERFORMANCE_SCHEMA            | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | CSV                           | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | MyISAM                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | MEMORY                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | MRG_MYISAM                    | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | InnoDB                        | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | XTRADB_READ_VIEW              | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | XTRADB_INTERNAL_HASH_TABLES   | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | XTRADB_RSEG                   | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | XTRADB_ZIP_DICT               | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | XTRADB_ZIP_DICT_COLS          | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_TRX                    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_LOCKS                  | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_LOCK_WAITS             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_CMP                    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_CMP_RESET              | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_CMPMEM                 | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_CMPMEM_RESET           | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_CMP_PER_INDEX          | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_CMP_PER_INDEX_RESET    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_BUFFER_PAGE            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_BUFFER_PAGE_LRU        | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_BUFFER_POOL_STATS      | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_TEMP_TABLE_INFO        | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_METRICS                | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_FT_DEFAULT_STOPWORD    | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_FT_DELETED             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_FT_BEING_DELETED       | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_FT_CONFIG              | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_FT_INDEX_CACHE         | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_FT_INDEX_TABLE         | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_TABLES             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_TABLESTATS         | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_INDEXES            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_COLUMNS            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_FIELDS             | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_FOREIGN            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_FOREIGN_COLS       | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_TABLESPACES        | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_DATAFILES          | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_CHANGED_PAGES          | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_SYS_VIRTUAL            | ACTIVE   | INFORMATION SCHEMA | NULL          | GPL     |
      | INNODB_TABLESPACES_ENCRYPTION | ACTIVE   | INFORMATION SCHEMA | NULL          | BSD     |
      | INNODB_TABLESPACES_SCRUBBING  | ACTIVE   | INFORMATION SCHEMA | NULL          | BSD     |
      | partition                     | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | ARCHIVE                       | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | BLACKHOLE                     | ACTIVE   | STORAGE ENGINE     | NULL          | GPL     |
      | FEDERATED                     | DISABLED | STORAGE ENGINE     | NULL          | GPL     |
      | ngram                         | ACTIVE   | FTPARSER           | NULL          | GPL     |
      | ROCKSDB                       | ACTIVE   | STORAGE ENGINE     | ha_rocksdb.so | GPL     |
      | ROCKSDB_CFSTATS               | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_CF_OPTIONS            | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_COMPACTION_STATS      | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_DBSTATS               | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_DDL                   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_DEADLOCK              | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_GLOBAL_INFO           | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_INDEX_FILE_MAP        | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_LOCKS                 | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_PERF_CONTEXT          | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_PERF_CONTEXT_GLOBAL   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      | ROCKSDB_TRX                   | ACTIVE   | INFORMATION SCHEMA | ha_rocksdb.so | GPL     |
      +-------------------------------+----------+--------------------+---------------+---------+
      65 rows in set (0.00 sec)mysql> exit
      Bye
      [vagrant@control myrocks57]$
      
      

      The dockerfile for this image leads me to believe that MyRocks is supposed to be fully supported,

      https://github.com/percona/percona-docker/blob/master/percona-server.57/Dockerfile#L27

       

        Smart Checklist

          Attachments

            Activity

              People

              • Assignee:
                Unassigned
                Reporter:
                Sylvester Peter Sylvester
              • Votes:
                0 Vote for this issue
                Watchers:
                2 Start watching this issue

                Dates

                • Created:
                  Updated: