I recently worked on a Rails 3.2 project that used the sweet PLupload JavaScript/Flash upload tool to upload files to the web app. To make it easier for users to upload large and/or remote files to the app, we also wanted to let them upload via SFTP. The catch was, our users didn't have SFTP accounts on our server and we didn't want to get into the business of creating and managing SFTP accounts. Enter: ProFTPD and virtual users.

ProFTPD's virtual users concept allows you to point ProFTPD at a SQL database for your user and group authentication. This means SFTP logins don't need actual system logins (although you can mix and match if you want). Naturally, this is perfect for dynamically creating and destroying SFTP accounts. …

She hired the 400+ original MySQLers … and sets out to hire the SkySQLers of tomorrow! Boel Larsen blogs about open positions & life at SkySQL - and wants you to join the fun!

Those of you who know me also know that I spent over six years working for MySQL HR (for another couple of years I stayed on with Sun).  I joined as employee thirty-something, so running HR meant that I was more or less involved with hiring all of the 400 or so employees who joined after me. I knew pretty much everyone by name.

read more

In my ongoing efforts to migrate my fun side projects and coding experiments from SVN to Git I’ve come across some of my favorite Python based apps – which are all available in their respective repos on BitBucket, as follows:

IRC Bot Commander

• What it does: it’s an IRC bot that takes commands and does your bidding on whichever remote server the bot is installed on.
• How it does it: the bot runs on whatever server you install it on, then it connects to the IRC server and channel you configured it to connect to and it waits for you to give it commands, then it execs the commands and returns the output to your IRC chat window.

MacroBase – MySQL Analytics

…

As this topic came up a few times this week for discussion at various places, I thought of composing a post on “Data Scientist vs. Data Analytics Engineer”; even though[...]

2nd release of SkySQL™ Cloud Data Suite provides users with customisation capabilities for free cloud database deployments Update release: SkySQL™ Cloud Data Suite

SkySQL™ Cloud Data Suite is a collection of software components that provides a highly available database solution in a cloud environment based on MariaDB and 100% compatible with the MySQL database. It includes the following features:

• An automatic configurator
• An administrative console with ...
  • A graphical backup and recovery manager
  • The ability to deploy each instance securely within the user’s environment
  • Feature-rich, web-based query tools
  • An advanced monitoring tool
• A full set of HA solutions (synchronous and asynchronous)

…

Apart from my consulting as part of ScaleIn, I also invest to bootstrap companies with really disruptive ideas; and in the process met few database specific companies who are already[...]

Here is the typical “Big” data architecture, that covers most components involved in the data pipeline. More or less, we have the same architecture in production in number of places[...]

I was tired to get manually disk space used for all MySQL databases, I just created a stored procedure to get an overview of the database sizes in our MySQL server.

MySQL don’t have a command that allows us an overall summary of the databases, something like SHOW TABLE STATUS for databases. The “SHOW DATABASES” command lists only the current databases without any other information like how many space are using or how many tables there are, etc.

The procedure that I wrote this based on INFORMATION_SCHEMA database, which contains rich information of all existing databases.

I suggest, in a previous post, place all these procedures in a database called tools, but you can still choose different location.

So when call the procedure will have a global view of information that will be useful for maintenance tasks.

mysql> call tools.sp_overview(); …

Connectors now available to the MySQL®community as part of the MariaDB open source project

So ... We (Monty Program & SkySQL) have just announced the immediate availability of the connectors, ‘MariaDB Client Library for C and MariaDB Client Library for Java Applications’, to the wider MySQL® database community in the permissive LGPL licence.

With this announcement, the connectors become part of the wider MariaDB open source project, to which users will be able to contribute via relevant online resources.

read more

Now that the thanksgiving holiday is over, it seems like the perfect time to have another #DBHangOps. If you’re interested, check this twitter search or check back on my blog here for a link to the google hangout.

Items currently on our agenda for today:
* Data corruption!
* Monitoring — what do you monitor, why, etc.
* Query killing — do you kill queries in production regularly, or in emergencies?
* Fun or useful configurations

Looking forward to chatting about MySQL stuff today!
Fun time hitting these topics this week. Check out the recording: