Posts Tagged ‘Ubuntu’

Ubuntu 14.04 – some MySQL ecosystem notes

Following my previous post on the launch, I just rolled Ubuntu 14.04 LTS on an Amazon EC2 t1.micro instance (not something you expect to run a database server on, for sure – 1 vCPU, 0.613GiB RAM). If you do an apt-cache search mysql you get 435 return result sets with the default configuration (trusty: main & universe).

If you do apt-get install mysql-server, you get MySQL 5.5. You enter the password of choice, and before you know it, MySQL is installed (a SELECT VERSION() will return 5.5.35-1ubuntu1).

Next you decide to install MariaDB. I run an apt-get install mariadb-server. It pulls in libjemalloc (for TokuDB) and I expect future releases to ship this engine by default. You enter the password, and you get a new message (as pictured).

MariaDB Ubuntu 14.04 LTS
 

I verify my test database that I created exists. It does. A SELECT VERSION() returns 5.5.36-MariaDB-1. The innodb_version returns 5.5.36-MariaDB-33.0.

I’m curious about MySQL 5.6 now. So I run apt-get install mysql-server-5.6. Not so straightforward. 

start: Job failed to start
invoke-rc.d: initscript mysql, action "start" failed.
dpkg: error processing package mysql-server-5.6 (--configure):
 subprocess installed post-installation script returned error exit status 1
Setting up mysql-common-5.6 (5.6.16-1~exp1) ...
Processing triggers for libc-bin (2.19-0ubuntu6) ...
Errors were encountered while processing:
 mysql-server-5.6
E: Sub-process /usr/bin/dpkg returned an error code (1)

Looks like MySQL 5.6 is more memory hungry… I edited /etc/mysql/my.cnf to ensure that innodb_buffer_pool_size = 64M (I increased this to 128M and it worked too) was set (there was nothing in the default config) and re-ran apt-get install mysql-server-5.6 and it started. My test database was still around ;-)

I wanted to make sure that MySQL 5.6 isn’t more memory hungry just on that instance so I created yet another clean t1.micro instance and did an apt-get install mysql-server-5.6. Same error. Reported lp#1311387.

Nothing to report in particular about Percona – 5.5.34 Percona XtraDB Cluster (GPL), Release 31.1 (Ubuntu), wsrep_25.9.rXXXX. One thing is for sure – if you’re playing around with the ecosystem, installs and upgrades aren’t exactly straightforward.

Congratulations Ubuntu, for the wide choice!

Inspired by Yngve Svendsen’s post, I too think it makes absolute sense to congratulate Ubuntu on the 14.04 LTS release (some server notes - MySQL has a section dedicated to it). Ubuntu users have a lot of server choice today (that’s from all major MySQL ecosystem vendors):

  • MySQL 5.5.35 ships in main. It is the default MySQL. Oracle has committed to providing updates to 5.5 throughout the LTS release cycle of Ubuntu (which is longer than the planned EOL for 5.5). This is why the grant of a Micro Release Exception (MRE).
  • MySQL 5.6.16 ships in universe
  • MariaDB 5.5.36 ships in universe.
  • Percona XtraDB Cluster 5.5.34 ships in universe

Ubuntu’s pitch is being the cloud platform of choice, with OpenStack support. This explains why Percona XtraDB Cluster (the only shipping Galera Cluster variant — no upstream Codership release, and no MariaDB Galera Cluster) is critical infrastructure as its used widely in OpenStack deployments. 451Research estimates that the OpenStack distributions market is worth $82 million in 2014 and $119 million in 2015.

Press release had a choice quote from Percona CEO, Peter Zaitsev:

“We are very pleased that Percona XtraDB Cluster is included in Ubuntu 14.04 LTS. Many organisations that use MySQL need high availability solutions to ensure that their applications meet the expectations of their users. Percona XtraDB Cluster is an easy to use, open source solution for MySQL clustering which addresses these high availability needs. We continue to see growth in Ubuntu usage by our customers and our open source software users so we are confident that the inclusion of Percona XtraDB Cluster in Ubuntu 14.04 will help spread the adoption of cost-effective, high availability MySQL.” Peter Zaitsev, Co-Founder and CEO at Percona

 

MariaDB & distributions update, Dec 2013

A few things to note recently, amongst MariaDB in distributions. 

  1. Ubuntu keeps MySQL 5.5 despite MariaDB’s success. There’s a lot of reasons for this, but remember the key takeaway here is MySQL 5.5 & the fact that MariaDB wasn’t even in Debian yet when the decision was made.
  2. MariaDB is now inside of Debian/sid – check out the packages.
  3. RHEL 7 comes with MariaDB 5.5 as a default; this is a good thing.

Now, from a distribution standpoint, we’re looking at starting to ship 10.0 as well. Distro maintainers don’t want one-way streets (i.e. an upgrade to MariaDB prevents you from going back to MySQL). This is something we have to deal with as more start looking at MySQL 5.6 & MariaDB 10 (think temporal literals as an example).

Ubuntu Edge failure and what it means to me

A few days ago I received a credit from Indiegogo, because the USD$600 that I pledged for the Ubuntu Edge didn’t work out (I pledged on day one not because it was cheap but because I felt I needed the device and thank Canonical for the wonderful work they’ve done in addition to being brave about going into new markets; I would have paid $895 if need be – we don’t get heavily subsidised phones where I come from). There was a lot of buzz about how this is the largest crowdfunding experience ever, and so on, but to me, as a believer in opensource, I feel this failure to get an Ubuntu Edge more than ever.

