Hi ALL ,
I test the MariaDB performance of insert command .
I use a file include 10 insert command statements to test the insert
performanc .
On local server ,the Mariadb spent about 20 second to insert data;but on
remote server ,the MariaDB spent about 30 second to insert data .
I execute the
Thanks for answers, Justin and Christophe.
How about below link article
https://en.wikipedia.org/wiki/List_of_ERP_software_packages
some erp open source s/w is developing in Mysql/MariaDB or PostgreSQL
. windows function and recursive SQL is hard thing but i think using user
variables is helpf
Yeah I’m sorry, i have mixed the postgresql-XC partitionning feature and the
Maxscale one.
Regards,
Christophe
De : Justin Swanhart [mailto:greenl...@gmail.com]
Envoyé : mercredi 9 mars 2016 12:59
À : Christophe Le Roux
Cc : Seung Hoon Yoo ; mariadb-discuss
Objet : Re: [Maria-discuss] Questi
Hi,
And generally BOM is implemented using an adjacency model, and
MySQL/MariaDB lack SQL:2003 support for recursive queries, and lack CONNECT
BY .. - thus there is no easy way to access a BOM in MariaDB.
--Justin
On Wed, Mar 9, 2016 at 6:59 AM, Justin Swanhart wrote:
> Hi,
>
> Do you mean sch
Hi,
Do you mean schema routing? Because that won't allow you to join between
schemata. You generally need to join OE to INV to PO, etc in an ERP
system. Sharding by schema won't help. You would end up having to use
multi-master replication to get all the data back on a single node, then
report
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@lists.launchpad.net]
De la part de Seung Hoon Yoo
Envoyé : mercredi 9 mars 2016 11:07
À : mariadb-di
Hi,
I wouldn't try to use MySQL for a 10TB single instance DB unless most of
the data is historical data that isn't accessed frequently. Sharding
generally won't work for such an application, because every table will
likely need partitioned by different keys (ie you have a very large order
table
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
8 matches
Mail list logo
