- discuss - lists.mariadb.org

[Maria-discuss] multi master and conflicts
by Roberto Spadim 26 Sep '13

26 Sep '13

Hi guys, New problems to solve here =) if anyone could help should be nice :) I have an old system that use only one server with aria/myisam tables (some temporary tables and some views too) I want to implement a multi master replication (near to a cluster...), but i should take care about replication conflicts.... There's some good pratices or books about implementing multi master without replication conflicts? Should I change it to galera cluster? Well maybe.. I don't know what to do with aria storage, galera works with innodb/xtradb/myisam, what about aria? i didn't tested yet I don't know what to do about commit phase with myisam too, since galera do the certificate at commits phase before commit, and myisam problably do a autocommit at each insert/update/delete, this will be a problem, or not? The idea is not use innodb or I should implement some tables or views to have a faster COUNT/MIN/MAX functions (myisam is optimized for it), and i should rewrite some codes to use BEGIN, COMMIT, and cancel if connection is lost Well physical problems... Servers will not be online all time, the network link isn't good, servers are ~50km far via a wifi link with some tree and birds and others problems (that's why i think async replication is ok, instead of galera 'sync' cluster) Any idea is well come, but should be nice something that myisam/aria could be used I asked some days ago about replication and galera and xtradb cluster, but i'm not sure what to do yet tks guys! ideas are wellcome -- Roberto Spadim

1 0

[Maria-discuss] MySQL 5.7 benchmark
by Colin Charles 24 Sep '13

24 Sep '13

We're featured, pitted against Percona Server and MySQL 5.7 (Dimitri kindly did this for MariaDB 5.5 & 10) http://dimitrik.free.fr/blog/archives/09-01-2013_09-30-2013.html#174 It is unclear what versions of the software he used, or if its the latest alphas we've pushed, but we need to look into this clearly cheers, -colin -- Colin Charles, Chief Evangelist MariaDB | t: +6-012-204-3201 | Skype: colincharles

2 1

[Maria-discuss] async cluster
by Roberto Spadim 24 Sep '13

24 Sep '13

Hi guys, i got a question yesterday... there's an async cluster solution? example... multi-master and async? if it's async, it can't be multi-master, i'm wrong? -- Roberto Spadim

3 6

[Maria-discuss] -DHAVE_POOL_OF_THREADS not configureable?
by Reindl Harald 22 Sep '13

22 Sep '13

should "-DHAVE_POOL_OF_THREADS" not be configureable? Manually-specified variables were not used by the project: HAVE_POOL_OF_THREADS cd /home/builduser/rpmbuild/BUILD/mariadb-5.5.33a/sql && /usr/bin/c++ -DHAVE_CONFIG_H -DHAVE_EVENT_SCHEDULER -DHAVE_OPENSSL -DHAVE_POOL_OF_THREADS -DMYSQL_SERVER ___________________________ IMHO that is a nice idea but in tests with typical PHP allications it slows things down, in case of applications like "dbmail" which have their own sql-connection-pooling it doe snot have benefits yes, you need to enable it in the my.cnf, but i am a fan of disable things at compile-time which are not used inside a known infrastructure and keep binaries as small as possible

1 0

[Maria-discuss] MariaDB 5.5.33a Now Available
by Daniel Bartholomew 20 Sep '13

20 Sep '13

The MariaDB project is pleased to announce the immediate availability of MariaDB 5.5.33a. This is a special bug-fix release to address some packaging and other bugs present in the recent MariaDB 5.5.33 release. See the release notes and changelog for details. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB 5.5.33a Stable (GA) - Release Notes: https://mariadb.com/kb/en/mariadb-5533a-release-notes - Changelog: https://mariadb.com/kb/en/mariadb-5533a-changelog - Downloads: https://downloads.mariadb.org/mariadb/5.5.33a Overview of MariaDB 5.5: https://mariadb.com/kb/en/what-is-mariadb-55 APT and YUM Repository Configuration Generator: - https://downloads.mariadb.org/mariadb/repositories/ - - User Feedback plugin - - - - - - - - - - - - - - - - - - - - - - - MariaDB includes a User Feedback plugin. This plugin is disabled by default. If enabled, it submits basic, completely anonymous MariaDB usage information. This information is used by the developers to track trends in MariaDB usage to better guide development efforts. If you would like to help make MariaDB better, please add "feedback=ON" to your my.cnf (my.ini on Windows) file! See http://mariadb.com/kb/en/user-feedback-plugin for more information. - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: - http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB: An Enhanced Drop-in Replacement for MySQL Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledgebase - http://mariadb.com/kb

1 0

[Maria-discuss] New Question: Importing Access Database Structure
by AskMonty KB 20 Sep '13

20 Sep '13

Hello, A new question has been asked in "MariaDB FAQ" by mmontoya19: -------------------------------- Hello Everyone, I am currently conducting a study and trying to find DB software for company use. There is a current database in use that I am wondering if I can export the structure ONLY into MariaDB. Meaning I want to be able to duplicate the Tables, Relationship, Queries, and if possible reports. Is it possible to do this? -------------------------------- To view or answer this question please visit: http://mariadb.com/kb/en/importing-access-database-structure/

1 0

[Maria-discuss] Galera cluster
by Roberto Spadim 20 Sep '13

20 Sep '13

Hi guys, the galera cluster code is "inside" default mariadb-10.0.4 code? or there's a different branch for galera cluster? -- Roberto Spadim

3 4

[Maria-discuss] 'Converting' a myisam to multi-master
by Roberto Spadim 20 Sep '13

20 Sep '13

Hi guys, there's one easy way to implement a multi-master cluster using myisam/aria ? i know that galera cluster use innodb as backend, there's anything similar to aria/myisam? scaledb? ndb? others? the main problem switching from aria/myisam to innodb is the MIN/MAX/COUNT(*) optimization and the rows sizes/index considerations ( https://mariadb.com/kb/en/converting-tables-from-myisam-to-innodb/) and since it's myisam/aria many apps don't use begin transaction / commit (maybe this is a problem for cluster/multi master?) thanks guys :) -- Roberto Spadim

2 8

[Maria-discuss] Benchmark with jemalloc
by Roberto Spadim 19 Sep '13

19 Sep '13

Hi guys, there're benchmark with jemalloc and last malloc implemention? -- Roberto Spadim

4 16

[Maria-discuss] MariaDB Java Client 1.1.5 Now Available
by Daniel Bartholomew 18 Sep '13

18 Sep '13

The MariaDB project is pleased to announce the immediate availability of the MariaDB Java Client 1.1.5. This is a Stable (GA) release. - - Links - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - MariaDB Java Client 1.1.5 - Release Notes: https://mariadb.com/kb/en/mariadb-java-client-115-release-notes/ - Changelog: https://mariadb.com/kb/en/mariadb-java-client-115-changelog/ - Downloads: https://downloads.mariadb.org/client-java/1.1.5/ Overview of the MariaDB Java Client: https://kb.askmonty.org/en/about-the-mariadb-java-client/ - - Quality - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: http://mariadb.org/jira - - Support MariaDB - - - - - - - - - - - - - - - - - - - - - - - - - - If you would like to contribute to MariaDB, please see our "contributing" and "donations" pages. We also have merchandise available in a cafepress store. - https://mariadb.com/kb/en/contributing - https://mariadb.org/en/donate/ - http://www.cafepress.com/mariadb We hope you enjoy MariaDB! -- MariaDB Website - http://mariadb.org Twitter - http://twitter.com/mariadb Google+ - http://google.com/+mariadb Facebook - http://fb.com/MariaDB.dbms Knowledge Base - https://mariadb.com/kb

1 0