Welcome to this week’s Planets9s, covering all the latest resources and technologies we create around automation and management of open source database infrastructures.

Codership is pleased to announce the release of Galera Cluster 5.5.49 and 5.6.30 with Galera Replication library 3.16, implementing wsrep API version 25.

The library is now available as targeted packages and package repositories for a number of Linux distributions including RHEL, Ubuntu, Debian, Fedora, CentOS, OpenSUSE and SLES. Obtaining packages using a package repository removes the need to download individual files and facilitates the deployment and upgrade of Galera nodes.

This and future releases will be available from http://www.galeracluster.com. The source repositories and bug tracking are now on http://www.github.com/codership .

This release incorporates all changes up to MySQL 5.5.49 and 5.6.30.

New features and notable fixes in Galera replication since last binary release by Codership (3.15):

• a counter is now used to track the number of desync operations currently running
…

I did get No supported encrypter found The cipher and or key length are invalid error when i clone my laravel project But when i run project on browser i was getting this error i did try to solve this error finally i found bellow error you can generate application key by using bellow command

This is more one post on mysql query I dont remember exactly time but i had need to change name of foreign key constraint column field We can rename field name easily if we didnt set foreign key constraint But if you set foreign key constraint then you cant rename easily I had rename directly

This is more one post on mysql query I dont remember exactly time but i had need to change name of foreign key constraint column field We can rename field name easily if we didnt set foreign key constraint But if you set foreign key constraint then you cant rename easily I had rename directly

Using Docker for development is a great way of ensuring that what you develop will be the same that you deploy in production. This is true for almost everything. If you develop on Linux, the above statement holds. If you develop on a different operating system (OSX or Windows) there are several restrictions.

I showed one of those issues in a recent article (MySQL and Docker on a Mac: networking oddity.) When you want to export a port from a service running in the container, the exported port is not available in your mac, but in the virtual machine that runs Docker services. This happens with any application that listens to a port.

The second limitation I found affects only MySQL, and it is related to using volumes. The proper way of achieving data persistence with …

Sometimes we require to get randomly data using laravel query builder you can use mysql rand with order by If you want to get random data using laravel eloquent then we need to use DBraw In bellow example you can i use DBrawIn this example i use DBrawRAND inside orderBy an

In an industry as fast-growing and interconnected as database technology’s, it’s exciting to track how innovations in one platform can ignite beneficial, rippling effects on other, surrounding systems. At VividCortex we frequently find ourselves faced with opportunities to improve our monitoring solutions based on how database technologies (such as MySQL, Redis, PostgreSQL, etc) develop and integrate new upgrades.

When those platforms that we monitor -- already powerful, tried and true -- equip themselves with new features, we work to discover how VividCortex can leverage those features and make our own technology even better. In the case of MySQL 5.7.8’s recent introduction of Generated Virtual Columns, we found the opportunity to use a new feature to make our queries simpler and more elegant, with results …

This blog post discusses what is going on in the MySQL high availability market, and what Percona’s plans are for helping customers with high availability solutions.

One thing I like to tell people is that you shouldn’t view Percona as a “software” company, but as a “solution” company. Our goal has always been to provide the best solution that meets each customer’s situation, rather than push our own software, regardless of whether it is the best fit or not. As a result, we have customers running all kinds of MySQL “flavors”: MySQL, MariaDB, Percona Server, Amazon RDS and Google Cloud SQL. We’re happy to help customers be successful with the technology of their choice, and advise them on alternatives when we see a better fit.

One area where I …

Nginx (pronounced "engine x") is a free, open-source, high-performance HTTP server. Nginx is known for its stability, rich feature set, simple configuration, and low resource consumption. This tutorial shows how you can install Nginx on an Ubuntu 16.04 server with PHP 7 support (through PHP-FPM) and MySQL support (LEMP = Linux + nginx (pronounced "engine x") + MySQL + PHP) .