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

Installing Percona Server on Debian and Ubuntu - Documentation

    XMLWordPrintable

    Details

    • Type: Bug
    • Status: Pending Release
    • Priority: Medium
    • Resolution: Fixed
    • Affects Version/s: 5.7.x, 8.0.x
    • Fix Version/s: 8.0.21-12, 5.7.NEXT
    • Component/s: Documentation
    • Labels:
      None

      Description

      Installing Percona Server on Debian and Ubuntu documentation points to TokuDB instead of MyRocks. 

      https://www.percona.com/doc/percona-server/5.7/installation/apt_repo.html

       

      MyRocks does not come out of the box for PS for MySQL and should have additional packages installed in order to work. 

      mysql> \s--------------mysql  Ver 14.14 Distrib 5.7.28-31, for debian-linux-gnu (x86_64) using  7.0
      Connection id: 2Current database:Current user: root@localhostSSL: Not in useCurrent pager: stdoutUsing outfile: ''Using delimiter: ;Server version: 5.7.28-31 Percona Server (GPL), Release '31', Revision 'd14ef86'Protocol version: 10Connection: Localhost via UNIX socketServer characterset: latin1Db     characterset: latin1Client characterset: utf8Conn.  characterset: utf8UNIX socket: /var/run/mysqld/mysqld.sockUptime: 1 min 32 sec
      Threads: 1  Questions: 5  Slow queries: 0  Opens: 107  Flush tables: 1  Open tables: 26  Queries per second avg: 0.054--------------
      mysql>mysql>mysql>mysql>mysql>mysql> show engines;+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+| Engine             | Support | Comment                                                                    | Transactions | XA   | Savepoints |+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+| MyISAM             | YES     | MyISAM storage engine                                                      | NO           | NO   | NO         || 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        || PERFORMANCE_SCHEMA | YES     | Performance Schema                                                         | NO           | NO   | NO         || ARCHIVE            | YES     | Archive storage engine                                                     | NO           | NO   | NO         || MEMORY             | YES     | Hash based, stored in memory, useful for temporary tables                  | NO           | NO   | NO         || FEDERATED          | NO      | Federated MySQL storage engine                                             | NULL         | NULL | NULL       |+--------------------+---------+----------------------------------------------------------------------------+--------------+------+------------+9 rows in set (0.00 sec)
      mysql> exitByeroot@vagrant:~# ps-admin --enable-rocksdbERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)ERROR: Failed to list mysql plugins! Please check username, password and other options for connecting to server...root@vagrant:~# ps-admin --enable-rocksdb -u rootERROR 1045 (28000): Access denied for user 'root'@'localhost' (using password: NO)ERROR: Failed to list mysql plugins! Please check username, password and other options for connecting to server...root@vagrant:~# ps-admin --enable-rocksdb -u root -pEnter password:
      Checking if RocksDB plugin is available for installation ...ERROR: Cannot find ha_rocksdb.so library for RocksDB installation.Make sure you have RocksDB package installed or if running from binary tarball that this library is available.
      root@vagrant:~#
      

       

       

        Smart Checklist

          Attachments

            Activity

              People

              Assignee:
              patrick.birch Patrick Birch
              Reporter:
              alkin.tezuysal Alkin Tezuysal (Inactive)
              Votes:
              0 Vote for this issue
              Watchers:
              4 Start watching this issue

                Dates

                Created:
                Updated:
                Resolved:

                  Time Tracking

                  Estimated:
                  Original Estimate - Not Specified
                  Not Specified
                  Remaining:
                  Remaining Estimate - Not Specified
                  Not Specified
                  Logged:
                  Time Spent - 3 hours, 15 minutes
                  3h 15m