Ideas, releases, practical guides, and perspectives from the people building with MySQL.
Thanks to everyone who joined us for our recent live webinar on ‘Replication Topology Changes for MySQL and MariaDB’ led by Krzysztof Książek, Senior Support Engineer at Severalnines. The replay and slides to the webinar are now available to watch and read online via the links below.
Watch the replay
Webinar: Replication Topology Changes for MySQL and MariaDB from Severalnines AB
Read the slides
Webinar slides: Replication Topology Changes for MySQL and MariaDB from …
[Read more]I have released MySQL-Sandbox 3.1.01, which is the first release after the move to GitHub. While the changes are not so spectacular (it's a minor release, with mostly bug fixes), I am pleased to see that the move has started producing collaboration. Two of the changes were provided by Daniël van Eeden and Mark Leith, who have scratched some of their own itches by providing useful patches.
All in all, this period of working with GitHub has been liberating. Although Bazaar plays with the same principles of git, it lacks most of the tools and the know-how which characterizes git. Add to this that also my team has moved Tungsten Replicator …
[Read more]I was thinking if my work environment would be interesting or not, but I decided ‘yes’ – because I always like reading about others work env.
I am working with Linux/UNIX for more than 15 years now, and I have tried a lot of cool tools, but at the end, I always found myself using the same apps in terminal.
I like the unix philosophy about Do One Thing and Do It Well. I never really use big, bloated software, I like to use my editor for editing files, and my git client to use git. That’s simple.
Normally I work from a mac, but I have an installed linux based backup environment too, on a remote server which can be accessed via ssh.
The basic tool for me is iTerm2. The main features I use are split pane (cmd+D vertical, cmd+shift+D horiontal) and broadcast input (cmd+shift+I). I also like that it can be switched to fullscreen with cmd+enter. In …
[Read more]I was recently downloading and trying to run a MySQL docker image which worked just fine on top of a Hyper-V based Ubuntu 14.04 LTS. Don’t worry, this is still Entity Framework Code-First migration article with Visual Studio 2015 and MySQL 5.6.27 (latest as of today). I setup a Docker MySQL Image on my Ubuntu based Docker host. I was thinking what could be a best way to test this instance out with .NET than testing it with our good friend Entity Framework Code-First migration. This is really going to hit the MySQL instance hard by creating DB on its own and creating all the Model Tables on its own with little or no involvement of MYSQL DDL /DMLs. Prerequisites : – To start using Entity Framework 6 and Visual Studio 2015 is necessary to install
Today’s topic is about how to test Group Replication plugin in
easy way, with using MySQL Sandbox
But firstly we must compile MySQL with Group Replication plugin,
refer to previous topic -> Compiling Group Replication Plugin
Who did not use Sandbox before, please refer to official link and read a bit more. It is wonderful tool for installing, testing new things with MySQL. Especially if you have new MySQL release to test and want to install 3 or 5 instances, just use MySQL Sandbox and it will do this work for you.
In our condition, we have already compiled MySQL with our plugin. So we have source folder in -> /home/sh/Sandboxes/mysql-group-replication-0.5.0-dmr/BIN
…
[Read more]Next November I’ll once again take the ferry to my neighbour city of Buenos Aires to enjoy two days of learning, networking, and presenting, at DataOps LA 2015, the first incarnation of what used to be the MySQL, NoSQL, Cloud Conference organized by BinLogic in Buenos Aires.
Next November I’ll once again take the ferry to my neighbour city of Buenos Aires to enjoy two days of learning, networking, and presenting, at DataOps LA 2015, the first incarnation of what used to be the MySQL, NoSQL, Cloud Conference organized by BinLogic in Buenos Aires.
Next November I'll once again take the ferry to my neighbour city of Buenos Aires to enjoy two days of learning, networking, and presenting, at DataOps LA 2015, the first incarnation of what used to be the MySQL, NoSQL, Cloud Conference organized by BinLogic in Buenos Aires.
Currently we have one database cluster with 15 different schemas – these schemas could be either schemas which contain “real” data, or just schemas with metadata.
I guess the next evolutionary step of our database stack would be to split up the database cluster vertically along these schemas. All the data schemas should be moved to standalone mysql instances, and put the metadata schemas next to them. This also could be a good project for prepare to move a certain part of database for example to a cloud provider while other parts are still kept on bare metal.
I started wondering what could be the best way to split MySQL instances in a single hardware. I have the following ideas:
The first …
[Read more]Data plays a big role at Pinterest, in both enabling new product experiences for Pinners and providing insights into Pinner behavior. We’re always thinking of ways to reduce the friction of converting our data into actionable insight. A question often asked by our data users (primarily analysts, product managers, engineers and data scientists) is, “How can I build a reporting dashboard to track xyz metrics daily?”. As the number of employees accessing data, the volume of data and the number of queries increased, scaling and supporting emerging requirements became a big challenge. In order to tackle this, we built a new data platform called Skyline.
Before the birth of Skyline, data users were dependent on data engineers to: