maria-discuss team mailing list archive

[Seung Hoon Yoo <sehyoo96@xxxxxxxxx>]

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.