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 …

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

…

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:

• Hack init scripts to start different instances on different ports (and log directories, data directories, config files too)
• Use mysqld_multi
• Use MySQL Sandbox
• Use docker

The first …

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:

• Find the right tables to query
• Productionize the query as an Extract, Transform and Load ( …

AWS CloudFormation now supports Amazon Aurora!

Announcement: https://forums.aws.amazon.com/ann.jspa?annID=3286

Documentation:

http://docs.aws.amazon.com/AWSCloudFormation/latest/UserGuide/aws-resource-rds-dbcluster.html

Amazon Aurora is a MySQL-compatible, relational database engine that combines the speed and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. https://aws.amazon.com/rds/aurora/

AWS CloudFormation gives developers and systems administrators an easy way to create and manage a collection of related AWS resources, provisioning and updating them in an orderly and …

This Log Buffer Edition finds and publishes blog posts from Oracle, SQL Server and MySQL.

Oracle:

• SCRIPT execution errors when creating a DBaaS instance with local and cloud backups.
• Designing Surrogate vs Natural Keys with Oracle SQL Developer.
• EBS General Ledger – Accounting Hub Reporting Cloud Service.
• Oracle Database Standard Edition 2 is available.
• Disable “Build After Save at …