MySQL Fabric is a very promising sharding framework. If I take Ulf Wendel definition of MySQL Fabric :
MySQL Fabric is an administration tool to build large “farms” of MySQL servers. In its most basic form, a farm is a collection of MySQL Replication clusters. In its most advanced form, a farm is a collection of [...]
Chuck Bell, one of my former colleague from MySQL AB, has created a connector for Arduino to MySQL. So this allows Arduino code to be a direct client of a MySQL or MariaDB server, with Ethernet and WiFi shields supported.
With Arduino boards being used more and more, this can come in really handy – not only for retrieving (for instance) centralised configuration data, but also for logging. Useful stuff. Thanks Chuck!
Links
October 28, 2013 By Severalnines
Data protection is vital for DB admins, especially when it involves data that is accessed and updated 24 hours a day. Clustering and replication are techniques that provide protection against failures, but what if a user or DBA issues a detrimental command against one of the databases? A user might erroneously delete or update the contents of one or more tables, drop database objects that are still needed during an update to an application, or run a large batch update that fails midway. How do we recover lost data?
In a previous post, we showed you how to do a full restore from backup. Great, now you’ve restored up to the last incremental backup that was done at 6am this morning. But how about the rest of the data?
This is where you’d do a …
[Read more]October 23, 2013 By Severalnines
Last week, the Severalnines & Codership teams came together to co-host two webinar sessions on Galera 3.0, MySQL 5.6, Global Transaction IDs and WAN. The sessions were held during EMEA/APAC as well as NA/LATAM timezones, which worked out quite nicely. Our speakers were Seppo Jaakola from Codership & Vinay Joosery from Severalnines.
Webinar topics:
The upcoming Percona Live London conference, November 11-12, features quite a number of talks about the latest MySQL features and related technologies. There will be a lots of talks about the new MySQL 5.6 features:
I have blogged on using MariaDB Dynamic Columns already, and I
hope this was useful and introduction. I have a few more things
on this subject though, but one so far little known and used
feature is the Client API for Dynamic Columns, see the MariaDB Knowledge Base for details. What this is
all about is that Dynamic Columns were originally envisioned as a
means of managing the "dynamic columns" used by Cassandra when
using the MariaDB Cassandra Storage Engine. But as we realize,
this is the server side of things (the Storage Engine) but there
is a corresponding client library also, that is part of the
MariaDB Client API.
As you have seen if you have read my previous blog on this
subject, or whatever is written about MariaDB Dynamic Columns
elsewhere, …
Saw this on @awsmarketplace the other day:
#opensource #MariaDB by @SkySQL on @AWSMarketplace http://t.co/o3KQ9xe9sr #mysql
— AWS Marketplace (@awsmarketplace) October 8, 2013
Now on the AWS Marketplace, you can …
[Read more]We all know that MySQL says it is "the world's most popular open-source database". And PostgreSQL has a firm hold on second place while claiming to be, instead, "the world's most advanced open source database". But the horse that comes in third can return some money to gamblers who bet "to show". And the horse that shows momentum or gets close is worth watching for next time.
So I'll just ignore the dolphin and the elephant in the room, and go on to a harder question: who's number three?
According to Wikipedia
To find out how many times someone has expressed interest in a topic, I can go to stats.grok.se and ask how many times someone has looked at that topic's page in Wikipedia. Evil-thinking people could manipulate these numbers with ease, but until now they have …
[Read more]Recently Todd blogged about why you should register for MySQL 5.6 certification exams now: http://mysqlblog.fivefarmers.com/2013/10/04/why-you-should-register-for-mysql-5-6-certification-exams-now/ and i also think that now is a good opportunity to renew or take a new mysql certification.
The most interesting point in my opinion is that you can save a lot of money if you take the exam NOW! The exam price is 50 dollar (39 Euro) till 14.12.2013.
So, if you want to update your, probably years old, mysql certification now is the time! You can search for a test center and register for the exam here:
http://pearsonvue.com/oracle/
Be aware that you won’t get your results directly but after a few weeks. Also there are about 150-220 questions! Phew! All information about the exam can be found here:
…
[Read more]Today as i was learning for the new MySQL 5.6-certification (more about that in a later post) i stumbled again across the host_cache-Table that was added to MySQL in 5.6.5. Before that you had no chance to check which hosts are already known by the MySQL-server.
So thats a pretty good feature for us. And even better: you could resize the size of the host_cache now! Whoohoo, awesome! As we have a lot of servers that need to connect to one of our MySQL-server and we could not switch to ip-based-authentication we were really happy to tune the host_cache-size without recompiling MySQL.
Unfortunately i noticed that the performance_schema.host_cache table only holds 128 rows and that the content was changing everytime i checked. So i logged in to a server that wasn’t already in the host_cache-table, made a connection attempt to the mysql server and checked again the host_cache-table:
The server was now in the …
[Read more]