October 2016 - discuss - lists.mariadb.org

Re: [Maria-discuss] MariaDB Server 10.3 notes
by Justin Swanhart 12 Oct '16

12 Oct '16

Hi Sergei! I moved this back to the mailing list, because of your .FRM explanation, and also because I'd like to explain rasters. A GIS raster is an array of data represented as a raster image. Rasters have "layers" and each layer can have a different measurement in it. It is most commonly used for height maps. The pgsql schema that I sent you is for a personal project of mine that uses Voxel.js (http://voxeljs.com/) to turn real world height maps from the space shuttle (SRTM v3 data) into interpolated 1 meter resolution voxel (minecraft-like, as 1 block = 1 sq meter) landscapes. I intersect the raster data with the GIS data from OSM (open street map) so that I can render buildings, roads, forest areas, rivers, etc, somewhat correctly (overpasses, underhangs, and missing building heights cause significant problems.). The ST_PixelsAsCentroids or ST_PixelsAsPoints can be used to get the specific value for a band in the raster, such as the height in a specific 30sq meter area (for the 1 arcsecond resolution of the SRTM data). I could never do such a thing in MySQL, and that makes me sad :( On Wed, Oct 12, 2016 at 9:34 AM, Sergei Golubchik <serg(a)mariadb.org> wrote: > Hi, Justin! > > On Oct 12, Justin Swanhart wrote: > > > > Regarding SET PERSIST, yes, it has dangers. One of them would be to > > set the buffer pool too large, so I filed a MySQL FR to set the BP to > > the default size if the malloc fails. It can be increased dynamically > > later. But there are many changes that could cause problems. This > > feature has to be managed carefully. Then again, Oracle RDBMS has had > > pfile configuration for well over a decade, and it is functionally > > equivalent to a binary my.cnf in the data dir. > > Right. Personally I fully expect that we will need to suport SET PERSIST > eventually. It's just so convenient. I only said it needs some very > careful thinking - and I was responsible for security(a)mysql.com for ten > years and now for security(a)mariadb.org for six, so I am a bit paranoid > about this :) > > > re: GIS, well, gdal and proj are used by almost every application > > that deals with GIS. What does the extra accuracy get you? Anyway, > > rasters really aren't useful without table functions, as you can't get > > the data from each point without them. > > I don't really know what rasters are. > > And I do not actually *use* GIS, so may be extra accuracy is not useful. > I'd think it might be particularly important for functions like > ST_TOUCHES(). > > I really want MariaDB to have table functions - perhaps we will have > them in 10.3. > > > Some more questions: > > Even though .FRM are optional, that still doesn't necessarily make DDL > > changes atomic, does it? > > If the engine declares FRM optional, then the whole DDL is happening > inside the engine, and it's up to the engine to make it atomic. I > expect that when we'll make FRMs optional for InnoDB, InnoDB DDLs > will be atomic. > > Regards, > Sergei > Chief Architect MariaDB > and security(a)mariadb.org >

1 0

[Maria-discuss] (/usr/include/mysql and libmysqlclient) vs (/usr/include/mariadb libmariadbclient and libmariadb)
by james harvey 11 Oct '16

11 Oct '16

