64 results found

1. create a pool of allowed IPs to remote connect to MySQL

   Create a pool of allowed IPs to remotely connect to MySQL and have it allowed for multiple MySQL users

   3 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Databases  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

2. Please add support for PostgreSQL 14

   Please add a support for PostgreSQL Database Server in Plesk. I am using plesk version 18 and I can't manage my PostgreSQL 14 Server with a Plesk Control panel. The Problem appears in menu "Database Servers". Thank you.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Databases  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

   We will consider this functionality in upcoming releases if it will be popular.

   Everyone, please continue voting for this feature if you consider it important.

   -- PD

3. Add a check and repair to "plesk repair db" for missing database server table entries

   https://talk.plesk.com/threads/plesk-obsidian-version-18-0-50-database-servers-missing.368186/#post-922752

   If entries are missing from the "DatabaseServers" table, neither "plesk repair db", nor "plesk repair installation" detects or fixes it.

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Databases  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

4. Display size of databases in Databases view

   Would be great to display size of databases in the list of databases view.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   1 comment  ·  Databases  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

5. MariaDB Xpand. Horizontal Scaling of Both Writes & Reads.

   MariaDB Xpand Database. Horizontal Scaling of Both Writes & Reads.

   Horizontal Scaling Secret #1: Automatic Data Distribution

   As tables and indexes are created, they are automatically “sliced” and distributed across all the nodes in the cluster. This distribution utilizes 64 bit consistent hashing based on the data keys, so each slice’s location is predictable, as well as what data it contains, from a simple metadata map. So any transaction running on any node can access any data on the cluster from at most a single hop away, and the “lookup” to find that data is a local in-memory table in the RDBMS. Our multi-patented Clustrix Rebalancer automatically distributes data across the cluster, partitioning the data both horizontally (slices) and vertically (representations).

   Horizontal Scaling Secret #2: Automatic Fan-out of SQL Queries

   On the query side, the SQL language is declarative, and not trivially parallelized or scaled horizontally. ClustrixDB solves this problem by pre-parsing each query, and distributing compiled query fragments directly to the specific cluster nodes containing the requisite data. This allows data processing to be done locally, minimizing data movement, and only returning result-sets to the initiating node. This kind of query fragment forwarding is very fast, due to the metadata map of where all the data resides. We call this “bringing the query to the data, rather than the reverse.” And this also allows massive parallelism of queries; large queries get maximum parallelism, while many simultaneous queries get max concurrency across all the nodes in the cluster.

   Horizontal Scaling Secret #3: Automatic Data Rebalancing

   A big challenge of data distribution across shared-nothing systems is data imbalance and/or hotspots. A node’s storage can get full, requiring repartitioning table(s) and moving data to a new node (called “re-sharding” if it’s a sharded system), to create more space. Correspondingly, a node can experience contention of CPU or network access without the storage being exhausted. This kind of contention can happen if the data distribution isn’t granular enough, allowing too many simultaneous transactions to occur on a small segment of data. This is called a “hotspot,” and is automatically handled by the Clustrix Rebalancer as well. The Clustrix Rebalancer automatically notices usage patterns, and re-splits high-access data slices, moving half of the data slice in contention to another node.

   Basically, the three main issues with the horizontal scaling of SQL are automatically handled by ClustrixDB, neither requiring changes to the MySQL application, nor data maintenance to be handled by DevOps. Being able to horizontally scale your MySQL application without needing to shard represents a significant CAPEX and OPEX savings to your IT and DevOps budgets.

   MariaDB Xpand Database. Horizontal Scaling of Both Writes & Reads.

   Horizontal Scaling Secret #1: Automatic Data Distribution

   As tables and indexes are created, they are automatically “sliced” and distributed across all the nodes in the cluster. This distribution utilizes 64 bit consistent hashing based on the data keys, so each slice’s location is predictable, as well as what data it contains, from a simple metadata map. So any transaction running on any node can access any data on the cluster from at most a single hop away, and the “lookup” to find that data is a local in-memory table in… more

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Databases  ·  Edit…  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

6. Possibility of creating dumps for databases in external servers over CLI

   possibility of creating dumps for databases in external servers over CLI

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Databases  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

   Thank you for your input! We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.    

   
   

   --

   IG

