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 51

Displaying posts with tag: Clustering (reset)

Monolith Toolkit - MySQL DBA tools released!
+0 Vote Up -0Vote Down

Today I decided to package all of my various scripts together into a useful toolkit. Some are perl, some are shell script. These scripts are, in general, one off scripts that I wrote in order to get things done that weren’t available at the time. Now they’re nicely organized and will receive updates at the google code repo.

So far the toolkit includes the following scripts:

  • mt-backup-parallel -> the parallel backup script I wrote about in my last post
  • mt-check-replication -> script to report on replication status for slave servers
  • mt-check-rhcluster-filesystems -> reports on redhat cluster filesystems (for mysql active/passive clustering)
  • mt-connections-log -> logs connections to mysql to disk, reports on threshold overages
  • mt-flush-tables-sequence -> runs
  [Read more...]
Continuent launches Tungsten project for database scale-out
+0 Vote Up -0Vote Down

Continuent is probably best known for its database clustering technology for MySQL, as well as PostgreSQL, but the company has for some time had its sights set on expanding beyond open source databases and enabling horizontal database scalability.

It has just taken a major step towards delivering on both counts with the launch of Tungsten, its new stack of open source middleware technologies designed to enable low-cost databases to scale horizontally for database failover and continuity.

Tungsten includes includes Sequoia, the existing synchronous

  [Read more...]
Spinn3r Hiring Senior Systems Administrator
+0 Vote Up -0Vote Down

Spinn3r is hiring for an experienced Senior Systems Administrator with solid Linux and MySQL skills and a passion for building scalable and high performance infrastructure.

About Spinn3r:

Spinn3r is a licensed weblog crawler used by search engines, weblog analytic companies, and generally anyone who needs access to high quality weblog data.

We crawl the entire blogosphere in realtime, remove spam, rank, and classifying blogs, and provide this information to our customers.

Spinn3r is rare in the startup world in that we’re actually profitable. We’ve proven our business model which gives us a significant advantage in future


  [Read more...]
Using ZooKeeper to configure External Monitoring Systems
+0 Vote Up -0Vote Down

I’m going to be migrating to using ZooKeeper within Spinn3r for a myriad of reasons but this one is especially powerful.

One could use ZooKeeper to configure external monitoring systems like Munin and Ganglia.

ZooKeeper enables this with its support for ephemeral files.

If you have an external process like a webserver, database, robot, etc you can have it create a ephemeral file which registers its services and presence in the cluster.

For example:

/services/www/www32.mydomain.com/80

Would represent a machine named www32.mydomain.com.

You can then have munin connect to ZooKeeper and enumerate files in /services/www and have a


  [Read more...]
RAM vs SSD Based Databases
+0 Vote Up -0Vote Down
A
Final Thoughts on SSD and MySQL AKA Battleship Spinn3r
+0 Vote Up -0Vote Down
A
Independent Mtron SSD + MyISAM Benchmarks
+0 Vote Up -0Vote Down
A
Hypertable is out.
+0 Vote Up -0Vote Down
A
Roll your own N-server sandbox
+0 Vote Up -0Vote Down
Have you ever wanted to play around with(test ;) MySQL replication/clustering techniques, LVS/Apache load balancing etc but didn't have the hardware available and where smart enough not to use a production environment?

Well an easy way to be able to do this is by creating a sandbox environment using something like qemu, xen, vmware or UML which allow you to create virtual machines running inside a protected environment on your own desktop machine or whatever hardware you have spare, just be sure you have enough memory. This article will cover setting up a sandbox using UML.

My GNU distro of choice is Archlinux and this article will be based around it, but you should be able to take



  [Read more...]
More SSD vs HDD vs InnoDB vs MyISAM Numbers
+0 Vote Up -0Vote Down
A
24 Hours with an SSD and MySQL
+0 Vote Up -0Vote Down
A
Thoughts on SSD and MySQL 5.1
+0 Vote Up -0Vote Down
A
Zeus IOPS - Another High Performance SSD
+0 Vote Up -0Vote Down
A
Sun Buys MySQL - Good Call
+0 Vote Up -0Vote Down
A
Spinn3r Talk Accepted at 2008 MySQL Users Conference
+0 Vote Up -0Vote Down
A
Powerset + Hadoop @ Rapleaf
+0 Vote Up -0Vote Down
A
MySQL Storage Engine Services
+0 Vote Up -0Vote Down
A
MySQL and Disk Transfers Per Second
+0 Vote Up -0Vote Down
A
High Performance MySQL, Second Edition: Replication, Scaling and High Availability
+0 Vote Up -0Vote Down

Continuing in the tradition, which I hope has been as helpful to you as it has been to me, I'm opening the floor for suggestions on chapter 9 of the upcoming High Performance MySQL, Second Edition. Unlike the other chapters for which I've listed outlines, this one isn't substantially written yet. It's in detailed outline form at this point (a tactic that has worked very well for us so far -- I'll write about that someday).

I'm trying to get feedback much earlier in this chapter's lifecycle, for several reasons. Two of the most important are that this is one of the first chapters I've had a chance to really take from scratch, and the chapters I haven't written from scratch have been harder to organize, as you've probably seen from the last few outlines I posted. There's a lot of value in working top-down on this deep encyclopedia-style material.

Read on for the outline and more thoughts I just can't keep to myself.

Using O_DIRECT on Linux and INNODB to Fix Swap Insanity
+0 Vote Up -0Vote Down
A
MySQL: getting started for newbies
+0 Vote Up -0Vote Down
When MySQL first came out and started popping up all over the web in the e-commerce arena, if you were like me you looked at it as a wannabe. 'Call me in a few years when you grow up'. Yea, sometimes the Oracle in us goes to our heads a little to fast...MySQL has really gone mainstream in the last few years. Companies that never would have considered MySQL in the past for critical database
Previous 30 Newer Entries Showing entries 31 to 51

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.