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 31 to 60 of 154 Next 30 Older Entries

Displaying posts with tag: ubuntu (reset)

how to setup gitorious on ubuntu server 11.10
+0 Vote Up -0Vote Down

In this tutorial I will describe how to setup gitorious on Ubuntu 11.10. Gitorious – a Ruby on Rails web application – can be used to conclude git projects in an easy to manage user interface. In the README of the gitorious repository I found the evidence “One of the main challenges in Gitorious is its installation process. It is anything but trivial.” – It appears correct During the installation I got some errors by the sphinx search engine and some ruby gems. You will find the workarounds in this tutorial.

Contents

  [Read more...]
How do we control MySQL daemon in Linux, part1
+0 Vote Up -0Vote Down

As you may expect from open source world thingy, almost every Linux distribution has developed it’s own way to manage our favourite RDBMS service. Yet none is perfect, or even some of them seems to not work in real server scenario1.

In this post I’m trying to compare and point out most annoying aspects of initialization scripts that I had to face in production.

In ‘old days’ probably all Linux distributions used to start and stop services using so called init scripts usually written in Unix shell (sh or Bash). But situation is not so simple these days anymore.

Folks started to think about improving things, like making

  [Read more...]
Creating A Portable MySQL On CentOS 6 And Ubuntu 11.10 Linux From Sources
+0 Vote Up -0Vote Down

Creating A Portable MySQL On CentOS 6 And Ubuntu 11.10 Linux From Sources

This tutorial shows how to create a portable MySQL installation on GNU/Linux. At the end of this guide you will obtain a portable MySQL installation on a target directory with its own databases, binaries, logs, pid files, etc.  Consider always the use of a permission preserving packaging (like TAR) for moving the installation between systems or removable storages.

Detecting and Removing Unused Indexes in MySQL
+0 Vote Up -1Vote Down

Preface: The following post is a backup from a post first published on the Moviepilot Techblog, which is going to be replaced by the Moviepilot Labs Blog. The content is a bit outdated, as the way to go today is using MariaDB instead of OurDelta. The very content about the UserStats plugin and using it for detecting and removing unused indexes is still valid, though – and a nice way of getting rid of performance killers…

MySQL performance depends on a balanced usage of MySQL indexes. While it is easy to add an index and identify queries not using indexes via EXPLAIN during development or slow.log it is a lot harder to get rid of unused indexes. Finding and

  [Read more...]
MySQL replication monitoring on Ubuntu 10.04 with Nagios and NRPE
+0 Vote Up -0Vote Down

If you're using MySQL replication, then you're probably counting on it for some fairly important need. Monitoring via something like Nagios is generally considered a best practice. This article assumes you've already got your Nagios server setup and your intention is to add a Ubuntu 10.04 NRPE client. This article also assumes the Ubuntu 10.04 NRPE client is your MySQL replication master, not the slave. The OS of the slave does not matter.

Getting the Nagios NRPE client setup on Ubuntu 10.04

At first it wasn't clear what packages would be appropriate packages to install. I was initially misled by the naming of the nrpe package, but I found the correct packages to be:

sudo apt-get install nagios-nrpe-server nagios-plugins

The NRPE configuration is stored in /etc/nagios/nrpe.cfg, while the plugins are installed in


  [Read more...]
How To Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability On Ubuntu 10.04.3 LTS
+0 Vote Up -1Vote Down

How To Set Up Multi-Master Replication Using Tungsten And MySQL-Proxy For MySQL High Availability On Ubuntu 10.04.3 LTS

This tutorial is based on my experience setting up Tungsten Replicator and MySQL-Proxy for a client's production setup.

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Ubuntu 11.10
+0 Vote Up -0Vote Down

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Ubuntu 11.10

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 11.10 server with PHP5 support (through PHP-FPM) and MySQL support.

Installing Apache2 With PHP5 And MySQL Support On Ubuntu 11.10 (LAMP)
+0 Vote Up -0Vote Down

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

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

Ornery Oneiric
+0 Vote Up -0Vote Down

I just updated to Ubuntu 11.10 “Oneiric” on one of my desktops and I ran into an issue with MariaDB.

It’s not an issue with MariaDB itself, more in how the MariaDB “Natty” .deb packages are configured. We haven’t released .deb packages for Ubuntu 11.10 “Oneiric”, but the Natty packages work fine, apart from this one configuration issue (and when we do release “Oneiric” packages, they will work out-of-the-box).