7. Database changes history

   Database history log or table where database changes are stored. For example, phone column was modified in person table and what change was made
   What does customer want to solve with this feature?
   customer wants to be able to track database changes.

   2 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Databases  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

   Thank you for your input! We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.   

   
   

   -- 

   IG

8. Implement checking of the psa database for inconsistencies after adjusting the domain's settings

   In particular circumstances when a domain's hosting type is switched to No hosting and back to Website Hosting, the following issue occurs: https://support.plesk.com/hc/en-us/articles/360013744460
   It would be helpful to implement a tool for checking the psa database for inconsistencies after the domain's hosting type is switched

   1 vote

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   0 comments  ·  Databases  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

9. Edit MySQL server settings (my.cnf file) trough Plesk

   MySQL server settings (my.cnf) can only be updated via CLI, it would be faster if these changes could be made in Plesk Panel or PHPMyAdmin without the need to edit settings on server.

   17 votes

   Vote Vote Vote

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close

   Vote

   We’ll send you updates on this idea

   2 comments  ·  Databases  ·  Delete…  ·  Admin →
   How important is this to you?

   Not at all You must login first! Important You must login first! Critical You must login first!

   We're glad you're here

   Please sign in to leave feedback

   Signed in as (Sign out)

   Close

   Close
   open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

   Thank you for your input! We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.

   
   

   --

   IG

