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 49

Displaying posts with tag: Technical (reset)

Look mom, no hands: I can fix MySQL Cluster bugs by just staring at them (part III)
+0 Vote Up -0Vote Down

(Continued from part II where I tried to fix a bug and found out that the affected part of the code had been rewritten, so the bug didn't exist anymore.)

Magnus gives a helpful hint...

read more

Actually trying to do something techical, part II: HowTo fix a MySQL Cluster bug without touching a single line of code!
+0 Vote Up -0Vote Down

This is part II of my efforts to prove myself that I can do programming. In part one I successfully created a MySQL Cluster branch for myself and compiled it.

Let's go to the public MySQL bug database and see if there are any trivial MySQL Cluster bugs I could sharpen my teeth on. Heh, sure enough #32658 looks simple enough. There is a typo in an output string - so I could fix that without even doing any C++ code! (Funnily, a MySQL internal comment to the bug says something about it being embarrassing. Guess it is a good bug for me then, as patching over embarrasments is what Sales Engineers do routinely :-)

Let me see...

read more

Actually trying to do something techical: branch a MySQL Cluster bzr repository - part 1, branch and build
+0 Vote Up -0Vote Down

My collagues Anders and even Ivan sometimes blog about the grandeur of being a Sales Engineer. And I agree, it is a great job, probably the best I ever had, so far. But let me share a secret: It's not as technical as you'd think. Sure, they call me a "pre-sales consultant" alright, but I would be ashamed of comparing my own work with those of the real consultants. I sometimes jokingly say that the most amazing technical things in my job are airplanes (they fly in the air!) and how to make a nice slideshow. (OpenOffice Impress sucks btw, and I always envy my OS X + Keynote using friends on this one

  [Read more...]
A few seats still left in DRBD Total on-line training
+0 Vote Up -0Vote Down

By popular demand, we are now offering an on-line incarnation of our DRBD Total training sessions, normally taught in a 4-day on-site course. The next such training commences on May 18 (next Monday), and we still have a few seats left — so if you’re interested, grab one while you still can!

What’s covered in this course?

Here is an overview of the course highlights:

  • Introduction to High Availability Clustering & DRBD
  • Setting up a DRBD resource and common failure scenarios
  • Configuring and running the Heartbeat/Pacemaker cluster stack
  • Highly available NFS, MySQL, and virtualization
  • DRBD performance tuning and optimization
  • DRBD integration with Red Hat Cluster Suite
  • Recent and future DRBD development

Every course attendee gets a virtual

  [Read more...]
Upload Image to MySQL using PHP
+0 Vote Up -0Vote Down
Upload Image to MySQL using PHP As a new-bie to php/mysql, I tried different stuffs. So here I’m with my php code for Image Upload to MySQL. Its a quite...
Difference MyISAM and InnoDB Storage Engines Mysql
+0 Vote Up -0Vote Down
MyISAM InnoDB Default since version 3.23 Relatively newer Files storage: FRM: table definition, MYD: Actual Data MYI: Index File FRM: table definition .ibd file (concept of table space) or single...
Choosing between MyISAM and INNODB – MySQL Storage Engines
+0 Vote Up -0Vote Down
After reading at a lot of places for the the single repeatative question, “What engine shall I choose – MyISAM or Innodb?”, this is what I’ve got. Following are points...
Using MySQLTuner – MySQL Optimization Tool
+0 Vote Up -0Vote Down
MySQLTuner is a script written in Perl that will assist you with your MySQL configuration and make recommendations for increased performance and stability. Within seconds, it will display statistics about...
Perl Script for Analyze – Optimize – Repair Mysql Databases
+0 Vote Up -0Vote Down
The perl script is mainly created to avoid manual Mysql Server Maintenance. The script uses Perl module DBI. You need to provide access credentials and database name(optional). Regarding Analyse, Optimize...
DRBD for Dolphin Express Webinar
+0 Vote Up -0Vote Down

As part of our partnership with Dolphin Interconnect Solutions, we are presenting two webinars on DRBD for Dolphin Express on Nov. 5 (European business hours) and Nov. 12 (American business hours).

Both DRBD and Dolphin Express already being a fixture in the MySQL (http://www.mysql.com) universe, this webinar should be particularly interesting to those of you who want to minimize database write latency while maintaining fully redundant and transaction-safe high availability. However, it’s also a must see for virtualization and mail service DRBD users, who also typically have a need for low latency.

This is, of


  [Read more...]
Public draft of DRBD Users’ Guide released
+0 Vote Up -0Vote Down

A public draft version of the all-new DRBD Users’ Guide has just been released. Feedback is more than welcome.

You may want to read the announcement as well.


  [Read more...]
DRBD 8.2.3 released; boasts online device verification, CPU affinity optimization
+0 Vote Up -0Vote Down

DRBD 8.2.3 was released today. Even though just a micro release in terms of version numbering, it comes with a couple of very handy brand new features: on-line device verification, and tunable processor affinity.
(more…)



  [Read more...]
Step-by-step upgrade from DRBD 0.7 to DRBD 8
+0 Vote Up -0Vote Down

I’ve been asked by a number of people on how to do an upgrade from DRBD version 0.7 to DRBD 8. This upgrade does necessitate some minimal service down time, but it’s really not rocket science. And no, it does not force you to sync all of your data all over again.

Here’s my quick write-up.

An initial word of caution

Do not, I repeat do not attempt your upgrade unless you have at least read this blog entry to the finish.

Getting ready

First, you need to make sure that you have both your DRBD 8 userland binaries and kernel module ready to install. For our support customers, this means that you simply download two RPMs (or .debs) from our support web site. Make sure you have the right packages; you want those that match your system architecture and (for the kernel module) also your running


  [Read more...]
An underrated cluster admin’s companion: dopd
+0 Vote Up -0Vote Down

Split brain, with DRBD, is much less of a disaster than in conventional cluster setups employing shared storage. But, you ask, how can I protect my DRBD cluster against split brain in the first place? Here’s how.

Let’s briefly reiterate what split brain, in the DRBD sense, really means. DRBD split brain occurs when your nodes have lost their replication link due to network failure, and you make both nodes Primary after that.

When just the replication link dies, Heartbeat as the cluster manager will still be able to “see” the peer node via an alternate communication path (which you hopefully have configured, see this post). Thus, there is nothing that would keep Heartbeat from migrating resources to that DRBD-wise disconnected node if it so decides


  [Read more...]
DRBD 8.2.0 introduces protocol integrity checksums
+0 Vote Up -0Vote Down

DRBD 8.2.0, released today, includes a much requested new feature, embodied in the new data-integrity-alg configuration option: DRBD protocol level data integrity checksums.

A few months ago, some users alerted us to DRBD replication issues where DRBD supposedly “ate their data”, i.e. corrupted replicated data in transit. Eventually we traced those problems not to DRBD errors, but in fact to network drivers messing up TCP checksums or segmentation. Typically this was related to using either TCP segmentation offloading (TSO) or TCP checksum offloading. However, at the time DRBD had no way of detecting these errors — you would only find out if you switched over to your Secondary, only to find your data not having been replicated properly.

With DRBD 8.2.0, you


  [Read more...]
Performance tuning DRBD setups
+0 Vote Up -0Vote Down

These days, we seem to be getting a lot of inquiries from new or would-be DRBD adopters, especially MySQL (http://www.mysql.com" target="_blank) and PostgreSQL DBAs wanting to add high availability to their master database servers. And these, unsurprisingly, turn out to be two of their most popular questions:

How will using DRBD affect my write performance?

… and …

What are DRBD’s most important tunables with regard to write performance?

Let’s take a look at both of these issues. Ready? Let’s go.

Basically, there’s usually one important potential bottleneck in any DRBD “Protocol C” (synchronous replication) setup, and it’s not the network connection. With ubiquitous Gigabit


  [Read more...]
Why DRBD won?t let you mount the Secondary
+0 Vote Up -0Vote Down

As I’m sure you’re aware, DRBD disallows access (any access, including read-only) to a DRBD device in Secondary mode. This always raises questions like the one I’ve taken the liberty to quote here. It came up in a MySQL webinar (http://www.mysql.com/news-and-events/on-demand-webinars/" target="_blank) on replication and HA:

Because of the asynchronous nature of [MySQL] replication we end up with a dilemma when looking at using slaves as read nodes in that the only time we go to the database for information is to build a local cache file, and that local cache file is ONLY removed when information related to that cache file changes, it is NOT based on time. If we had a synchronous method of replication we would then know the cache files


  [Read more...]
Using DRBD directly (without a file system)
+0 Vote Up -0Vote Down

Some applications require direct access to a block device, without an intermediate file system. Some Oracle and MySQL configurations are an example, as are some Xen setups, or IET. Can you do this with DRBD? Sure you can.

However, you need to fulfill two prerequisites:

  • Your application can’t access DRBD while it’s in the Secondary role. So, you must make sure DRBD is Primary before your application attempts using that device.
  • The user in whose context your application runs needs read/write access to that device.
  • Your cluster manager, when configured properly, normally takes care of item #1 for you. #2 is a little trickier:
    Normally, DRBD’s device nodes are owned by root:disk, with permission bits set to 0660 (rw-rw----). So in order to allow your

      [Read more...]
    DRBD and kernel upgrades
    +0 Vote Up -0Vote Down

    A question I recently got from our friends at MySQL (http://www.mysql.com/drbd):

    When speaking about DRBD, we mention that if you upgrade your Linux kernel, it is important that you also upgrade the version of DRBD appropriately.
    Question: When upgrading the kernel via yum/yast, does it automatically detect that you should also upgrade your DRBD module?

    The answer is, as always, a clear and resounding “it depends.”
    Let’s break this down by distribution.

    • If you’re on Debian and updating your linux-image package, dpkg will complain about an unresolved dependency from the DRBD kernel module package, forcing you to update that as well.
    • If you’re on Debian and adding a more


      [Read more...]
    Previous 30 Newer Entries Showing entries 31 to 49

    Planet MySQL © 1995, 2013, 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.