Tag Archives: mysql
Here’s another MariaDB screencast, this time highlighting some of the GIS functionality in MariaDB.
httpv://www.youtube.com/watch?v=LpDm_8L1oyI
(I recommend watching it in full screen 720p, so you can see the details.)
Some links and notes:
- GIS Functionality in MariaDB
- Data used in this screencast
- OpenJUMP
- JUMP database plugin
- To use the database plugin, unpack it into the OpenJUMP lib/ext/ directory (not a subdirectory, but directly into that directory). Also place the mysql-connector-java.jar into the lib/ext/ directory.
Acknowledgments:
A big thanks to Alexey Botchkov, MariaDB’s GIS guru, for the example data and help with the screencast. …
Following closely on the heels of the MariaDB 5.3.4-rc release a couple of weeks ago, the MariaDB project is pleased to announce the immediate availability of MariaDB 5.3.5!
MariaDB 5.3.5 is the first stable (GA) release in the 5.3 series. Details and downloads are available from the following links:
(Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator is available.)
About MariaDB 5.3
The MariaDB 5.3 series introduces many new features, includes MariaDB
5.2, and is based on MariaDB 5.1 & …
We are pleased to announce the immediate availability of MariaDB 5.5.20-alpha. MariaDB 5.5.20 is the first Alpha release in the 5.5 series. We hope to follow it up soon with a beta 5.5 release.
MariaDB 5.5.20-alpha is a merge of MariaDB 5.3 and MySQL 5.5 with some limited additional bug fixes. This is the first 5.5-based release, and we are releasing it now, intentionally without any extra features (and with it missing some planned features) to get it into the hands of any who might want to test it. Extra features planned for MariaDB 5.5 will be pushed into future releases. …
Instead of the usual text-heavy blog posts that appear here, I thought it would be fun to mix things up and do a screencast showing exactly how easy it is to upgrade MySQL to MariaDB:
httpv://www.youtube.com/watch?v=rF7wChx0uzQ
Some notes:
- The laptop I’m using had MySQL 5.1.55 installed with one database (apart from the system database). Installing MariaDB does not impact existing data in any way and once the install completed I had instant access to my data.
- As part of the install you are given the option to set a new password for the root user.
…
Parts of the world are already celebrating Christmas Eve and it’s time to relax and spend time with family and friends. Even if you don’t celebrate Christmas this is when there is time for less work. Here are a few words to round off MariaDB’s current state and where it’s heading.
This year culminated in MariaDB 5.3.3, the release candidate of 5.3. This is a significant release that makes years of work available by default in the database server. Earlier releases still required features to be explicitly switched on, but thanks to thorough testing assuring the quality of the new functionality we have now enabled them. …
We have lately been talking about some upcoming features that we feel are important to MariaDB users, because the corresponding ones that will be provided with MySQL will be incompatible with MariaDB and closed source.
We’re happy to announce the following:
- The next version of MariaDB, version 5.2.10 will include an open source PAM Authentication Plugin. MariaDB 5.2.10 is scheduled for release next week.
- A Windows Authentication Plugin is in development and QA currently and will be part of MariaDB 5.2.11, which is scheduled for release before Christmas.
- MariaDB 5.5 will include both of the above plugins and an open source thread pool implementation.
…
As you may know, since version 5.2.0 (released in April 2010) we support Pluggable Authentication. Using this feature one can implement an arbitrary user authentication and account management policy, completely replacing built-in MariaDB authentication with its username/password combination and mysql.user table.
Also, as you might have heard, Oracle has recently released a PAM authentication plugin for MySQL. Alas, this plugin will not run on MariaDB — although the MySQL implementation of pluggable authentication is based on ours, the API is incompatible. And, being closed source, this plugin cannot be fixed to run in MariaDB. And — I’m not making it up — this plugin does not support communication between the client and the server, so even with this plugin and all the power of PAM the only possible authentication method remains a simple username/password combination. …
Continue reading “Writing a MariaDB PAM Authentication Plugin”
For many years I was using tcsh, with lots of useful customizations, that were created during these years. Now I have bash on my laptop and slowly adding what I’ve got used to.
Yesterday I’ve created command line completion rules for mysql-test-run. It’s not a complete set of everything that’s possible, still it’s quite useful as it is. I need to type much less now when invoking mysql-test-run (and I invoke it quite a lot).
(more…) …