The MySQL binary package have been growing a lot the last GA versions. I wrote a blog post on creating a minimal installation a bit over a year ago and after this we have seen some interesting posts by Mablomy and Giuseppe on creating smaller installations of MySQL for different purposes.

I will continue where Mablomy left off and use UPX to try to shrink the MySQL binary even more. UPX (Ultimate Packer for Executables) is a free and open source executable packer supporting a number of file formats from different operating systems. If you want …

Vadim Tkachenko and I have been working with Fractal Tree® storage engines (Fractal Tree engines are available in Percona Server for MySQL and MongoDB as TokuDB and PerconaFT, respectively). While doing so, we’ve become interested evaluating database compression methods, to see how to make compression algorithms work even better than they do currently.  

In this blog post, I will discuss what we found in our compression research.

Introduction

Before we get to evaluation database compression methods, let’s review what compression properties are most relevant to databases in general. The first thing to consider is compression and decompression performance. Databases tend to be very sensitive to decompression performance, as it is often done in the “foreground” – …

Oracle University recently unveiled a new online training offering – the MySQL Learning Subscription.  The combination of freely-accessible and compelling paid content makes this an exciting development to me, and should prove valuable to the community and customer base alike.  This post will briefly explore this new MySQL educational resource.

Organization

The subscription content is organized into topical “channels”.  Current top-level channels are:

• Getting Started
• Development
• Administration
• Security

These channels have sub-channels as well – for example, the Getting Started channel includes Getting Started With MySQL New Features and MySQL For Beginners, …

iyzico uses ClusterControl to increase MySQL database uptime

Stockholm, Sweden and anywhere else in the world - 09 March 2016 - Severalnines, the provider of database automation and management software, today announced its latest customer, iyzico, a Turkish Payment Service Provider (PSP) that offers ecommerce merchants and marketplaces like sahibinden.com, Modanisa and Babil an efficient way to accept online payments in Turkey. It also provides other services such as analytics, fraud protection and settlement.

iyzico helps over 27,000 registered merchants navigate the difficult and complicated merchant registration process for vPOS in Turkey. The complicated process often results in rejection rates as high as 80% for some businesses. iyzico makes it easier for merchants to start selling in Turkey via a single integration …

When you are working on laravel projects and you need to use mysql function in where clause then you can easily use that using DBraw and whereRaw In this example you can show how to i use mysql function in where clause In this example i want to compare with year of createdat field but not w

When you are working on laravel projects and you need to use mysql function in where clause then you can easily use that using DBraw and whereRaw In this example you can show how to i use mysql function in where clause In this example i want to compare with year of createdat field but not w

Whenever you need to get nearest posts from lat and long and if you are working on laravel query builder then you can get distance easily using DBraw so you can learn from following example how to get nearest value from mysql laravelstrongExamplestrongpre classprettyprint langphp

Whenever you need to get nearest posts from lat and long and if you are working on laravel query builder then you can get distance easily using DBraw so you can learn from following example how to get nearest value from mysql laravelstrongExamplestrongpre classprettyprint langphp

Sometimes you require to add trigger in your mysql database of laravel 5 but you think how to create trigger using laravel migration because laravel not provide special function like insertTrigger and something so it problem to create direclty But laravel DBunprepared through we can create tri

Sometimes you require to add trigger in your mysql database of laravel 5 but you think how to create trigger using laravel migration because laravel not provide special function like insertTrigger and something so it problem to create direclty But laravel DBunprepared through we can create tri