Home |  MySQL Buzz |  FAQ |  Feeds |  Submit your blog feed |  Feedback |  Archive |  Aggregate feed RSS 2.0 English Deutsch Español Français Italiano 日本語 Русский Português 中文
Previous 30 Newer Entries Showing entries 61 to 90 of 166 Next 30 Older Entries

Displaying posts with tag: ubuntu (reset)

Setting up MariaDB repositories for Debian/Ubuntu
+2 Vote Up -0Vote Down

If you run Debian or Ubuntu, and want a way to auto-generate a sources.list entry, then you should definitely look at: Setting up Repositories for Ubuntu/Debian. Its very simple: choose a distribution, then a release, then choose what version of MariaDB you would like to track and a mirror of your choice, and voila! it generates the sources.list for you.

On LVM: How to setup Volume Groups and Logical Volumes.
+0 Vote Up -0Vote Down
LVM (Logical Volume Management) is a very important tool to have in the toolkit of a MySQL DBA. It allows you to create and extend logical volumes on the fly. This allows me to, say, add another disk and extend a partition effortlessly. The other very important feature is the ability to take snapshots, that you can then use for backups. All in all its a must have tool. Hence, this guide will allow you to understand various terminologies associated with LVM, together with setting up LVM volumes and in a later part will also show you how to extend...
Need const_map
+1 Vote Up -0Vote Down

I love STL containers in C++. They're so much better in general to work with than their C counterparts. The bit that's missing though is an instantiation-time optimized version of map.

Take, for instance, reading a set of commands at startup from a set of dynamically loaded plugins. It's not going to change, in this hypothetical case, because we neither load nor unload plugins after startup. But it's dynamic in the sense that we do not know it at compile time - so doing something like gperf to generate a perfect hash is out of the question.

But why should we pay the lookup cost on a dynamic container for every lookup if I can determine, based on program flow, that the contents of the container are not going to change once it's instantiated.

Something like:

const perfect_map(some_dynamic_map_I_built);

Where the constructor would do a perfect hash generation once, and the

  [Read more...]
Installing Apache2 With PHP5 And MySQL Support On Ubuntu 11.04 (LAMP)
+0 Vote Up -1Vote Down

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 11.04 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 11.04 server with PHP5 support (mod_php) and MySQL support.

slides from the ‘From MySQL to MariaDB’ presentation
+1 Vote Up -0Vote Down

As announced, I held a short talk on switching from MySQL community edition (especially 5.1) to MariaDB (currently 5.2.6) at this years LinuxTag in Berlin.

Here are the (German) slides for reference:

(In case you cannot see the embedded presentation, you can also click here)

Please note: There are a lot of good English slides around. If you want give a talk on MariaDB, the “Beginner’s Guide” might be a good start:

A Beginner’s Guide to MariaDB Presentation

Short talk on MariaDB at Linuxtag 2011
+1 Vote Up -1Vote Down

If you happen to be around at this years LinuxTag 2011 in Berlin/Germany, you are invited to attend my short talk on MariaDB as a drop-in replacement for MySQL. The talk focusses on differences between MySQL Community Edition and MariaDB (e.g. XtraDB, Aria, userstats), shows some features live and explains how to switch. I’ll probably post the slides here afterwards.

The talk will be held in German and is scheduled for Friday, the 13th of May, 16:30. The official announcement can be found here.

451 CAOS Links 2011.05.03
+0 Vote Up -0Vote Down

Novell sold to Attachmate. Barnes & Noble throws the book at Microsoft. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have to.”

# Novell closed its acquisition by Attachmate and its patent sale to CPTN.

# Attachmate’s CEO discussed the company’s plans for SUSE Linux.

# Barnes & Noble


  [Read more...]
Mailing List FAIL
+1 Vote Up -0Vote Down

I've been thinking a bunch about email and mailing lists recently... about how to deal with them, how to follow the ones that are important but not get drowned in a sea of email noise. I have a non-tech email account which is where friends mail me personally and where I handle theatre-related stuff. I do not receive a stupid amount of email on this account, and I am almost always interested in reading the messages that arrive there. So on my inaugust.com email address, I've been considering unsubscribing from all mailing lists and setting both Launchpad and github to stop emailing me most things.

