Broad Compatibility Options of dbForge Studio for MySQL

dbForge Studio for MySQL supports the most popular MySQL-compatible cloud databases, storage and search engines, thus allowing you to select the most suitable for your needs. With such MySQL cloud services as Amazon RDS, Amazon Aurora, Google Cloud, Galera Cluster, Percona, Oracle Cloud, and Alibaba Cloud high performance, reliability, and scalability are guaranteed. Stop worrying about security issues and data theft - get connected to dbForge Studio for MySQL!

Database Servers

A database server is a server which uses a database application that provides database services to other computer programs or to computers, as defined by the client–server model. Studo for MySQL provides support for the following range of database servers.
MySQL

MySQL

An open-source server with a huge amount of table types such as ISAM, HEAP, and MyISAM supporting a full-text search and InnoDB containing transactions of separate records. Owing to the open architecture and GPL-license, the number of new table types is always increasing.

MariaDB

MariaDB

MariaDB is an open-source database server used to turn data into structured information for various applications. It supports a lot of storage engines, plugins, and other tools which make it ultimate for use by users.

Learn more
Percona

Percona

Percona server provides high performance, reliability, and security including scalability as well as query, object and user level tools. In addition to those features, Percona tools drastically decrease downtime on the servers with large memory and poor speed as well as minimize highload.

Galera Cluster

Galera Cluster

Galera Cluster is an open-source database cluster for MySQL with synchronous multi-master replication. It provides high system uptime, no data and transaction lost as well as no single point failure. With Galera MySQL, it is possible to write and read from any MySQL Server, to automatically control membership and to directly connect to client machines.

Cloud Servers

A cloud server is a virtual server (rather than a physical server) running in a cloud computing environment. It is built, hosted and delivered via a cloud computing platform via the internet, and can be accessed remotely. They are also known as virtual servers. dbForge MySQL IDE provides support for the following array of cloud servers.
Amazon RDS

Amazon RDS

Amazon RDS for MySQL and MariaDB is a cloud service that simplifies the process of setting up and scaling databases. With this service, users can perform fast deployment and automatically run backup and updates of database software.

Learn more
Amazon Aurora

Amazon Aurora

Amazon Aurora for MySQL is a relational database engine compatible with MySQL databases that delivers secure and reliable tools to manage, backup, restore databases and automatically detect database errors. As a benefit, there is no need in disabling access to databases when it is required to repair failures - it can be done on the backend.

Google Cloud

Google Cloud

Secure and reliable Google Cloud MySQL with high performance that allows users to store their information, develop applications in the Google command-line interface, protect access to the resources allocated on the Google platform, deliver ultimate reliability, and much more.

Moreover, with Google Cloud SQL, you can easily control MySQL database management and create automated backups and recoveries, whose timeframe can be set in a few clicks.

Oracle MySQL Cloud

Oracle Cloud

Oracle MySQL Database Service delivers a secure, cost-effective and enterprise-grade MySQL database service. Built on MySQL Enterprise Edition and powered by the Oracle Cloud, it provides a simple, automated, integrated and enterprise ready MySQL cloud service, enabling organizations to increase business agility and reduce costs.

Alibaba Cloud

Alibaba Cloud

A fully-featured suite of services including data storage, relational database, big-data processing, anti-DDoS, and mobile protection. With Alibaba Cloud, users can manage and monitor their cloud performance in real-time mode.

Tencent Cloud

Tencent Cloud

Tencent Cloud enables you to deploy and use MySQL database in the cloud with ease. With Tencent Cloud, it only takes minutes to deploy a scalable MySQL database instance. Besides high cost efficiency, you can enjoy flexibly scalable hardware specs without business interruption.

DigitalOcean Managed Database

DigitalOcean Managed Database

A managed database is a cloud computing service in which the end user pays a cloud service provider for access to a database. This allows you to focus on building your application instead of spending time configuring a database and keeping it up to date.

Azure MySQL

Azure MySQL

Azure Database for MySQL is a relational database service powered by the MySQL community edition. Azure MySQL is a fully managed database as well as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability.

Learn more
Azure MariaDb

Azure MariaDB

Azure Database for MariaDB is a relational database service based on the open-source MariaDB Server engine. Azure MariaDB is a fully managed database as a service offering that can handle mission-critical workloads with predictable performance and dynamic scalability.

SkySQL

SkySQL

Built for mission-critical applications and enterprise governance, SkySQL augments automation with the human expertise and experience needed to support and manage mission-critical deployments in the cloud.

Heroku

Heroku

A cloud platform as a service, Heroku offers a ready-to-use environment with integrated data services and powerful ecosystem, thus, allowing developers to deploy their code fast and focus on code instead of infrastructure.

Aiven Cloud

Aiven Cloud

Aiven simplifies the setup of cloud databases, making it easily accessible to anyone. Their "set-it-and-forget-it" solutions alleviate the burden of managing cloud data infrastructure, empowering the user to determine their next course of action.

Learn more

Connection Types

Database connection provides the basic configuration details to connect to a database system e.g. hostname, port, userID, password etc. dbForge Studio for MySQL provides support for the following variety of database connection types.
Secure Sockets Layer (SSL)

Secure Sockets Layer (SSL)

With an SSL certificate, users can transmit data without worrying about their data theft or loss. This certificate encrypts data and ensures that all the information transmitted via the Internet is private and that no one even if they get access to it will read messages or disclose data.

Secure Shell (SSH)

Secure Shell (SSH)

SSH is a network protocol that provides secure communication in the client/server environment. SSH protocols guarantee secure authentication and data transmission. Plus, with this protocol, data is encrypted into a set of symbols to prevent data from theft or interception.

