← Back to team overview

maria-discuss team mailing list archive

Re: Question about MariaDB global reference In high complexity app and big DB Size



Maybe Maxscale can help you to (auto-)shared on a dozen of servers, take a look on it.



De : Maria-discuss [mailto:maria-discuss-bounces+christophe.le.roux=fr.clara.net@xxxxxxxxxxxxxxxxxxx] De la part de Seung Hoon Yoo
Envoyé : mercredi 9 mars 2016 11:07
À : mariadb-discuss <maria-discuss@xxxxxxxxxxxxxxxxxxx>
Objet : [Maria-discuss] Question about MariaDB global reference In high complexity app and big DB Size

hi I am some question, i want some opinion below question

We planning ERP solution convert oracle to mariaDB
so erp application pattern and BIG DB SIZING IS ISSUE.

Our IT background & goal
1) Apppliciation Complexity & Pattern: ERP Level complexity (high , OLTP & many batch)
2) DB SIZE : 10 TB Over (Single DB , NO sharding)
3) replication Gap issue

** My Question **
1) Any Global reference is in MariaDB  (on ERP level complexity and application pattern)

2) Any some reference in BIG DATA SIZING ?
   (EX: 5TB DB Exists in XX COMPARY e-commerce soluntion..)

   IS Only solution is DB Sharding? no big data global reference ??

3) Replication performance
  : Our test result 2MB/SEC binlog written in master ,
     so slave node get replication lag glorwing.  (in row binlog format)
                           ( 1master - 1 slave )
    Any Body have experience some reference max transaction in no replication gap ?
                           ( ex : 20MB / SEC but no replication gap our application experience..)

: parellel slave thread is good performance in single domain-id and ordered method replicaiton ?

   ( how much better performance in parallel replication?

   (ex single repliation 2MB/SEC BINLOG => Replication GAP GROW but, parellel replicaiton is good in 10MB/Sec binlog write Environment)

thanks a lot.

regards, seung hoon yoo.

Follow ups