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 140 Next 30 Older Entries

Displaying posts with tag: debian (reset)

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...
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.

Installing Cherokee With PHP5 And MySQL Support On Debian Squeeze
+0 Vote Up -0Vote Down

Installing Cherokee With PHP5 And MySQL Support On Debian Squeeze

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

MySQL source tree available in Debian as binary package
+3 Vote Up -0Vote Down
MySQL supports a plugin interface since 5.1, which enables creation of server components. Plugins can be loaded at server startup, or loaded and unloaded at runtime without restarting the server. Most of these plugins require the full MySQL source tree during their build, which was not available in Debian as a binary package until I uploaded 5.1.54-2 to unstable last week. I had this item on my TODO list since MySQL 5.1 was uploaded to Debian unstable, because it is not possible for a Debian source package to build-depend on another source package. Thankfully, Clint Byrum from Ubuntu sent me a small patch which added the new binary package.

The first package making use of the new

  [Read more...]
MySQL 5.5 and Debian
+5 Vote Up -0Vote Down
Since MySQL 5.5 was declared stable in December last year, I regulary receive e-mails from people asking when it will get uploaded to Debian. The good thing is that the initial conversion from automake to cmake has already been done by Clint Byrum from Ubuntu, and we are going to use his work as a basis for our packages. The not so good thing is bug #59078, an issue in libmysqlclient which breaks ABI compatibility. According to Lenz Grimmer from Oracle the MySQL upstream developers are already looking at it.

I am still not sure if it is a good idea to upload MySQL 5.5 in the current state to experimental, but I am definitely not going to upload it to unstable until this issue is fixed.

Update: I just had



  [Read more...]
Cluster Stack update for Debian
+1 Vote Up -0Vote Down

Last week, the Linux-HA project made its Heartbeat 3.0.4 and Cluster Glue 1.0.7 release, and Pacemaker released 1.0.10 a few weeks back. Thanks to the amazing Simon Horman (horms to IRC regulars), those releases have been uploaded to Debian unstable (sid) yesterday.

What’s sid?

sid is the permanent code name of the Debian unstable distribution. It’s where package maintainers upload fresh builds and maintain the latest versions of distribution packages. It’s not meant for general

  [Read more...]
Howto setup MySQL on a DRBD volume
+2 Vote Up -0Vote Down
One more DRBD tutorial, this time I will describe howto setup MySQL with DRBD (Distributed Replicated Block Device). Purpose This document describes how to to setup a failover system with MySQL and DRBD (Distributed Replicated Block Device). Introduction In this tutorial we will setup two Debian Linux nodes with a DRBD volume. MySQL will be [...]
Recently in MariaDB #2
+2 Vote Up -1Vote Down

There has been a lot happening in the MariaDB community recently, and there has been growth. Here are some of the highlights. Thank you to all our current contributors, and to others that want to contribute, shoot community[at]askmonty[dot]org an e-mail.

MariaDB 5.2.3 binaries for Solaris and Debian Sparc

Our Sparc community contributor, Mark, has continued to make popular binaries for Solaris 10 and Debian Sparc. He’s kept up to speed with MariaDB 5.2.3, so please visit him and download the binaries.

MariaDB 5.2.3 on the openSUSE Build Service

Community contributor Michal Hrušecký has packaged MariaDB for openSUSE and its available via the

  [Read more...]
Hadoop Cluster Setup on Debian Lenny
+0 Vote Up -0Vote Down

Today I will describe the setup of a Hadoop / HDSF multi-node cluster on Debian Lenny with a redundant Namenode using DRBD and Heartbeat, four Datanodes and Tasktracker, a Backup- Checkpointnode and Rack awareness.

Hadoop Cluster Setup on Debian Lenny purposes

This article descibes how to setup a hadoop (version 0.21.0) cluster on debian lenny (version 5.x). I will not describe how to use MapReduce.

general

Hadoop is a framework for distributed computing written in Java. The project includs the following subprojects:

  • HDFS: A distributed file system
  • MapReduce: A framework for distributed large data processing
list of references   [Read more...]
Microblogging, part 2
+0 Vote Up -0Vote Down
When I blogged about microblogging using Twitter a while ago, I got some suggestions regarding Identi.ca in the comments. I did not know about Identi.ca at that time, but decided to give it a try. Identi.ca is a service like Twitter based on StatusNet, an open source microblogging platform. After using both services in parallel for a while, with constant frustration about the unreliable Identi.ca -> Twitter gateway, I now finally decided to completely drop my account on Twitter.

Unfortunately something got miserably wrong while playing with the Identi.ca -> Twitter gateway last week, I somehow lost all my subscribers and subscriptions, so please resubscribe to my account.
How To Set Up MySQL Database Replication With SSL Encryption On Debian Lenny
+1 Vote Up -0Vote Down