HTTP Tunneling

HTTP Tunneling

HTTP tunneling is a technique used to transmit data from a client (MySQL) to a web-server and vice versa via HTTP protocol. With the help of dbForge Studio for MySQL, it may be used as a workaround when a firewall blocks the access from all network protocols (except HTTP) or when it is not possible to do this for security reasons.

Learn more
Embedded Server

Embedded Server

Embedded server can be used by applications that do not require multi-user data access. It provides a lot of essential benefits such as increased reliability and scalability, cross-platform flexibility, and low-cost support.

Authentication

Database authentication is the process or act of confirming that a user who is attempting to log in to a database is authorized to do so, and is only accorded the rights to perform activities that he or she has been authorized to do. dbForge Studio for MySQL provides the following authentication options.
Secure Sockets Layer (SSL)

Secure Hash Algorithm (SHA256)

SHA256 authentication is used to effectively protect intellectual property from counterfeiting and illegal copying. It provides advanced physical security to deliver low-cost IP protection, clone prevention, and peripheral authentication.

Percona PAM Authentication

Percona PAM Authentication

PAM Percona works on MySQL and Percona Server. It correctly recognizes whether input data should be duplicated or not. Additionally, PAM Percona can use the password which is passed to MySQL client via "-p" parameter.

MariaDb Pluggable Authentication GSSAPI

MariaDb Pluggable Authentication GSSAPI

MariaDB GSSAPI is an authentication option is used to access security services. Since it allows controlling process over security aspects, a programmer is able to develop database that is ignorant of the details of protecting network data.

MariaDb Authentication Plugin Ed25519

MariaDb Authentication Plugin Ed25519

This plugin was designed to replace the outdated authentication standard SNA-1. It is based on Elliptic Curve Digital Signature Algorithm and provides total security in storing users' passwords authenticating users.

TLS 1.0, 1.1, 1.2, 1.3

TLS 1.0, 1.1, 1.2, 1.3

TLS protocol is the most innovative tool that provides authentication security over a computer network. It consists of different methods for exchanging keys, encrypting data, and authenticating message integrity. With the help of dbForge Studio for MySQL, a developer will be able to use all features of any of the TLS versions (1.0, 1.1, 1.2, 1.3).

Storage Engines

Storage engines are MySQL components that handle the SQL operations for different table types. The search engines supported by dbForge Studio for MySQL are listed below.
MyISAM

MyISAM

MyISAM is a full-text storage engine used in web and other application environments. It stores data in files and creates a separate file for each table. Moreover, MyISAM is optimized for the INSERT operations, especially at high runtime.

InnoDB

InnoDB

InnoDB supports Multi Version Concurrency Control (MVCC), transactions and foreign keys that may prevent aborted operations. Furthermore, it blocks tables at a row level. By default, tables are stored in a sharable file.

TokuDB

TokuDB

It is an open-source powerful storage engine with a built-in Fractal tree index based on the Percona server. With this engine, users can reduce the size of databases by up to 90% and improve performance of large databases, as well as modify schema in an online mode. When you experience high runtime and workload, use TokuDB.

Connect

Connect

The CONNECT storage engine enables MariaDB to access external local or remote data (MED). This is done by defining tables based on different data types, in particular files in various formats, data extracted from other DBMS or products (such as Excel or MongoDB) via ODBC or JDBC, or data retrieved from the environment (for example DIR, WMI, and MAC tables). This storage engine supports table partitioning, MariaDB virtual columns and permits defining special columns such as ROWID, FILEID, and SERVID.

Spider

Spider

The Spider storage engine is a storage engine with built-in sharding features. It supports partitioning and XA transactions, and allows tables of different MariaDB instances to be handled as if they were on the same instance.

RocksDB

RocksDB

RocksDB is an embeddable persistent key-value store for fast storage. It uses a log structured database engine, written entirely in C++, for maximum performance.

NDBCLUSTER

NDBCLUSTER

The NDBCLUSTER storage engine may be used for applications with high availability and performance. It enables clustering of in- memory databases in the environment where each component has its own memory and disk.

MERGE

MERGE

MariaDB GSSAPI is an authentication option is used to access security services. Since it allows controlling process over security aspects, a programmer is able to develop database that is ignorant of the details of protecting network data.

MEMORY

MEMORY

The MEMORY storage engine, mostly used as a temporary or read-only method to retrieve data from other tables, provides replication and query cache support. It supports hash and B-tree indexes, as well as data encryption for security reasons. Alternatively, users can schedule data backup and recovery.

FEDERATED

FEDERATED

The storage engine allows users to create a table with the identical structure and to retrieve data by connecting to a remote server. Local data can be stored either on a local or remote MySQL instance. In the local directory, only the .frm file is created. It is possible to deploy FEDERATED on a local server after the table is created on the remote server. In addition, the query syntax is checked on the local server.

MariaDB ColumnStore

MariaDB ColumnStore

MariaDB ColumnStore is a columnar storage engine that utilizes a massively parallel distributed data architecture. It's a columnar storage system built by porting InfiniDB 4.6.7 to MariaDB, and released under the GPL license.

Search Engine

A database search engine is a search engine that operates on material stored in a digital database. dbForge Studio for MySQL provides support for the following search engine.
Sphinx

Sphinx

Sphinx is an open-source search engine designed to perform full-text search in applications. It provides high indexing and search speed, distributed searching capabilities. Additionally, it supports boolean, phrase, and word queries as well as multiple full-text fields per document.

dbForge Studio for MySQL

Best MySQL GUI tool you can find