For Launchpad and github, most things I care about have status pages of some sort: lists of bugs or branches I need to attend to or whatnot. I really don't need to get an email every time someone files a bug - it's noise.

Mailing lists are the trickier one, because so many open source projects are

  [Read more...]
On Hot Backups and Restore using XtraBackup
+3 Vote Up -0Vote Down
Backups are an integral and very important part of any system. Backups allow you to recover your data and be up and running again, in the advent of problems such as system crashes, hardware failures or users deleting data by mistake. I had been evaluating backup solution for a while but to be honest I really wasn't satisfied with the solutions available until I came across XtraBackup and I am loving it since. In this post I intend on showing how to do backups and restores using XtraBackup.
Dealing with the Cambrian Explosion 2/2: Parameterizing the package name in DEB files
+1 Vote Up -1Vote Down

Yesterday I wrote down the approach used in the MepSQL build system to parameterize the TAR package name produced. Today I will follow up with how the same was done for building DEBs. The motivation is to create a system that can be used flexibly to create packages of any MySQL fork, with any brand name: mepsql-server-*.deb, percona-server-server-*.deb, mariadb-server-*.deb or even just mysql-server-*.deb (which I might do some day).

While yesterday's tricks with the TAR files were rather straightforward, with the process of building DEBs this turns out to be much more challenging. But not to worry, like

  [Read more...]
New year & new blog
Employee_Team +2 Vote Up -0Vote Down