How To Set Up MySQL Database Replication With SSL Encryption On Debian Lenny

This tutorial describes how to set up database replication in MySQL using an SSL connection for encryption (to make it impossible for hackers to sniff out passwords and data transferred between the master and slave). MySQL replication allows you to have an exact copy of a database from a master server on another server (slave), and all updates to the database on the master server are immediately replicated to the database on the slave server so that both databases are in sync. This is not a backup policy because an accidentally issued DELETE command will also be carried out on the slave; but replication can help protect against hardware failures though.

Installing A Web, Email And MySQL Database Cluster (Mirror) On Debian 5.0 With ISPConfig 3
+1 Vote Up -0Vote Down

Installing A Web, Email And MySQL Database Cluster (Mirror) On Debian 5.0 With ISPConfig 3

This tutorial describes the installation of a clustered Web, Email, Database and DNS server to be used for redundancy, high availability and load balancing on Debian 5 with the ISPConfig 3 control panel. GlusterFS will be used to mirror the data between the servers and ISPConfig for mirroring the configuration files. I will use a setup of two servers here for demonstration purposes but the setup can scale to a higher number of servers with only minor modifications in the GlusterFS configuration files.

New webinar recordings available
+0 Vote Up -0Vote Down

A couple of new webinar recordings are available from our web site:

Like our live webinars, the recordings are of course free of charge. Enjoy!



  [Read more...]
Apache And MySQL Monitoring With Bijk On Debian Lenny
+0 Vote Up -0Vote Down

Apache And MySQL Monitoring With Bijk On Debian Lenny

This tutorial describes how you can monitor your server with the tool Bijk. Bijk creates online 30 graphs about load, CPU, memory, traffic, Apache, NginX, PostreSQL and others with alerts. Bijk can be used on Debian, Ubuntu, CentOS, RedHat and Gentoo. In this article I will explain how to install Bijk on Debian.

Reminder: Pacemaker/Debian webinar, today 1400 UTC
+0 Vote Up -0Vote Down

For those of you who haven’t yet registered, this is our reminder for today’s Clustering in Debian webinar at 1400 UTC. If you’re planning to run Pacemaker on the upcoming Debian squeeze release, don’t miss this!



  [Read more...]
Upcoming webinar: migrating to Pacemaker on Debian squeeze
+0 Vote Up -0Vote Down

Martin Loschwitz, the longest-serving Debian Developer in our ranks, will present a walk-through of going from Linux clustering on Debian lenny (with Heartbeat 2.1.3, shudder) to squeeze (with Heartbeat 3 and Pacemaker). In this webinar you will learn everything you need to know about a painless migration to the new Linux cluster stack.

This webinar will be held on Monday, June 7, at 1400 UTC. You must provide a valid email address to receive a meeting key. Register below!


The widget should

  [Read more...]
Sphinx As MySQL Storage Engine (SphinxSE)
+0 Vote Up -0Vote Down

Sphinx As MySQL Storage Engine (SphinxSE)

SphinX is a great full-text search engine for MySQL. Installing the Sphinx daemon was straightforward as you can compile it from the source or use a .DEB/.RPM package but SphinxSE was a little bit tricky since it needed to be installed as a plugin on a running MySQL server. So if you use Debian or Centos and install your MySQL from a .deb or .rpm package this is how you do it.

Linux cluster stack hits Debian squeeze
+0 Vote Up -0Vote Down

The full Linux cluster stack, including Pacemaker, Heartbeat, Corosync and related packages, cleared all hurdles and migrated to the Debian testing repository this morning. This means that Pacemaker and both messaging layers it supports will be in the upcoming Debian release, codenamed squeeze.

Credit goes to the debian-ha maintainers crowd for making this possible: Martin Loschwitz, Simon Horman,

  [Read more...]
Complete Pacemaker cluster stack now in Debian
+0 Vote Up -0Vote Down

Thanks to the efforts of the Debian HA Maintainers team, the complete Pacemaker cluster stack is now available in Debian GNU/Linux. Packages are currently included only in Debian unstable (“sid“), but we expect them to make their way into squeeze (and lenny, via backports.org) relatively soon.

See the following links in the Debian package database for details:

  [Read more...]
MariaDB in Gentoo; updates for Solaris/Debian SPARC
+3 Vote Up -1Vote Down

Gentoo
It started with Brian Evans’ github repository, some good instructions on the mailing list for Building MariaDB on Gentoo, to a request for packaging, and guess what? Its now officially in Gentoo! Thanks Brian, and Robin Johnson!

SPARC builds – Debian, Solaris
Mark has now got a MariaDB category on his blog and the interesting things for you to grab are:


  [Read more...]