The main problem is that some things have moved around in “Oneiric” and Apparmor doesn’t like the MariaDB “Natty” Apparmor defaults file because it doesn’t account for some of the new destinations. Specifically, /var/run has been moved to /run (a discussion of the rationale behind the move can be found

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

OpenStack Foundation. New Pentaho CEO. And more.

# Rackspace announced its intention to form an independent OpenStack Foundation.

# HP has chosen Ubuntu as the lead host and guest operating system for its Public Cloud.

# Pentaho appointed Quentin Gallivan as its new CEO.

# Hortonworks continued the discussion about contributions to Apache Hadoop.

# Bob Bickel explained why CloudBees is not, itself, open source.

# Google

  [Read more...]
Running phpMyAdmin On Nginx (LEMP) On Debian Squeeze/Ubuntu 11.04
+0 Vote Up -0Vote Down

Running phpMyAdmin On Nginx (LEMP) On Debian Squeeze/Ubuntu 11.04

The phpMyAdmin package from the Debian/Ubuntu repositories comes with configuration files for Apache and Lighttpd, but not for nginx. This tutorial shows how you can use the Debian Squeeze/Ubuntu 11.04 phpMyAdmin package in an nginx vhost. Nginx is a HTTP server that uses much less resources than Apache and delivers pages a lot of faster, especially static files.

Open Query looking for new colleagues!
+1 Vote Up -1Vote Down
My colleagues and I are looking for extra talent – is that you? What we do:help clients prevent problems (rather than being the fire department), we work on a subscription basis although we also do some ad-hoc consulting, and training. Apart from MySQL/MariaDB query and DBA work, we do quite a bit of system administration. Mainly Red Hat and Debian based distros, and expect to see replication and the MySQL-MMM multi-master system. You’d work from home, whereever it might be, so you will need to be self-motivating (but we do keep in touch online). What we’re not: a full-time employer. With us, you make a life rather than a living. Everybody is contracted part-time. You can make enough to live comfortably, but that has nothing to do with hours. If you’re stressed about not filling all hours in your week with work-work-work, we’re not  [Read more...]
Installing MySQL Administrator Tool To Connect To Remote Databases
+0 Vote Up -3Vote Down

Installing MySQL Administrator Tool To Connect To Remote Databases

This tutorial provides step-by-step instructions on how to install MySQL Admin tool on an Ubuntu 11.04 system and how to connect to a remote host with it. This should also work on most Debian based operating systems.

MySQL Clusters on Amazon EC2 - verified AMIs
+1 Vote Up -0Vote Down
We regularly receive questions from our user community with regards to which AMIs to use when deploying database clusters on Amazon EC2.

As part of our ongoing development work on the Severalnines Configurator and ClusterControl, we have recently done some testing on deploying MySQL Cluster on EC2 using Severalnines on three different AMIs. We thought we should share the results of these tests, hence the reason for this week's blog!

If you would like to test such a deployment yourself, feel free to use the parameters and guidelines below to do so. You can also check out these new videos to see



  [Read more...]
Installing Cherokee With PHP5 And MySQL Support On Ubuntu 11.04
+0 Vote Up -0Vote Down

Installing Cherokee With PHP5 And MySQL Support On Ubuntu 11.04

Cherokee is a very fast, flexible and easy to configure Web Server. It supports the widespread technologies nowadays: FastCGI, SCGI, PHP, CGI, TLS and SSL encrypted connections, virtual hosts, authentication, on the fly encoding, load balancing, Apache compatible log files, and much more. This tutorial shows how you can install Cherokee on an Ubuntu 11.04 server with PHP5 support (through FastCGI) and MySQL support.

Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 11.04
+0 Vote Up -0Vote Down

Installing Lighttpd With PHP5 And MySQL Support On Ubuntu 11.04

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 11.04 server with PHP5 support (through FastCGI) and MySQL support.

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Ubuntu 11.04
+0 Vote Up -0Vote Down

Installing Nginx With PHP5 (And PHP-FPM) And MySQL Support On Ubuntu 11.04

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 11.04 server with PHP5 support (through PHP-FPM) and MySQL support.

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

Apache OpenOffice.org proposal approved. SkySQL Tekes new funding. And more.

# The proposal for OpenOffice.org to become an Apache incubator project was unanimously approved.

# Rob Weir discussed how the relationship between OpenOffice.org and LibreOffice need not be a zero-sum game.

# Simon Phipps offered his thoughts on the potential positive and negative outcomes.

# Tekes, the main public funding agency for research, development, and innovation in Finland,

  [Read more...]
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...]
Previous 30 Newer Entries Showing entries 31 to 60 of 154 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.