Hi,

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

Regards,

Christophe

De : Maria-discuss [mailto:maria-discuss-bounces+christophe.le.roux=fr.clara.net@lists.launchpad.net] De la part de Seung Hoon Yoo
Envoyé : mercredi 9 mars 2016 11:07
À : mariadb-discuss <maria-discuss@lists.launchpad.net>
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.