It seems there’s lot of activity in Barcelona, Spain in the coming weeks. Lenz Grimmer talks about speaking at LinuxCon Europe (Nov 5-9), where the conference really runs from Nov 5-7. I’m happy to be speaking about MariaDB on the 5th. Monty Program & SkySQL are joint-booth-sponsors of this event, so expect there to be a presence for Q&A at the booths.
While I wish I can stay on for the meetup organized by …
[Read more]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 ideal way to debug stored routines would be an API in the server, but that doesn’t exist. Nevertheless, I remembered having seen some sort-of implementations of debugging at times in the past. My memory was …
[Read more]I’ll speak at the Central Virginia Ruby Enthusiasts group on Nov 13th. The topic is adaptive fault detection in MySQL servers. The techniques apply to any system for which you can measure throughput and concurrency, so come on out and learn how you can get rid of threshold-based monitoring!
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. Go beats them all.
But I digress. I’m writing Go applications that talk to MySQL. Some of them talk to the database in read-only ways, and I just wanted to share this neat little nugget about the MyMySQL client libraries (pure-Go implementation; not a wrapper around a C library). One of its features, which you can enable optionally, is autorc. This stands for auto-reconnect to the server. It’s …
[Read more]
A new "Meet the
MySQL Experts Podcasts" is available.
Debugging Stored Routines in MySQL with
Fernando Gonzalez.
A big thanks to Fernando and the Podcast team at Oracle for
helping with this podcast.
November is here and what do we have to be thankful for? A great
community overall is the simple answer.
This month looks to have some great MySQL User Group
Meetups:
It’s been a while since my post on taking day 1 of this course; as promised, here are my notes and observations after taking Day 2.
First, this is one of the nice things about taking Training on Demand. I could take Day 1, go about my other business, apply what I learned, etc, then, when ready, take Day 2, even a month or so later! I was able to go back and review Day 1, then move on to Day 2, entirely at my own schedule.
I remembered something from earlier, and wanted to find it again, so I tried out the search capabilities. I searched for the phrase I wanted, and up came links to the lessons it appeared in. I could click on any of the results to view that lesson, and watch, or check the captioning to find the phrase I was looking for. It worked perfectly!
Day 2 covers data types, basic SELECT queries, and how to create and maintain tables and databases (using DROP and ALTER, and how they …
[Read more]The on-demand webinar for the MySQL Cluster 7.3 Development Release is now available.
You can learn more about the design, implementation and getting started with all of the new MySQL Cluster 7.3 features from the comfort and convenience of your own device, including:
- Foreign Key constraints in MySQL Cluster
- Auto-installation of higher performance distributed, clusters
We received some great questions over the course of the webinar, and I wanted to share …
[Read more]Read the original article at Cloud Deployment Interview
What does a cloud computing expert need to know? In part one of the cloud interview guide we covered some basic unix & Linux systems administration skills, and cloud computing and infrastructure concepts. Those are key starting points. You might also want to jump to part 3 cloud dba, architecture and management interview questions.
In this second part, let’s dig into deploying applications in the cloud, and day to day operations skills. There’s a lot of material here. We recommend …
[Read more]Stockholm will host the Swedish MySQL Users Group on November 21st and the details can be found at http://www.facebook.com/events/468752256510179/
We will talk about news from MySQL Connect, which was a few weeks ago, especially if 5.6RC course! * We will have a review of partitioning with a developer who has worked with just that. * Our last point is a review of a beloved children – character sets in MySQL. One common source of headaches.
