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:

This Week in Website Performance is a weekly feature of the Monitis.com blog. It summarizes recent articles about website performance. Why? Because your friends at Monitis.com care.

Full table scan vs full index scan performance

Author: Stephane Combaudon.

Using full index scans are not always faster than a full table scan. Stephane explores the situations in which a sequential read through of a full table performs better than using randomly-read full index.

Big Data …

First 10 to register this week will benefit from a 40% discount

The Percona Live MySQL Conference: London 2012 is just around the corner and we’ll be present both with talks as well as in the exhibition hall alongside other sponsors of the conference.

Talks & Hot Topics

Our very own Ivan Zoratti has the following two talks on Tuesday December 4th:

read more

Ashisuto greatly expands support services for Enterprise users of MySQL & MariaDB open source database software

So, this is exciting news and something that my colleague Daniel Saito had been working on for years: enterprise-ready, 24/365 Japanese support for the MySQL and MariaDB databases!

read more

Une soirée de conférence et networking intitulée: "MySQL, le Cloud et MariaDB" Invitation - Meetup SkySQL

Mercredi 12 décembre 2012 de 19h à 22h30

SkySQL Ab vous invite à une soirée de conférence et networking intitulée :

« MySQL, le Cloud et MariaDB »

read more