- discuss - lists.mariadb.org

Re: [Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 27 Mar '12

27 Mar '12

Hi Colin, I actually get a little farther along (83% instead of 77%), but it looks like we're failing at the same spot -- Linking CXX executable ma_pagecache_consist_1k-t [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_control_file-t.dir/ma_control_file-t.c.o Linking CXX executable ma_control_file-t [ 83%] Built target ma_control_file-t Scanning dependencies of target ma_pagecache_consist_1k-t [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/ma_pagecache_consist.c.o [ 83%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/test_file.c.o Linking CXX executable ma_pagecache_consist_1k-t Undefined symbols for architecture x86_64: "_key_PAGECACHE_cache_lock", referenced from: _init_pagecache in libaria.a(ma_pagecache.c.o) ld: symbol(s) not found for architecture x86_64 collect2: ld returned 1 exit status make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1k-t] Error 1 make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1k-t.dir/all] Error 2 make: *** [all] Error 2 Richard On Mar 27, 2012, at 04:52 , Colin Charles wrote: > Hi! > > On 17 Mar 2012, at 19:21, Richard Dunn wrote: > >> Same problem with MariaDB 5.5.21... >> > > Is this what you see currently? Produced this using 5.5.21 using BUILD/compile-pentium64-max > > [ 77%] Building C object storage/maria/unittest/CMakeFiles/ma_pagecache_consist_64k-t.dir/test_file.c.o > Linking CXX executable ma_pagecache_consist_1kRD-t > Linking CXX executable ma_pagecache_consist_1kWR-t > Undefined symbols for architecture x86_64: > "_key_PAGECACHE_cache_lock", referenced from: > _init_pagecache in libaria.a(ma_pagecache.c.o) > ld: symbol(s) not found for architecture x86_64 > collect2: ld returned 1 exit status > Undefined symbols for architecture x86_64: > "_key_PAGECACHE_cache_lock", referenced from: > _init_pagecache in libaria.a(ma_pagecache.c.o) > ld: symbol(s) not found for architecture x86_64 > collect2: ld returned 1 exit status > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1kRD-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1kRD-t.dir/all] Error 2 > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_1kWR-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_1kWR-t.dir/all] Error 2 > Linking CXX executable ma_pagecache_consist_64k-t > Undefined symbols for architecture x86_64: > "_key_PAGECACHE_cache_lock", referenced from: > _init_pagecache in libaria.a(ma_pagecache.c.o) > ld: symbol(s) not found for architecture x86_64 > collect2: ld returned 1 exit status > make[2]: *** [storage/maria/unittest/ma_pagecache_consist_64k-t] Error 1 > make[1]: *** [storage/maria/unittest/CMakeFiles/ma_pagecache_consist_64k-t.dir/all] Error 2 > [ 88%] Built target sql > make: *** [all] Error 2 > > >> >> On Mar 4, 2012, at 07:53 , Richard Dunn wrote: >> >>> I've been compiling MySQL and MariaDB on OS X for quite some time now, but this is the first time that I have ever used CMake to build an application. The 'make' step consistently fails with the following: >>> >>> Linking CXX executable ma_pagecache_consist_1k-t >>> Undefined symbols for architecture x86_64: >>> "_key_PAGECACHE_cache_lock", referenced from: >>> _init_pagecache in libaria.a(ma_pagecache.c.o) >>> ld: symbol(s) not found for architecture x86_64 >>> >>> I assume libaria.a is Maria specific. >>> >>> As a sanity check, I downloaded the MySQL source code for 5.5.21 from the MySQL site and I successfully compiled everything with CMake. >>> >>> Has anyone else successfully compiled a 64 bit 5.5.20 MariaDB on OS X? What am I missing? >> >> >> _______________________________________________ >> Mailing list: https://launchpad.net/~maria-discuss >> Post to : maria-discuss(a)lists.launchpad.net >> Unsubscribe : https://launchpad.net/~maria-discuss >> More help : https://help.launchpad.net/ListHelp > > -- > Colin Charles, http://bytebot.net/blog/ | twitter: @bytebot | skype: colincharles > MariaDB: Community developed. Feature enhanced. Backward compatible. > Download it at: http://www.mariadb.org/ > Open MariaDB/MySQL documentation at the Knowledgebase: http://kb.askmonty.org/ >

1 0

Re: [Maria-discuss] Compiling 5.5.20 on OS X
by Richard Dunn 27 Mar '12

27 Mar '12

Hi Sergei, The build log is attached. Thanks for your help! Richard On Mar 26, 2012, at 12:25 , Sergei Golubchik wrote: > Hi, Richard! > > I don't have an OS X build environment at the moment. > I'll try to help you and fix that, but I'll be asking a lot of > questions. Sorry for this. > > On Mar 04, Richard Dunn wrote: >> I've been compiling MySQL and MariaDB on OS X for quite some time now, >> but this is the first time that I have ever used CMake to build an >> application. The 'make' step consistently fails with the following: >> >> Linking CXX executable ma_pagecache_consist_1k-t >> Undefined symbols for architecture x86_64: >> "_key_PAGECACHE_cache_lock", referenced from: >> _init_pagecache in libaria.a(ma_pagecache.c.o) >> ld: symbol(s) not found for architecture x86_64 >> >> I assume libaria.a is Maria specific. > > Can you show the complete build log? > To collect it you can run "make VERBOSE=1 -k >& log". > The file might be quite big, don't forget to gzip it before emailing. > > Regards, > Sergei

1 0

[Maria-discuss] New KB Question: Maximum number of indexes supported by Xtradb
by Daniel Bartholomew 27 Mar '12

27 Mar '12

A new question has been posted to the Knowledgebase: http://kb.askmonty.org/en/maximum-number-of-indexes-supported-by-xtradb ----------------------------------------------------------------------- What is the maximum number of indexes allowed per-table when using the Xtradb storage engine? ----------------------------------------------------------------------- Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] Wrong ordering in MariaDB 5.2.10
by Brian Evans 16 Mar '12

16 Mar '12

We are hitting a wrong ordering in 5.2.10 but it does not happen on a test box using 5.3 series (tried 5.3.3 and 5.3.5). The query can be rewritten and when we do, the range becomes an index scan and produces the correct results. Here are the queries: [Incorrect Order] SELECT SUBSTRING(StockNo, 3, 3) AS $number FROM inv WHERE StockNo LIKE 'JR%' OR StockNo LIKE 'VS%' OR StockNo LIKE 'JB%' OR StockNo LIKE 'JG%' ORDER BY $number DESC LIMIT 1; EXPLAIN Result id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE inv range PRIMARY PRIMARY 66 (NULL) 4 Using where; Using index; Using filesort [Correct Order] SELECT SUBSTRING(StockNo, 3, 3) AS $number FROM inv WHERE LEFT(StockNo,2) IN('JR','VS','JB','JG') ORDER BY $number DESC LIMIT 1; *EXPLAIN Result* id select_type table type possible_keys key key_len ref rows Extra 1 SIMPLE inv index (NULL) PRIMARY 66 (NULL) 2496 Using where; Using index; Using filesort Simplified Table Structure: CREATE TABLE `tableinventory` ( `StockNo` varchar(64) NOT NULL DEFAULT '', `ItemDesc` varchar(96) NOT NULL DEFAULT '', PRIMARY KEY (`StockNo`) ) ENGINE=PBXT DEFAULT CHARSET=latin1; All data is using a length of 7 even though it is defined as varchar(64).

2 5

[Maria-discuss] New KB question: Embedded engine?
by Daniel Bartholomew 01 Mar '12

01 Mar '12

A new question has been posted in the Knowledgebase: https://kb.askmonty.org/en/embedded-engine +++++++++++++++++++++++++++++++++++ Hi all, Is there an embedded version of MariaDB? If the answer is yes, then is it possible to connect to it using JDBC (this works for the Firebird embedded server)? TIA and rgs, Paul... +++++++++++++++++++++++++++++++++++ Thanks. -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.3.5 now available!
by Daniel Bartholomew 29 Feb '12

29 Feb '12

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. --- MariaDB 5.3.5 Release Notes, Changelog, Downloads ----------------- The release notes are available at: http://kb.askmonty.org/en/mariadb-535-release-notes A changelog is available at: http://kb.askmonty.org/en/mariadb-535-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.3.5/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ --- About MariaDB 5.3 ------------------------------------------------- The MariaDB 5.3 series introduces many new features, includes MariaDB 5.2, and is based on MariaDB 5.1 & MySQL 5.1. Some highlights of new features in MariaDB 5.3 include: - subquery optimizations that finally make subqueries usable - many optimizer changes, including Classic Hash Join, Batched Key Access, a new implementation of Multi-Range-Read optimizations as well as Index Condition Pushdown - NoSQL-style interfaces via the HandlerSocket plugin as well as dynamic columns - group commit in XtraDB when the binary log is enabled - Microsoft Windows performance improvements These are just some of the highlights, and for a more complete list of changes, please read the What is MariaDB 5.3 page: http://kb.askmonty.org/en/what-is-mariadb-53 --- SkySQL and MariaDB: Solutions Day --------------------------------- We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day– a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. --- 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 --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. --- MariaDB Crash Course book ----------------------------------------- We would also like to mention the book "MariaDB Crash Course", by Ben Forta. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ --- Quality ----------------------------------------------------------- The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

[Maria-discuss] MariaDB 5.5.20-alpha now available
by Daniel Bartholomew 27 Feb '12

27 Feb '12

The MariaDB project is 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 subsequent releases. **Do not use alpha releases on production systems.** == MariaDB 5.5.20-alpha Release Notes, Changelog, Downloads =========== The release notes for MariaDB 5.5.20-alpha are available at: http://kb.askmonty.org/en/mariadb-5520-release-notes A changelog for this release is available at: http://kb.askmonty.org/en/mariadb-5520-changelog Sources, binaries and packages can be downloaded from: http://downloads.askmonty.org/mariadb/5.5.20/ Debian and Ubuntu packages are available from our mirrored apt repositories. A sources.list generator can be found at: http://downloads.askmonty.org/mariadb/repositories/ == About MariaDB 5.5 ================================================== The MariaDB 5.5 series is the combination of MariaDB 5.3 and MySQL 5.5. Please read the "What is MariaDB 5.5" page for details: http://kb.askmonty.org/en/what-is-mariadb-55 == SkySQL and MariaDB: Solutions Day ================================== We'll be co-hosting the the "SkySQL & MariaDB: Solutions Day for the MySQL® Database" one day event on 13 April, 2012, at the Hyatt Regency Santa Clara. During this event, attendees will receive free, hands-on training and consulting on MariaDB and MySQL® database solutions from the experts at SkySQL, MariaDB, Continuent, ScaleDB, Severalnines, Sphinx, and Webyog, among others. SkySQL and MariaDB will bring together industry visionaries, including Michael (Monty) Widenius and David Axmark, the original authors of the MySQL database, to share their insights on current and future trends pertaining to the world's most popular open source database. To learn more about this free event, visit http://www.skysql.com/events/mysql-solutions-day The schedule for the event is here: http://www.skysql.com/events/mysql-solutions-day/schedule Attendees are also invited to participate in Drizzle Day– a parallel event co-hosted by SkySQL, Percona, and the Drizzle Development Team, featuring tutorials on the Drizzle database. == 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 --plugin-load=feedback.so to your my.cnf file! On Windows, add "feedback=ON" to your my.ini file, or click the checkbox during the installation of the MSI package. See http://kb.askmonty.org/en/user-feedback-plugin for more information. == MariaDB Crash Course book ========================================== We would also like to mention the book "MariaDB Crash Course", by Ben Forta. This book - for beginner to intermediate level users - will get you up and running with MariaDB, even if you've never used a database before. More information is available at: http://forta.com/books/0321799941/ == Quality ============================================================ The project always strives for quality, but in reality, nothing is perfect. Please take time to report any issues you encounter at: https://bugs.launchpad.net/maria We hope you enjoy MariaDB! -- Daniel Bartholomew MariaDB - http://mariadb.org Monty Program - http://montyprogram.com AskMonty Knowledgebase - http://kb.askmonty.org

1 0

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Alex Esterkin 21 Feb '12

21 Feb '12

As an end user, I would most strongly dislike this. You clearly don't understand how corporate users think and operate, how they work with open source technologies, and how they plan and evolve their technical roadmaps. Last year Ubuntu inflicted enough damage on itself by messing up with UI and display management. Replacing OpenOffice with LibreOffice was not a success story either. A year ago I had plans to migrate my remaining CentOS and Debian servers and test environments to Ubuntu and I recommended using Ubuntu for a couple of server appliance products we had in the works. These plans were revisited and revised in the fall, based on revised Linux distro release and roadmap assessment. As far as MySQL is concerned, I don't care at this point what your Ubuntu server distro plans are, as I have already migrated away from Ubuntu. However, if the discussion about replacing MySQL also spreads into the Fedora Project and CentOS communities, that would give me a very good reason for migrating/porting MySQL apps and products to Postgres. Regards, Alex Esterkin, Former Chief Architect, Infobright On Tue, Feb 7, 2012 at 04:37, Clint Byrum <clint(a)ubuntu.com> wrote: > Many of us in the Free and Open Source software community have seen a > trend regarding Oracle's stewardship of Open source software that it > inherited when it purchased Sun. In particular there were two fairly > large public project blow ups that resulted in OpenOffice splintering, > and the Hudson community (almost?) completely moving to an independent > fork called Jenkins. > > It has been brought to my attention that MySQL may have gone this way > as well, but in a much more subtle way. This started about a year ago, > and has only recently really become obvious. > > A few notable fellows from the MySQL ecosystem have commented: > > Mark Callaghan > http://mysqlha.blogspot.com/2011/02/where-have-bugs-gone.html > (read the comments on this one, very informative, and most of the > commenters are extremely important non-Oracle members of the MySQL > community) > > http://mysqlha.blogspot.com/2011/11/great-work-bug-12704861-was-fixed.html > > Stewart Smith: > http://www.mysqlperformanceblog.com/2011/11/20/bug12704861/ > > And the CVE's are extremely vague: > > http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0119 > > "Unspecified vulnerability in the MySQL Server component in Oracle MySQL > 5.1.x and 5.5.x allows remote authenticated users to affect availability > via unknown vectors" > > Links to here: > > http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html > > Which links to here: > > http://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1390289.1 > > Which requires an account (which I created). I did try to login but got > some kind of failure.. > > "Failure of server APACHE bridge:". > > The bzr commits for the latest MySQL releases also reference log bug#'s > that are thought to belong to the private oracle support system, not > accessible to non-paying customers. > > This is all very troubling, as in a Linux distribution, we must be able > to support our users and track upstream development. > > So what should we, the Debian and Ubuntu MySQL maintainers and users, > do about this? > > Well there is a Jenkins to MySQL's Hudson, a LibreOffice to their > OpenOffice. > > MariaDB 5.3, in release-candidate now, is 100% backward compatible with > MySQL 5.1. It also includes a few speedups and features that can be found > in MySQL 5.5 and Percona Server. It is developed 100% in the open, on > launchpad.net, including a public bug tracker and up to date bzr trees > of the code. > > http://mariadb.org > https://launchpad.net/maria > > I'm writing to the greater Debian and Ubuntu community to ask for your > thoughts on a proposal to drop MySQL in favor of MariaDB. Its clear to > me that Oracle is not going to do work in the open, and this will become > a huge support burden for Linux distributions. The recent CVE's had to > be hunted down and investigated at great difficulty to several people, > since the KB articles referenced and the internal Oracle bug numbers > referenced were not available. > > This will only get harder as the community bug tracker gets further out > of sync with the private one. > > There is some need to consider acting quickly: > > Ubuntu precise, the next LTS release of Ubuntu will be hitting feature > freeze on Feb. 16. The release, due in April, will be supported with > security updates for 5 years. That may be 5 long years of support if > MySQL continues to obscure things. > > Debian wheezy is still quite far off, but it is critical that this be > done and decided by the time the release freeze begins. > > So, here is a suggested plan, given the facts above: > > * Upload mariadb 5.3 to Debian experimental, with it providing > mysql-server, mysql-client, and libmysqlclient-dev. > > * For Ubuntu users, upload these packages to a PPA for testing > applications for compatibility, and rebuild testing. > > * If testing goes well, replace mysql-5.5 with mariadb in both Debian > unstable and Ubuntu precise. If there are reservations about switching > this late in precise's cycle, ship mysql-5.5 in precise, and push off > Ubuntu's transition until the next cycle. > > Before I strike out on this path alone, which, I understand, may sound > a bit radical, I want to hear what you all think. > > Thank you for your time and consideration. > > -- > Clint Byrum <clint(a)ubuntu.com> > Ubuntu Server Team > Debian MySQL Packaging Team >

7 8

[Maria-discuss] MySQL's future in Debian and Ubuntu
by Clint Byrum 17 Feb '12

17 Feb '12

Many of us in the Free and Open Source software community have seen a trend regarding Oracle's stewardship of Open source software that it inherited when it purchased Sun. In particular there were two fairly large public project blow ups that resulted in OpenOffice splintering, and the Hudson community (almost?) completely moving to an independent fork called Jenkins. It has been brought to my attention that MySQL may have gone this way as well, but in a much more subtle way. This started about a year ago, and has only recently really become obvious. A few notable fellows from the MySQL ecosystem have commented: Mark Callaghan http://mysqlha.blogspot.com/2011/02/where-have-bugs-gone.html (read the comments on this one, very informative, and most of the commenters are extremely important non-Oracle members of the MySQL community) http://mysqlha.blogspot.com/2011/11/great-work-bug-12704861-was-fixed.html Stewart Smith: http://www.mysqlperformanceblog.com/2011/11/20/bug12704861/ And the CVE's are extremely vague: http://cve.mitre.org/cgi-bin/cvename.cgi?name=CVE-2012-0119 "Unspecified vulnerability in the MySQL Server component in Oracle MySQL 5.1.x and 5.5.x allows remote authenticated users to affect availability via unknown vectors" Links to here: http://www.oracle.com/technetwork/topics/security/cpujan2012-366304.html Which links to here: http://support.oracle.com/CSP/main/article?cmd=show&type=NOT&id=1390289.1 Which requires an account (which I created). I did try to login but got some kind of failure.. "Failure of server APACHE bridge:". The bzr commits for the latest MySQL releases also reference log bug#'s that are thought to belong to the private oracle support system, not accessible to non-paying customers. This is all very troubling, as in a Linux distribution, we must be able to support our users and track upstream development. So what should we, the Debian and Ubuntu MySQL maintainers and users, do about this? Well there is a Jenkins to MySQL's Hudson, a LibreOffice to their OpenOffice. MariaDB 5.3, in release-candidate now, is 100% backward compatible with MySQL 5.1. It also includes a few speedups and features that can be found in MySQL 5.5 and Percona Server. It is developed 100% in the open, on launchpad.net, including a public bug tracker and up to date bzr trees of the code. http://mariadb.org https://launchpad.net/maria I'm writing to the greater Debian and Ubuntu community to ask for your thoughts on a proposal to drop MySQL in favor of MariaDB. Its clear to me that Oracle is not going to do work in the open, and this will become a huge support burden for Linux distributions. The recent CVE's had to be hunted down and investigated at great difficulty to several people, since the KB articles referenced and the internal Oracle bug numbers referenced were not available. This will only get harder as the community bug tracker gets further out of sync with the private one. There is some need to consider acting quickly: Ubuntu precise, the next LTS release of Ubuntu will be hitting feature freeze on Feb. 16. The release, due in April, will be supported with security updates for 5 years. That may be 5 long years of support if MySQL continues to obscure things. Debian wheezy is still quite far off, but it is critical that this be done and decided by the time the release freeze begins. So, here is a suggested plan, given the facts above: * Upload mariadb 5.3 to Debian experimental, with it providing mysql-server, mysql-client, and libmysqlclient-dev. * For Ubuntu users, upload these packages to a PPA for testing applications for compatibility, and rebuild testing. * If testing goes well, replace mysql-5.5 with mariadb in both Debian unstable and Ubuntu precise. If there are reservations about switching this late in precise's cycle, ship mysql-5.5 in precise, and push off Ubuntu's transition until the next cycle. Before I strike out on this path alone, which, I understand, may sound a bit radical, I want to hear what you all think. Thank you for your time and consideration.

10 16

Re: [Maria-discuss] MySQL's future in Debian and Ubuntu
by Pandu Poluan 17 Feb '12

17 Feb '12

On Feb 13, 2012 2:21 PM, "Eddie Bachle" <enb10(a)albion.edu> wrote: > > In general, I am generally an simply an observer on most of these mailing lists, however my concerns with a switch are far less technical and far more practical. I work currently for a college in Michigan which utilizes almost solely Windows servers simply because it is what the IT staff here knows. As a student here, I was brought in to assist with the web server administration, and as time went by because I have a degree of Linux knowledge, I was given permission to put together a Ubuntu LAMP server to serve a couple of interested parties on campus who wanted simply to demo several small scale web apps that were Linux exclusive. This server would serve as an exception to the general rule of our server architecture. However as time has went by and my knowledge looks more like it will be a fixture here after graduation, along with the simple instability of PHP and Apache on the Windows platform, my boss is giving far more consideration to moving to Linux. > > As Linux gains more public recognition, more and more Windows-only organizations will consider using it as an alternative, especially for their web servers. This is especially true because of the fact that each of the necessarily main components of a web server exist in Linux in the same form as the do on Windows and often run much better. Then, the only piece one would need to learn would be the new operating system, not the database, HTTP server, or PHP scripting language software. However, this is going to be a more difficult proposition if the aforementioned advantage is somewhat eliminated. Were I to have to tell my boss that we could switch to Ubuntu but it would mean that would need to use a "MySQL compatible" database if we want to use the native database (which we likely would because it's tested to be stable and it is supported by the developers), then she would be much more hesitant. > > There simply is a much greater sense of trepidation for those who are not significantly Linux savvy if there exists a possibility that they would have to make something work in an unfamiliar environment, especially if it were to happen unexpectedly. If we ported our www website server over to Ubuntu and then 6 months down the road we were to upgrade our Joomla version and there became an issue with MariaDB because it lacks some MySQL feature that it needs, or even that Joomla would fail to recognize Maria as being equivalent to MySQL at some point, then that would be a huge detraction against switching. > > Unless assurances that any software that asks for MySQL will recognize and accept MariaDB equivalents, and that this should always be the case, and that it will retain the stability and recognized benefits of MySQL, I would encourage extreme caution in encouraging a switch. Linux is beginning to grow into areas it previously didn't reach and bringing a far superior web server experience as well as simply a better operating system experience for many and I would not like to see that growth compromised. I would like to say we would still switch, or still heavily consider it for the grains that could be made by using Ubuntu, however realistically, the lack of native MySQL in any OS would be a huge mark against it. Also that being said, if the technical concerns are answered adequately for a vast majority of applications and hardware/OS setups, then I would be totally behind switching to a more open source friendly and compatible database software as there would be little love lost between me and MySQL. > > I hope this perspective helps a bit in considering this decision, > Do remember that there's an alternative to MySQL/MariaDB: PostgreSQL. I'm actually busy migrating the Windows infrastructure, and my target database is PostgreSQL. Note: I am *not* recommending that Ubuntu replaced its default database from MySQL to PostgreSQL; If a company already deployed a MySQL-based app, then it should migrate to MariaDB, if only to prevent being trapped by Oracle into migrating into Oracle. But for those still exploring a migration to Linux, I won't hesitate to push them toward PostgreSQL instead. There are clear benefits of PostgreSQL over MySQL for the enterprise, and vv. Rgds,

9 20