MySQL User Group meeting in Sweden coming up!

Agenda is not finalized yet but we are going to talk about:
- News from MySQL Connect - MySQL 5.6 RC
- MySQL partitioning
- Handling character set and collations

Location:
Munchen Bryggeriet Soder Malarstrand 57B (6th floor)
Stockholm, 118 25

Time: 15:00 - 18:00

You can register for event here

See you there!

I am very excited to share that today Zmanda has combined forces with Carbonite - the best known brand in cloud backup. I want to take this opportunity to introduce you to Carbonite and tell you what this announcement means to the extended Zmanda family, including our employees, customers, resellers and partners.

First, we become “Zmanda - A Carbonite Company” instead of “Zmanda, Inc.” and I will continue to lead the Zmanda business operations. Carbonite will continue to focus on backing up desktops, laptops, file servers, and mobile devices. Zmanda will continue to focus on backup of servers and databases. Carbonite’s sales team will start selling Zmanda Cloud Backup directly and through its channels. Since Carbonite already has a much larger installed base of users and resellers, our growth should …

I’ve been doing a little bit of programming in Go recently, and really enjoying it. It’s an awesome language with really solid libraries. It reminds me a lot of the .NET framework in that it’s well-thought-out, but the Go language itself is a lot smaller, less formal, and a lot more expressive than I ever found C# to be. And that’s saying a lot – C# was my previous favorite language, along with the occasional Java, C++, Python, JavaScript, and – gasp – Visual Basic 6.

I was just skimming through the latest “Meet the Experts” podcast from Oracle, whose topic is debugging stored routines in MySQL. The tl;dr (tl;dl?) version is if you’re working with Windows and .NET, you can install a Visual Studio plugin that lets you debug stored routines in the server via the .NET connection libraries. That’s pretty nice, for those who are using that platform. The podcast is only a few minutes, so if you’re interested, by all means listen to it, or take a look at the documentation.

The mysqlbinlog are not new. We often reference it and all of the valuable information that it provides. I thought it might be useful to show some simple examples on how to get some of that information, for those unfamiliar with the mysqlbinlog tool.

For this example, I used the MySQL benchmark tools to populate data.

You can review binary log events a couple if different ways.
You can use the command line :

      mysqlbinlog mysql56rc-bin.000010
or within MySQL via a simple query.
      SHOW BINLOG EVENTS IN 'mysql56rc-bin.000010' ;

These will both dump out all of the data, and this demo currently has 2284725 rows of data, to much to review …

So, do you really need phpMyAdmin to access MySQL database on a shared hosting?

NO, you don’t need it, but popular hosting services like GoDaddy integrate phpMyAdmin to facilitate access to MySQL server. Of course phpMyAdmin is a nice tool, no offense, but what if you prefer a desktop application over phpMyAdmin, or you are a developer working on an application that needs to access the MySQL database on a shared hosting? That desktop application I’m referring to is SQLyog. So how does SQLyog access the MySQL database on a shared hosting? And how you can do the same with your own application?

The Problem

Shared hosting is your best option if you have a personal website, or you own a small business and wish to leverage your online presence to get it noticed. They are cheap, you don’t have to manually …

Read the original article at Real Disaster Recovery Lessons from Sandy

Also find Sean Hull’s ramblings on twitter @hullsean. Having just spent the last 24 hours in lower manhattan, while Hurricane Sandy rolled through, it’s offered some first hand lessons on disaster recovery. Watching the city and state officials, Con Edison, first responders and hospitals deal with the disaster brings some salient insights. 1. What are [...]

For more articles like these go to Sean Hull's Scalable Startups

Related posts:

1. What is disaster recovery and why is it important?
2. …

"Hey, Kris! We got a connection surge on $IMPORTANT_MASTER, and a short activity drop preceding that. All other graphs are flat."



and



I am looking.
Continue reading "Enemy Action"

As the title suggests, I will be giving a tutorial about MySQL Scaling Strategies for Developers.

I gave a similar tutorial last year at this conference, however, going over my old slides, I had to almost completely start from scratch.

Since last year, some things have changed  in the MySQL ecosystem and my experience and knowledge has improved as well. I also took on the feedback I had from last year and made changes:
The first part of the tutorial was slow and the second part (the more interesting part) was too fast.

This year, I promise that my tutorial will be between x2.5 to x7 better than it was last year.
Better in terms of higher quality content and better in terms of the knowledge you will remember after you leave.

I hope to see you …

To repeat myself (from “part 2″):

“a while back I wrote a post expressing a longing for wait-interface tuning”.

The original post, and “part 2″ were both written in 2007, while I was working for a startup in Pasadena, as a DBA.  Now I work for Oracle, supporting MySQL, and by now, MySQL has incorporated a wait interface.  So, to do justice, I am writing this “part 3″ and saying – it’s been done!

MySQL now has the performance schema, which instruments a vast number of events and waits.  The man page for the current GA version (5.5) is at http://dev.mysql.com/doc/refman/5.5/en/performance-schema.html .   It’s a big chapter, as the wait interface is highly configurable and versatile.

…