First, let me clarify everything here is MariaDB - nothing actually involving the MySQL code. In Arch Linux, I'm running a MariaDB server and client. I installed the mariadb package, built from the source at: http://ftp.heanet.ie/mirrors/mariadb/mariadb-10.1.18/source/mariadb-10.1.18… This provides: - /usr/include/mysql/* (141 .h files) - /usr/lib/libmysqlclient.so - /usr/lib/libmysqld.so (I see this is for embedding a MariaDB server in an application which I don't need, so I'll ignore that for the rest of my message.) I have C++ applications that will access MariaDB, and I thought I also needed mariadb-connector-c, so I built tag v2.3.1 at https://github.com/MariaDB/mariadb-connector-c This provides: - /usr/include/mariadb/* (40 .h files) - /usr/lib/mariadb/libmariadbclient.a - /usr/lib/mariadb/libmariadb.so Q1 - What's the purpose and difference between libmysqlclient, libmariadbclient, and libmariadb? (Ignoring difference shared vs static library.) Q2 - /usr/include/mysql/mysql.h (from http://ftp.heanet.ie/mirrors/mariadb/mariadb-10.1.18/source/mariadb-10.1.18…) and /usr/include/mariadb/mysql.h (from tag v2.3.1 at from https://github.com/MariaDB/mariadb-connector-c) Are quite similar and have a lot of identical code, but are also way different. I ran into that /usr/include/mysql/mysql.h defines: const char * STDCALL mysql_error(MYSQL * myql); But /usr/include/mariadb/mysql.h defines: char * STDCALL mysql_error(MYSQL *mysql); (Note the missing const on the return value.) I got very confused at this point why the same function is declared in each, why they're different, which I should be using, etc.

2 1

[Maria-discuss] Notes from the session MariaDB Foundation priorities
by Colin Charles 08 Oct '16

08 Oct '16

Hi! These notes were from the last session on Friday, 7 October, at the MariaDB Server Developers meeting in Amsterdam at the Booking.com office, headed by Eric Herman, Board Member of the MariaDB Foundation # MariaDB Foundation priorities ## Goal: foster collaboration 1. Product should be called MariaDB Server (MariaDB is the company, since MariaDB Corporation owns the trademark) * needs some copyediting on the MariaDB Foundation website that needs editing 2. the MariaDB Foundation board majority shouldn't be from MariaDB Corporation. Expect that to be fixed within a week, at least 50:50 -- Monty. Is there a community board member? Monty says Serg, but JF/Eric says this is a conflict of interest. Is there a path for community governance? Serg represents the developers. Board selects its own members, says Otto, and there can be a maximum of 10 board members. Now they will think about a community member. 3. The documentation is on mariadb.com (the The MariaDB Knowledge Base: https://mariadb.com/kb/en/) Monty says the documentation is going to stay on mariadb.com. It is a barrier to contribution, according to Eric. Serg says MariaDB Foundation finds this a priority and is working on it. 4. Twitter/FB accounts are owned by MariaDB Corporation - so there will be a new one created for the MariaDB Foundation / MariaDB Server. The Corporation is going to keep @mariadb 5. Jira says it's licensed to MariaDB Corporation. ## Goal: Priorities for code 1. Steward patches through the integration process 2. Personal engagement when it comes to you asking about patches, features, etc. in Jira or list 3. One MariaDB Server release a year, and Serg stewards that 4. The MariaDB Foundation does not do any paid for work! 5. Security, porting, and packaging is a priority of the MariaDB Foundation (e.g. getting the MariaDB Server to work with clang is important) ## Booking's goal: easy to upgrade/cross-grade between distributions of MySQL/MariaDB Server * Eric says that interoperability is a big deal for Booking * Monty says, all members in the MariaDB Foundation have different priorities, but if it's important for Booking, the MariaDB Foundation will focus on it. Maximum increased MariaDB Server usage - this means the mission statement suggests that there must be interoperability. * JF says, Jira is not supported on MariaDB Server (certified with MySQL 5.6). Increasing adoption will happen if more applications can run with MariaDB Server. * Monty says, MySQL 5.6, should be comparable to MariaDB Server 10.1. And for 10.2 it should be compatible with MySQL 5.7. ## Transparency * Transparency during the development process and technical decision making - Vicentiu thinks we can do better, because a lot of decisions are happening on private channels * The Oracle compat work, it is a project from MariaDB Corporation, and it will be donated to the MariaDB Foundation * Vicentiu says that most of the talk about bugs happen on the MariaDB Corporation Slack channel. Serg says that no one would read them anyway. Monty agrees that having all discussions on server engineering should be on public IRC/lists. Increases transparency but maybe doesn't lower the barrier to participate, says Otto. * (Contributor who’s name I didn’t catch) PostgreSQL does all their discussions on public mailing lists and it really helps. -- Colin Charles, http://bytebot.net/blog/ twitter: @bytebot | skype: colincharles "First they ignore you, then they laugh at you, then they fight you, then you win." -- Mohandas Gandhi

2 1

[Maria-discuss] sharding with mariadb?
by l vic 07 Oct '16

07 Oct '16

I wonder how to use sharding with symmetric replication... Does that mean I have to partition every database instance? Does it work with third-party tools, like Vitess (http://vitess.io/)? Thanks

4 7

[Maria-discuss] Expected release of 10.0.28
by Rhys.Campbell＠swisscom.com 06 Oct '16

06 Oct '16

Hi All, Do we have any estimation of the release of 10.0.28? Regards, Rhys

3 2

[Maria-discuss] thank you -> myrocks in mariadb
by MARK CALLAGHAN 06 Oct '16

06 Oct '16

MyRocks is coming to MariaDB. I think this is great news for MyRocks and the MariaDB community. Thank you. https://jira.mariadb.org/browse/MDEV-9658 -- Mark Callaghan mdcallag(a)gmail.com

1 0

[Maria-discuss] possible full-stack idea
by Mark Edwards 04 Oct '16

04 Oct '16

hello - i just joined this list and i apologize in advance if this is not the proper way to ask this question. recently i have had success combining deepstream and sequelize against a JSON column to allow for CRUD functionality in a browser with surprisingly very little code. my hope is to include something like vue, matreshka or even express to have full-stack functionality. before proceeding any further, i thought i should solicit a few opinions on this. currently i have a crude working prototype on github. please let me know any thoughts, concerns or questions before i proceed. Thank you, Mark Edwards

1 0