Previous Next

Broad Compatibility Options of dbForge Studio for MySQL

Nowadays, a secure connection plays a vital role in the life of each person. Since databases can store sensitive information, it is necessary to protect transmitted data in order to avoid its modification and theft. Thus, to boost the security of access to your databases, you can take advantage of our dbForge Studio secure connection feature for MySQL.

dbForge Studio for MySQL supports the following secure features:

Database Servers

MySQL Server

An open-source server with a huge amount of table types such as MyISAM supporting a fully text search and InnoDB containing transactions of separate records. Due to the open architecture and GPL-lisence a number of new table types is always increasing.

MariaDB Server

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 makes it ultimate for using by users.

Percona

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

Galera Cluster

Galera Cluster is an open-source database cluster with synchronous multi-master replication. It provides high system uptime, no data and transaction lost as well as no single point failure.

Cloud Services

Amazon RDS

Amazon Relational Database Service 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.

Amazon Aurora

Amazon Aurora 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

Secure and reliable cloud platform with high performance that allows users to store their information, develop applications in the Google command-line interface, control and protect access for the resources allocated on the Google's platform and much more.

Alibaba Cloud

A fully-featured suite of services including data storage, relational database and big-data processing, anti-DDoS and mobile protection and much more. With this package of tools, users can manage and track their cloud performance in a real-time mode.

Authentication

Secure Sockets Layer (SSL)

With a 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)

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

HTTP Tunneling

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

More information

PAM Percona

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.

Storage Engines

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. To move on, MyISAM is optimized for the INSERT operations, especially at high runtime.

InnoDB

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

TokuDB

It is an open-source powerful storage engine with a built-in Fractal tree index based on the Percona server. Using 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.

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

The MERGE storage engine combines MyISAM tables with identical columns and index formation that are listed in the same order into one logical table. It is possible to use the following operators there: SELECT, UPDATE, DELETE, and INSERT. MERGE tables can easily exceed the maximum file size limit imposed by an operating system.

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. Additionally, it supports hash and B-tree indexes, as well as data encryption for security reasons. Alternatively, users can schedule data backup and recovery.

FEDERATED

The storage engine allows users to create a table with the identical structure and 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 the FEDERATED storage engine on a local server after the table is created on the remote server. In addition, the query syntax is checked on the local server.

Search Engine

Sphinx

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

More information