WHEN YOU SCALE OUT HOW TO SCALE IN BY INCREASING DENSITY USING RAIDED SSD
Sharding-splitting data for a single database server onto many database servers is a method to scale horizontally and is needed to get more disk IOPS from a mechanical hard drive server architecture. A method that works yet has pitfalls, which this session talks about. The focus is what happens when Solid State Disk Drives replaces traditional mechanical hard drives (spinning metal) in a sharded environment and answers to questions like
How much more IOPS with SSD?
What Raid Levels and Controllers work SSD drives?
How do you migrate data from shards to increase density on SSD Shards?
Why Multi MySQL, Instances per SSD server is great.
How INNODB compression really helps in an …

I enjoyed Stewart Smith’s MySQL storage engine blog last week. In it he noted “I cannot emphasize how much more interesting TokuDB would be if it were open source.” Well, with our open source announcement yesterday, hopefully we are getting interesting.

We wanted to thank everyone for the great feedback. Here is a sampling from some of the forums where dialogue is occurring:

Reddit:

BrianAtDTS: “With this update, this puts MySQL in the upper echelon of data storage applications. You don’t have anything like this in any of the other major db’s.”

…

Cryogenic Dolphin

Thanks to all who came to the MySQL Community Reception last night. Food, drink, and lots of great folks talking about MySQL.

We even had a Raspberry PI based MySQL Cluster on display

Raspberry PI MySQL Cluster

and one of the Pi was given away as a door prize (Congrats Jens).

What happened in Santa Clara does not stay in Santa Clara

But the hit if the evening was the Cryogenic Dolphin or a Sakila made of ice.

We’re ironing out a kink that’s preventing Planet MySQL from aggregating VividCortex’s blog feed, so while that’s in progress, I’ll post a quick note on what we’re up to at VividCortex, for the Planet MySQL readers.

VividCortex is a monitoring and analysis product for MySQL, provided as Software-As-A-Service, with agents that run in your systems and report back to our APIs. The agents are super-efficient and non-obtrusive (you’ve probably noticed my posts about Go recently). They gather high-resolution data about your systems and our web application helps you make sense of it.

VividCortex is shockingly easy to install — if you’re slow at the keyboard, it takes 30 seconds. In less than a minute you can get insight into what your MySQL servers are doing. We are in closed beta right now, with a long waiting list. We’re working with a small set of alpha customers …

For me, the biggest news in the last 24 hours so far has been:

1. SkySQL merges with Monty Program, developers of MariaDB. This of course affects me directly and leads to a change in affiliation in a few months.
2. TokuDB goes opensource. I think this is really big news. Beyond just the fact that it can now be a storage engine in the main MariaDB tree, I love the work they’re doing to extend it to be an engine for MongoDB as well.
3. …

Introduction
  For a long time there was a Bug#6295 in implementation of BEFORE triggers related to handling of NOT NULL column. The problem was that if a column is declared as NOT NULL, it wasn't possible to do INSERT NULL (or UPDATE to NULL) even though there was associated trigger, setting NOT-NULL value.
For example:

• There is the table 't1' with a NOT NULL column 'c1'
• The table has BEFORE INSERT trigger which sets the 'c1' column to NOT NULL value (SET NEW.c1 = 1)
• User executes the SQL statement INSERT INTO t1 VALUES(NULL) that fails with the following error:     ERROR 1048 (23000): Column 'c1' cannot be null
• The user will get the same error if there is a BEFORE UPDATE trigger that sets the 'c1' column to NOT NULL and  the …

SkySQL has signed a merger agreement with Monty Program Ab, creators of the popular MariaDB database. Read more about it, as it features important tidbits from Patrik Sallner (CEO, SkySQL Ab), Simon Phipps (CEO, MariaDB Foundation), and Michael “Monty” Widenius (CTO, MariaDB Foundation).

A key takeaway is that SkySQL will work alongside & collaborate closely with the MariaDB Foundation, plus continue to invest in the development of the MariaDB server.

SkySQL today announced that it has signed a merger agreement with Monty Program Ab, creators of the fastest growing open source database technology: MariaDB.  This merger reunites key members of the original MySQL AB developer and services teams. Their aim is to develop MariaDB into a truly interoperable, NewSQL open source database in collaboration with its customers, partners and the community. The company also pledges to further evolve its offering for users of the MySQL database.

read more

SkySQL today announced that it has signed a merger agreement with Monty Program Ab, creators of the fastest growing open source database technology: MariaDB.  This merger reunites key members of the original MySQL AB developer and services teams. Their aim is to develop MariaDB into a truly interoperable, NewSQL open source database in collaboration with its customers, partners and the community. The company also pledges to further evolve its offering for users of the MySQL database.

read more

Hi there !

This is the final part of using openconnect  - You can check the older ones below:

http://www.heitorlessa.com/connecting-your-linux-to-a-cisco-anyconnect-ssl-part-1/

http://www.heitorlessa.com/connecting-your-linux-to-a-cisco-anyconnect-ssl-part-2/

As mentioned previously, we will be covering here:

• How to create a script to monitor such VPN using ICMP, and restart that VPN if it is down
  

I would say, this is very straight forward and does not require much knowledge, so we are going to follow the same procedure as part 2 – Show the script in parts and then a …