It was by no means a shoddy amount that was pledged, in the sense that it raised USD$12,813,501 out of the USD$32,000,000 goal. I was curious with who pledged, and this is quite public as well – see the pledges list. But what you see is that a lot of people pledged not for the phone but smaller amounts which I guess is a huge problem.

Simply put, you need about 50,000 people (community members/Ubuntu users/etc.) to pledge to buy the phone (at an average sale price of USD$695). A mere 50,000. I planned to analyze the data, but its great that The Guardian did most of the work for me, so read: Ubuntu Edge: how many phones were really ordered – and the mistakes.

14,577 individuals pledged to order the phone. Enterprises were shy by the looks of it.

Out of the 14,577 individuals, I expect many of them to be Ubuntu users to some extent (if not lovers of opensource). Where are the rest of the Ubuntu users?

The public stats for Ubuntu are quite impressive – generally it is the most popular desktop Linux distribution out there. Just look at the adoption & reception: in June 2009, it was estimated that there are 13 million active users; in fall 2011 Canonical itself estimated more than 20 million users worldwide. This number must have grown tremendously, but even at a 20 million base, you’re looking at 0.073% conversion rate to buy an Ubuntu Edge.

I know people that are Ubuntu users and wanted to buy it, but not at the price point. Over $600 for a phone with a computer that docks just isn’t feasible as a cost in many parts of the developing world. Without user registration, we can’t tell where Ubuntu users are located, but I’m willing to bet it’s a good mix between the developed/developing world, right?

I was hoping to hold an Edge in my hand come May 2014. I’m still hoping to hold an Ubuntu mobile device in my hand. While I am disappointed, I can imagine Mark Shuttleworth asking himself a lot of questions. He’s spent millions developing Ubuntu, the community that surrounds it and the commercial aspects around it. Apparently monetizing the userbase is harder than it looks.

Facebook Home

Colored houseI happened to be awake last night so I caught the announcement via livestream for Facebook Home. I’m glad its just a system launcher. There are many (I myself on my phone use Nova Launcher), but from the demo, this is beautifully designed with a new take on the interface. The demo showed it being smoother than butter ;)

Chat heads look interesting. Some may claim it being bothersome or unintuitive, but most iOS users have this already turned on via accessibility settings assistive touch since the home button breaks far too easily. Why a little white dot when you can now make it do things for you?

I was impressed with the amount of partners on launch day. Buy-in from manufacturers like HTC, Samsung, Sony, Huawei, Lenovo, ZTE, Alcatel. Chipmaker like Qualcomm. Telcos like AT&T, Orange, EE. I can only expect this to grow of course. Gives great competition in the mobile landscape for 2013.

You see, FirefoxOS has a huge amount of partners & buy-in. I continue to be surprised that Ubuntu doesn’t have a similar page.

Am I switching from iOS as my main phone? Unlikely. I’m almost certain that many at Facebook, including Zuckerberg runs on IOS. But I will be playing with this on my secondary device (the Galaxy S3). I’m a little surprised that the April 12 launch isn’t available for the Nexus set of phones… and in Asia, the Galaxy Note form factor is popular, where did that go?

HTC First will be the first device to come with the Facebook Home system launcher as a default. I’m not sure how this is different to them applying skins and admitting that Facebook does it better. This isn’t the first time they’re playing around with a Facebook phone though.

Interesting times as Facebook has confirmed that their strategy is clearly mobile first. The fact that they built this on top of Android can’t really impress Google very much ;)

Others have also covered this well, i.e a strategy for Facebook, how this isn’t good for privacy.

Mobile landscape: Ubuntu, Firefox OS

LandscapedLong-term I’m bullish on Android. Its everywhere, its like the multiple Linux distributions. I have a preference to Google-sanctioned devices (i.e. the Nexus series), but each and every Android device manufacturer has their own bells & whistles.

The mobile landscape is actively changing. I was in Paris when I watched the announcement that there would be an Ubuntu for phones. I was a little disappointed that the announcement was for the possibility with no manufacturers or no actual device being announced. You’d presume that’s what you would get with the countdown on the website, and all the hype built up around it. To add to my confusion, there still exists Ubuntu for Android, which has been around for quite some time with no one biting. I heard its vaguely opensource so you could run it on a device, but I’ve not seen much.

The idea is amazing (carrying your phone, plugging it in to see a full-featured desktop) and I can’t wait to see what happens in 2014. It seems like the developer environment is Qt/QML for a native feel, but you’ve also got HTML5. They’re going to leverage on the Ubuntu community. I just think the hype around this is being built too early.

However, what’s more exciting is Mozilla’s recent announcements. They have a Firefox OS developer preview phone announced. They tell you how to use Firefox OS today. There are also AppDays happening worldwide. And they have a phone coming soon as a partnership with Geeksphone & Telefonica of Spain. Here it seems clear that your HTML5 apps are going to rock (see the Firefox Marketplace). When I say soon, I’m saying next month, i.e. February 2013. I’ve signed up to buy one.

The mobile landscape is changing. Nokia was the king of phones with Symbian, and today they’re backing Windows Mobile. Most of the top manufacturers are building Android devices (opensource). There are many companies signed up to make Tizen devices in 2013 and beyond (opensource). Now you have opensource Ubuntu & Firefox OS. Apple may have started this modern trend but iOS device sales aren’t stellar (witness Apple’s recent stock drop). iOS to be fair is also built on opensource (itself its closed).

Year of the Linux desktop? Who needs that. You’ve already arrived at the years of opensource computing.


i