Supports a variety of DBMS

We provide variety of services for Enterprise and Community Database such as MariaDB, MySQL, PostgreSQL, Percona Server and Redis.

Available DBMS products

MariaDB

MariaDB Server is one of the most popular database servers in the world. It’s made by the original developers of MySQL and guaranteed to stay open source. Notable users include Wikipedia, WordPress.com and Google.


MySQL

MySQL si world's second most widely used relational database management system and most widely used open source DBMS.

PostgreSQL

PostgreSQL is a powerful, open source object-relational database system that uses and extends the SQL language combined with many features that safely store and scale the most complicated data workloads. The origins of PostgreSQL date back to 1986 as part of the POSTGRES project at the University of California at Berkeley and has more than 30 years of active development on the core platform.

Percona Server for MySQL

Whether you’re running Percona Server for MySQL, MySQL Enterprise Edition, MySQL Community Edition, or some other MySQL fork, Percona offers a comprehensive, responsive, and cost-effective support, managed service or consulting plan to help your organization’s MySQL deployment succeed

Technical support details

Operation Plan Using MaxSacle

1. Router method
Replacement of traditional physical equipment (L4)
Intelligent distributed processing of Master/Slave structures with Readwrite
Hidden Backend Information / Security Enhancements

2. HA method
Support for various cluster configurations
Auto-Failover for Master Node failure

3. Flexibility & Scalability method
Verification of new version through Tee Filter
Sharding a Simple Database with schmearouter
binlogrouter binlog Server role

Redundancy Configuration with MHA

When Master DB becomes inoperable due to a failure, it automatically performs failover to promote slave DB to master DB to minimize service downtime.

1. MHA Server Configuration
A total of three MHA Manager, Masrer, and Slave servers are the default configurations, and under some circumstances, one master and at least two N Salves are available. (Activity, Standby)
Master and Slave share one VIP, DB connection uses the VIP, and in case of a failure, control is carried out using VIP.

2. MHA  Replication
Mysql supports Lossless Replication, which ensures that if data changes in Master, there must be a relay log somewhere in Slave.
In the event of a failure, MHA promotes the most recently changed Slave to Master DB and performs data recovery to relay logs through Lossless Replication.
It usually takes 10 to 30 seconds from failure to master DB promotion and data recovery.

3.  MHA FailOver
If Master DB fails, the MHA Manager downloads the VIP of the Master appliance.
After then, proceed with the replication, raise the downloaded VIP from the slave equipment and proceed with FailOver.

Galera Cluster for Clustering

Galera cluster is an open source provided by http://galeracluster.com/ and uses synchronous replication structures.

When each node has a write or update to any node, it completes copying the data to all nodes, and the update is saved to the file. If you look at the architecture, each MySQL node has a module called WSREP, as shown above. This module is a general-purpose module for replication to the database, and if you connect the Galera replication module to it like a driver, it replicates the data to a different mysql node whenever there is a data change.


ubuntu

Lorem ipsum dolor sit amet, consectetur adipisicing elit. Autem laudantium in adipisci ipsa optio quas id excepturi non, eos cupiditate, necessitatibus sapiente illo error. Vero adipisci quidem aut itaque labore.

Next Opensource Cloud Value

Address

1583, Yangcheon-ro, Gangseo-gu, Seoul, Republic of Korea

Links
  • OpenSource
  • Consulting
  • DBMon-Star