The new year is here and I have moved my (so far quite silent) blog to use WordPress and MySQL 5.5 GA (http://www.mysql.com/downloads/mysql/).

Since I am using Ubuntu I downloaded a compressed tar archive. I installed it in a custom directory and for starting I wrote a little upstart script.

$ cat /etc/init/mysql-5.5.conf
start on startup
stop on shutdown

env basedir=/opt/mysql/mysql-5.5
env defaults=/etc/mysql-5.5/my.cnf

script
        cd $basedir
        $basedir/bin/mysqld_safe --defaults-file=$defaults
end script

In wp-config.php I have set:

  [Read more...]
Ubuntu Upstart for automatic MySQL start and stop - Part 2
+2 Vote Up -0Vote Down
I've done a little change to the upstart script I published in a recent blogpost. The issue is with mysqld_safe which has a few issues it seems, but so far I haven't tracked them down exactly. Anyway, if mysqld_safe is not in your path and you run it with the full path (as I do in the Upstart script which is run by root that may well not have the mysql bin directory in it's path), then mysqld_safe will behave strange in at least 5.5 when called with the full path, i.e.
/mnt/mysql/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf &
will not work. If I then put the appropriate directory in my path, like this:
PATH=/mnt/mysql/bin:$PATH
/mnt/mysql/bin/mysqld_safe --defaults-file=/etc/mysql/my.cnf &
It still will not work as expected. In




  [Read more...]
Hating Americans and Cats
+4 Vote Up -3Vote Down

Most of the time I think of myself as living in a fairly progressive and enlightened world. I'm fotunate that I work with a set of wonderful people, I can travel all over the world and I'm a member of an excellent theatre company. As a result, hatred of things, or at least expressions of hatred are generally just not tolerated in any of the circles in which I run. (With the exception, of course, of things that FAIL, like a particularly bad piece of code - but even then it's less about hatred and more about not liking something that didn't work)

There are two social acceptable exceptions to that rule, though: Americans, and cats.

I was reading a blog post earlier this morning (which I won't link to because that's not the point here) which was a fun post about older people finding new music. As a person who is not getting any younger myself, the blog post was quite enjoyable. Smack in

  [Read more...]
Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 10.10
+0 Vote Up -1Vote Down

Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 10.10

Lighttpd is a secure, fast, standards-compliant web server designed for speed-critical environments. This tutorial shows how you can install Lighttpd on an Ubuntu 10.10 server with PHP5 support (through FastCGI) and MySQL support.

It Happens
+4 Vote Up -0Vote Down

It's entirely possible, given my propensity to swear and rant and declare things to be Web Scale, that folks might get the idea that I do not like our newer NoSQL bretheren. Quite the contrary - I think almost all of them are exciting and well suited to various tasks. My biggest beef is in thinking that a single technology should be square-pegged into every round-hole anyone can find. This holds true for Drizzle and MySQL as well, by the way. Just because I work on Drizzle does not mean I think Drizzle should be the method of data storage for every blessed thing on the face of the planet - that would be silly!

I bring this up because I had my first instance of thinking that Cassandra might be a good choice for a project someone was showing me yesterday. In this case, the project was collecting data about events, but it as the data was events about real-world interactions, the particular information stored about

  [Read more...]
Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.10 (LAMP)
+0 Vote Up -0Vote Down

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.10 (LAMP)

LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 10.10 server with PHP5 support (mod_php) and MySQL support.

CB1 Ubuntu 10.10 Linux Development Setup
+0 Vote Up -0Vote Down

I use a MacBook Pro for my day-to-day operations here at CB1, INC. I’m a huge believer that a development environment should mimic the production environment, so I find myself running a couple virtual machines in VMware Fusion.

The following guide is a reference for myself as well as possibly a helpful resource for setting up your own Linux development environment. Here’s an checklist of the tasks to perform and software to install:

  • Operating System
    • Ubuntu 10.10 64-bit: I use Ubuntu Desktop in dev and Ubuntu Server in production
    • Package updates and upgrades
    • Network configuration (at least 2 static IP addresses)
  • Development Tools
    • C/C++ development environment
    • Autotools
    • Sun Java JDK
  [Read more...]
451 CAOS Links 2010.10.08
+0 Vote Up -0Vote Down

Patents! Patents! Patents! Canonical’s perfect 10. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have to.”

# Google responded to Oracle’s claims that its Android OS infringes copyrights and patents related to Java.

# Matt Asay evaluated the various patent claims against Android and its related devices.

# Microsoft licensed smartphone patents from ACCESS Co and a subsidiary of Acacia Research.

# Glyn Moody assessed what Microsoft’s


  [Read more...]
451 CAOS Links 2010.10.05
+0 Vote Up -0Vote Down

Microsoft sues Motorola. Oracle says no to LibreOffice. Time to fork Java? And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca, and daily at Paper.li/caostheory
“Tracking the open source news wires, so you don’t have to.”

# Microsoft is suing Motorola over alleged Android patent infringements.

# Oracle confirmed to SJVN that it will not be working with the Document Foundation on LibreOffice.

# Sean Michael Kerner reported that Red Hat has settled an alleged patent infringement case with IP firm Acacia Research.

# Greg Luck asked if it


  [Read more...]
Drizzle7 Beta Released
+3 Vote Up -0Vote Down

I'm happy to announce that today we've released the first beta of Drizzle7! It's been an exciting ride so far and I'm expecting it to be only more exciting moving forward, now that I can actually say things like "yes! please try it!"

Some quick thoughts:

 

  • We're speaking MySQL Protocol over 3306 by default - all of your MySQL connectors should work fine.
  • drizzledump can read from MySQL and write to Drizzle.
  • Replication has changed.
  • Authentication has changed.
  • Options processing has changed.
  • There are tons of plugins.

 

We're actually going to care about breaking things moving forward. 

So... yes! please try it! I'm excited to find out what new things people are going to try to do with it.

 

If you fork it, will they come?
+4 Vote Up -0Vote Down

There is much excitement this week (understandably) about the formation of the Document Foundation and the LibreOffice fork of Openoffice.org.

Alan Bell sees correlation with the previous fork of Joomla from Mambo and has illustrated the potential impact that forking a project can have with a Google Trends chart, where Mambo is the blue line, and Joomla is the red line:

A similar chart for Debian (blue) and Ubuntu (red) is also instructive:

Or what about Nagios (blue) and Icinga


  [Read more...]
451 CAOS Links 2010.08.10
+0 Vote Up -0Vote Down

Compliance. Funding. Financial results. Copyright assignment. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

Compliance
# The Linux Foundation launched the Open Compliance Program, including tools, training, and consulting.

Funding
# VentureBeat reported that Joyent has raised $7m in a second round of funding.

# Basho Technologies secured $2m from angel investors in a Series C preferred equity financing.

# StatusNet




  [Read more...]
Redmine with MariaDB
+1 Vote Up -0Vote Down

I'm in the process of setting up Redmine (version 1.0-stable) on an Ubuntu 8.04 virtual machine. Getting a recent enough gem and rails is less fun than you might imagine, but the big issue I came across was a bug in the database model, which makes MySQL 5.1 (MariaDB 5.1 in my case) barf on installation.

There is a fix, but I am running from a git clone didn't want to download and apply a diff file to that repository. A quick google found what I need: the git cherry-pick command. It allows you to grab a single commit and apply its changes

  [Read more...]
451 CAOS Links 2010.07.27
+0 Vote Up -0Vote Down

New projects. Old arguments. And more.

Follow 451 CAOS Links live @caostheory on Twitter and Identi.ca
“Tracking the open source news wires, so you don’t have to.”

New projects
# Gemini Mobile Technologies released Hibari, a new open source non-relational database for big data.

# Lockheed Martin launched the Eureka Streams open source project for enterprise social networking.

# Sony Pictures Imageworks expanded its open source initiative with the release of OpenColorIO.

Old arguments
# Kirk Wylie discussed the importance of natural split in open core



  [Read more...]
MariaDB 5.1.47 VMs for OpenSolaris, Ubuntu
+2 Vote Up -0Vote Down

Mark’s done an excellent job again, getting VM’s of MariaDB 5.1.47 (release notes, changelog) out there for download. He’s also improved the bandwidth available at the box hosting these images. Get it for Ubuntu 10.04 or OpenSolaris 0906.

Related posts:

  • Ubuntu 10.04 LTS
  •   [Read more...]
    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.04 (LAMP)
    +0 Vote Up -0Vote Down

    Installing Apache2 With PHP5 And MySQL Support On Ubuntu 10.04 (LAMP)

    LAMP is short for Linux, Apache, MySQL, PHP. This tutorial shows how you can install an Apache2 webserver on an Ubuntu 10.04 server with PHP5 support (mod_php) and MySQL support.

    How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)
    +0 Vote Up -1Vote Down

    How To Set Up WebDAV With MySQL Authentication On Apache2 (Ubuntu 9.10)

    This guide explains how to set up WebDAV with MySQL authentication (using mod_auth_mysql) on Apache2 on an Ubuntu 9.10 server. WebDAV stands for Web-based Distributed Authoring and Versioning and is a set of extensions to the HTTP protocol that allow users to directly edit files on the Apache server so that they do not need to be downloaded/uploaded via FTP. Of course, WebDAV can also be used to upload and download files.

    Ubuntu 10.04 with full cluster stack support
    +1 Vote Up -0Vote Down

    Just in case you haven’t noticed, Ubuntu 10.04 “Lucid Lynx” has arrived. I upgraded my personal box over the weekend, and am happy to report that things went pretty flawlessly for me. So I’m now a happy lucid user.

    What’s more important for the ever-growing cluster community is the fact that this LTS release comes with built-in support for the Pacemaker cluster stack — and indeed, it’s the first commercially-supported distribution that comes with support for both the Heartbeat and the Corosync cluster messaging layer. And it’s easy, too!

    Here’s how I install the Pacemaker stack with Heartbeat

      [Read more...]
    Ubuntu 10.04 LTS released, MariaDB 5.1.44/5.2-BETA VM’s available
    +2 Vote Up -0Vote Down

    A big congratulations to Ubuntu for the release of 10.04 LTS. While I haven’t had the chance to upgrade, I see everyone on Twitter and in the blogosphere say they are really like the Lucid experience.

    A couple of days ago, I made mention that there were VirtualBox images of MariaDB out there. Turns out there were so many downloads, Mark has had to upgrade his Internet connection!

    Anyway, to the point: Mark has created Ubuntu

      [Read more...]
    VirtualBox images for MariaDB
    +4 Vote Up -0Vote Down

    Coming from a great MariaDB contributor, Mark, is:

  • MariaDB 5.1.44 / 5.2.0 Beta Binaries for Solaris 10 SPARC, and Debian GNU/Linux SPARC. Mark does a fabulous job of building these binaries, and he does them really quickly. If you’re on the SPARC platform, give it a go. Send some feedback, also.
  • Mark has also spent some time developing virtual machines. All you need to get started is download VirtualBox. Mark provides an OpenSolaris 0906 + MariaDB 5.1.44 VM as well as an
  •   [Read more...]
    Previous 30 Newer Entries Showing entries 61 to 90 of 166 Next 30 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.