10. Install MySQL Connector/ODBC 8.0 to support modern TLS versions and ciphers

    (This is related to https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/44353242-add-mariadb-connector-odbc)

    > Drivers

    MySQL Connector/ODBC version 8 needs to be available to Plesk users, because 5.3 is outdated, not to mention 3.51.

    In MySQL Connector/ODBC, there is support for new, modern TLS versions and ciphers.

    https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
    > As of MySQL 8.0.26, the TLSv1 and TLSv1.1 connection
    > protocols are deprecated and support for them is subject to
    > removal in a future version of MySQL. See Deprecated
    > TLS Protocols.

    And please remove MySQL Connector/ODBC 3.51. I cannot think of any reason Plesk should rely on, or support, this version. The following runs perfectly in my setup:

    (Get-ItemProperty "hklm:\SOFTWARE\ODBC\ODBCINST.INI\MySQL ODBC 3.51 Driver").Driver
    c:\vevida\myodbc\8.0.21\x64\myodbc8W.dll

    (a registered ODBC driver is nothing more than a registry value to a DLL file in Windows Server)

    (This is related to https://plesk.uservoice.com/forums/184549-feature-suggestions/suggestions/44353242-add-mariadb-connector-odbc)

    > Drivers

    MySQL Connector/ODBC version 8 needs to be available to Plesk users, because 5.3 is outdated, not to mention 3.51.

    In MySQL Connector/ODBC, there is support for new, modern TLS versions and ciphers.

    https://dev.mysql.com/doc/refman/8.0/en/encrypted-connection-protocols-ciphers.html
    > As of MySQL 8.0.26, the TLSv1 and TLSv1.1 connection
    > protocols are deprecated and support for them is subject to
    > removal in a future version of MySQL. See Deprecated
    > TLS Protocols.

    And please remove MySQL Connector/ODBC 3.51. I cannot think of any reason Plesk should rely on, or support, this version. The following runs perfectly in… more

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

11. Add MariaDB Connector/ODBC

    > Drivers

    With MySQL and MariaDB going their own way more and more, it is important to add MariaDB Connector/ODBC as an programming interface to Plesk as well. Side by side with the already available MySQL Connector/ODBC. This is easily done.

    One cannot guarantee MySQL Connector/ODBC to be compatible with MariaDB in the near future.

    Download MariaDB Connector/ODBC from here:
    https://mariadb.com/kb/en/mariadb-connector-odbc-3113-release-notes/

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

12. Diskspace calculation for remote PostgreSQL databases

    Add diskspace calculation for remote PostgreSQL databases

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

13. Ability to track number of simultaneous connections to the MySQL

    Sometimes Plesk is not accessible with error:
    DB query failed: "SET sql_mode = ''" Error: SQLSTATE[08004] [1040] Too many connections

    It is possible to inrease the number of connections but it will also be good to have some monitoring of the current number of simultaneous connections to the MySQL, for example in Advanced Monitoring extension.

    It will help to prevent Plesk downtime and set the reasonabl limit for max_connections

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

14. Ability to select database schema when creating database users in Plesk for MSSQL

    It is required to import databases created externaly with dbo database schema.

    When such database imported in Plesk it is assigned to schema of the database user created in Plesk. When user created in Plesk, new schema is created for database user. For example, user test1 created in Plesk will have database schema "test1"

    This results to the non-functional Database due to wrong schema (reuqired dbo, while database imported with schema test1).

    The suggestion is to add functionality to select schema when creating database users in Plesk

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

15. Add the ability to encrypt a Database via Plesk interface

    Add the ability to encrypt databases as Transparent Data Encryption (TDE) via Plesk interface, which is supported in MariaDB 10.1 and later.

    At-rest encryption means the data files and logs are encrypted on the disk and makes it almost impossible for someone to access or steal a hard disk and get access to the original data (provided that the key is secured and not stored locally).

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

16. Protect databse from removal

    Protect databse from accidental removal, so the database behaves in the same way as the following wordpress_e: greyed out so it cannot be deleted.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

17. The possibility to set the PostgreSQL Charset from ASC_II to UTF8.

    The possibility to set the PostgreSQL Charset from ASC_II to UTF8 during a database creation.

    1 vote

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  AdminPlesk Staff (Community Manager, Plesk International GmbH) responded

    Thank you for your input! We will consider this functionality in upcoming releases if it will be popular. Everyone, please continue voting for this feature if you consider it important.

    —
    IG

18. MySQL change the charset

    Allow to chose another charset when creating a database or do not set one.

    Plesk does use:
    "CREATE DATABASE databasename /*!40101 default charset=utf8 */"
    And with this does overwrite when the MySQL config was changed to use utf8mb4 for example.

    Or allow to choose a charset on creation or create DBs with:
    "CREATE DATABASE databasename"

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  IgorG responded

    Thank you for your input. We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.
    —
    IG

19. Ability to clone databases with definers

    On the attempt to clone database with DEFINER Plesk failed if there is no the same user on destination database.

    Currently, it is required either manually remove definer from database dump or add super priveleges: https://support.plesk.com/hc/en-us/articles/360005033014-Unable-to-import-MySQL-dump-using-Import-Dump-feature-in-Plesk-ERROR-1227-42000-at-line-1421-Access-denied-you-need-at-least-one-of-the-SUPER-privilege-s-for-this-operation

    Since Mysql version 5.7.8 it is possible to use the --skip-definer option with mysqldump:
    https://dev.mysql.com/doc/refman/5.7/en/mysqlpump.html

    The suggestion is to add ability to clone database skipping definers as option in Plesk GUI

    2 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    1 comment  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  IgorG responded

    Thank you for your input. We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.
    —
    IG

20. Better Database Server Assignment / Visibility

    Currently you only have the option to do nothing and "SHOW ALL" database servers or restrict to a single database server per subscription by using the permissions tab. This means each user that falls under this criteria need a custom service plan.

    We would like to display more than a single database server for clients that choose to pay extra for an additional database server that only they can use. Some projects grow and they need an additional database server - or in some cases they need to migrate data between the old database server (sometimes local to plesk server) and their new database server - themselves.

    It would be useful to assign database servers to subscriptions/domains as needed for resource management.

    Currently you only have the option to do nothing and "SHOW ALL" database servers or restrict to a single database server per subscription by using the permissions tab. This means each user that falls under this criteria need a custom service plan.

    We would like to display more than a single database server for clients that choose to pay extra for an additional database server that only they can use. Some projects grow and they need an additional database server - or in some cases they need to migrate data between the old database server (sometimes local to plesk server)… more

    3 votes

    Vote Vote Vote

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close

    Vote

    We’ll send you updates on this idea

    0 comments  ·  Databases  ·  Delete…  ·  Admin →
    How important is this to you?

    Not at all You must login first! Important You must login first! Critical You must login first!

    We're glad you're here

    Please sign in to leave feedback

    Signed in as (Sign out)

    Close

    Close
    open discussion  ·  IgorG responded

    Thank you for your input. We will consider this functionality in upcoming releases if it is popular. Everyone, please continue voting for this feature if you consider it important.
    —
    IG