MySQL distro meeting in Brussels
+1 Vote Up -0Vote Down
Last month I spent two days in Belgium, after I got invited to the MySQL distro meeting. It was a non-public meeting with some people from Sun Microsystems and MySQL maintainers from different Linux distributions. It took place directly after FOSDEM (which I unfortunately could not attend due to personal reasons) at the Sun Microsystems Belgium office in Brussels. It was great to meet with Mathias Gug from the Ubuntu Server team in person. He had some really good ideas on how we could reduce the differences between MySQL in Debian and Ubuntu in the future. As a consequence, Debian will soon switch from Subversion to Bazaar for  [Read more...]
MySQL distro meeting in Brussels
+0 Vote Up -0Vote Down
Last month I spent two days in Belgium, after I got invited to the MySQL distro meeting. It was a non-public meeting with some people from Sun Microsystems and MySQL maintainers from different Linux distributions. It took place directly after FOSDEM (which I unfortunately could not attend due to personal reasons) at the Sun Microsystems Belgium office in Brussels. It was great to meet with Mathias Gug from the Ubuntu Server team in person. He had some really good ideas on how we could reduce the differences between MySQL in Debian and Ubuntu in the future. As a consequence, Debian will soon switch from Subversion to Bazaar for maintenance of most MySQL packages.  [Read more...]
When backups fail: A mysql binlog race condition
+0 Vote Up -0Vote Down

Today I ran into my first MySQL binlog race condition: The initial problem was quite simple: A typical MySQL master->slave setup with heavy load on the master and nearly no load on the slave, which only serves as a hot fallback and job machine, showed differences on the same table on both machines. The differences showed up from time to time: entries that have been deleted from the master were still on the slave.

After several investigations I started examining the MySQL binlog from the master – a file containing all queries that will be transferred to the slave (and executed there if they don’t match any ignore-db-pattern). I grepped for ids of rows that have not been deleted on the slave as I’s interested if the DELETE statement was

  [Read more...]
Recently in MariaDB #1
+5 Vote Up -3Vote Down

The aims of this kind of blog post is simple – I want to help keep the masses informed as to what’s happening with MariaDB, as a whole. There is a community growing, and MariaDB is a community project, not necessarily a Monty Program Ab baby (and we’re clear on this distinction: think of it like Canonical/Ubuntu). So, think of it as such that I’m sharing the good news, and summarising what’s been happening, to save you time.

MariaDB added to the Debian/Ubuntu wishlists
One of MariaDB’s goals is that it should be easily available for download. While we provide binaries and source at

  [Read more...]
How To Back Up MySQL Databases With mylvmbackup On Debian Lenny
+1 Vote Up -0Vote Down

How To Back Up MySQL Databases With mylvmbackup On Debian Lenny

mylvmbackup is a Perl script for quickly creating MySQL backups. It uses LVM's snapshot feature to do so. To perform a backup, mylvmbackup obtains a read lock on all tables and flushes all server caches to disk, creates a snapshot of the volume containing the MySQL data directory, and unlocks the tables again. This article shows how to use it on a Debian Lenny server.

Fixing a MariaDB package bug
+4 Vote Up -0Vote Down

One of the things that I am really happy about in MariaDB is that we have our releases available as apt (and yum for Centos) repositories. This is largely thanks to being able to build this on the OurDelta package build infrastructure (which again builds on things like the Debian packaging scripts for MySQL).

Something like the Debian apt-get package system (which is also used by Ubuntu) is one of the major innovations in the Free Software world in my opinion. Debian has spent many years refining this system to where it is today. Want to run the mysql client, but it isn't installed? Just try to run it on your local Ubuntu host:

    $ mysql
    The program 'mysql' can be found in the following packages:
     * mysql-client-5.0
     * mysql-client-5.1
    Try: sudo apt-get install <selected package>
    -bash: mysql:

  [Read more...]
We’re in!
+9 Vote Up -0Vote Down

DRBD has entered a new phase. After being developed out of tree for 9 years, and after an extended review and streamlining phase since March, Phil submitted DRBD to be merged into 2.6.32 release of the Linux mainline kernel. The submission was accepted by block layer maintainer Jens Axboe, who merged DRBD in September, then deferred to the 2.6.33 merge window, and this morning Linus

  [Read more...]
MySQL currently not available in Debian testing
+0 Vote Up -0Vote Down
Due to a bug in britney, the Debian testing migration tool, MySQL is currently not available in testing. The issue is known and being worked on already, and it is documented in the Debian bug tracking system.

Update: Meanwhile the issue was fixed, MySQL is available in testing again.
MySQL currently not available in Debian testing
+0 Vote Up -0Vote Down
Due to a bug in britney, the Debian testing migration tool, MySQL is currently not available in testing. The issue is known and being worked on already, and it is documented in the Debian bug tracking system.

Update: Meanwhile the issue was fixed, MySQL is available in testing again.
Previous 30 Newer Entries Showing entries 31 to 60 of 140 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.