Tag: MySQL

Feed: MariaDB Knowledge Base Article Feed Author: This tutorial is a short introduction to theAvrorouter, how to set it up and how it interactswith the binlogrouter. The avrorouter can also be deployed directly on the master server which removesthe need to use the binlogrouter. This does require a lot more disk space onthe master server as both the binlogs and the Avro format files are stored there. The first part configures the services and sets them up for the binary log to Avrofile conversion. The second part of this tutorial uses the client listenerinterface for the avrorouter and shows how ... Read More

Feed: MariaDB Knowledge Base Article Feed Author: The avrorouter is a MariaDB 10.0 binary log to Avro file converter. It consumesbinary logs from a local directory and transforms them into a set of Avro files.These files can then be queried by clients for various purposes. This router is intended to be used in tandem with the Binlog Server.The Binlog Server can connect to a master server and request binlog records. Theserecords can then consumed by the avrorouter directly from the binlog cache ofthe Binlog Server. This allows MariaDB MaxScale to automatically transform binlog eventson the master to local Avro format ... Read More

Feed: MariaDB Knowledge Base Article Feed Author: This article describes the system and status variables used by the MariaDB thread pool. For a full description, see Thread Pool in MariaDB. System variables Description: The number of connections on the extra_port. Introduced for the MariaDB 5.1 threadpool. Commandline: --extra-max-connections=# Scope: Global Dynamic: Yes Data Type: numeric Default Value: 1 Range: 1 to 100000 Introduced: MariaDB 5.1 Description: Extra port number to use for tcp-connections in a one-thread-per-connection manner. If set to 0, no other port is used. Introduced for the MariaDB 5.1 threadpool. Commandline: --extra-port=# Scope: Global Dynamic: No Data Type: ... Read More

Feed: MariaDB Knowledge Base Article Feed Author: 이 문서에서는 MariaDB 와 MySQL 서버, 그리고 클라이언트 라이브러리의 라이센스가 다른 어플리케이션에 어떤 영향을 끼치는지와, GPL를 준수하는 절차와 어플리케이션을 변경하지 않고 GPL 을 준수하는 절차에 대해서 설명하고자 한다. 여기부터는 MariaDB에 대해 이야기하게 될 것이다. 이 가이드라인은 일반적으로 MySQL에도 적용된다. (적어도 이 문서가 쓰여진 시점의 최신 안정 버전인 5.1.55 버전까지는) MariaDB 가 사용한 라이센스 MariaDB는 GPL license, 버전 2로 배포된다. The MariaDB 클라이언트 라이브러리 for C, Java and ODBC 는 LGPL 라이센스, 버전 2.1 또는 그 이후 버전으로 배포된다. LGPL 라이센스는 여러분이 이 MariaDB 클라이언트 라이브러리를 이용하여 어떤 어플리케이션에서도 자유롭게 사용할 수 있도록 해준다 ... Read More

Feed: MariaDB Knowledge Base Article Feed Author: This article is to help you configure MariaDB for optimal performance. Note that by default MariaDB is configured to work on a desktop system and should because of this not take a lot of resources. To get things to work for a dedicated server, you have to do a few minutes of work. For this article we assume that you are going to run MariaDB on a dedicated server. Note that this article is not yet complete. Please update this if you have more ideas! MariaDB is normally configured by editing the my.cnf ... Read More

Feed: MariaDB Knowledge Base Article Feed Author: Contents Comparison table See also The following is a comparison of variables that either appear only in MariaDB 10.2 or MySQL 5.7, or have different default settings in MariaDB 10.2, and MySQL 5.7. MariaDB 10.2.1 and MySQL 5.7.13, with only default plugins enabled, were used for the comparison. MariaDB 10.2 is still an alpha release, so new features are regularly being added and this article will update regularly. The most notable differences are that MariaDB includes, by default, the Aria storage engine (resulting in extra memory allocation), Galera Cluster, uses Percona's XtraDB instead ... Read More

Feed: MariaDB Knowledge Base Article Feed Author: Syntax int mariadb_stmt_execute_direct(MYSQL_STMT * stmt, const char *query, size_t length); stmt - A statement handle, which was previously allocated by mysql_stmt_init(). query SQL statement length Length of SQL statement Description Prepares and executes a statement which was previously allocated by mysql_stmt_init(), using the current values of the parameter variables if any parameters exist in the statement. Returns zero on success, non-zero on failure. This function was added in Connector/C 3.0 and requires MariaDB 10.2 or later versions. Since the number of parameter of the statement is unknown before execution it is mandatory to ... Read More

Feed: MariaDB Knowledge Base Article Feed Author: These topics will be discussed in more detail below. Dear Schema Designer: InnoDB only, always have PK. Dear Developer: Check for errors, even after COMMIT. Moderate sized transactions. Don't make assumptions about AUTO_INCREMENT values. Handling of "critical reads" is quite different (arguably better). Read/Write split is not necessary, but is still advised in case the underlying structure changes in the future. Dear DBA: Building the machines is quite different. (Not covered here) ALTERs are handled differently. TRIGGERs and EVENTs may need checking. Tricks in replication (eg, BLACKHOLE) may not work. Several variables need ... Read More

Feed: Planet MySQL Author: Justin Swanhart It was suggested by Monty that the posts I've made about MariaDB are for publicity. This simply isn't true. I would have much preferred a different outcome in my interactions with MariaDB. I figured that they would end up giving me a hard time, and I'd be stubborn and we'd both hate each other for as long as I could keep from leaving. A quick separation actually seems much better in such context. Regardless, I would have preferred to speak amicably to the MariaDB Corporation about switching the license back, or at least moving ... Read More

Feed: Planet MySQL Author: Justin Swanhart It was suggested by Monty that the posts I've made about MariaDB are for publicity. This simply isn't true. I would have much preferred a different outcome in my interactions with MariaDB. I figured that they would end up giving me a hard time, and I'd be stubborn and we'd both hate each other for as long as I could keep from leaving. A quick separation actually seems much better in such context. Regardless, I would have preferred to speak amicably to the MariaDB Corporation about switching the license back, or at least moving ... Read More