We are glad to announce the new release of dbForge Studio for MySQL, v7.1 that includes several new features.

In this blog post, we’ll discuss upgrading MySQL with Orchestrator.

I recently had a client, Life360, that wanted to upgrade from Percona Server 5.5 to Percona Server 5.6, and implement GTID in their high transaction environment. They had co-masters and multiple read slaves.

Orchestrator made this job much easier for us. My colleague, Tibi, recently posted about Orchestrator here and here.

Daniel from Life360 saw Orchestrator and was very interested. So here is how he setup Orchestrator in his own words:

…

We like our 9s at Severalnines, so here is our list of Top 9 Facts (in no particular order) that made the trip to Santa Clara worthwhile once again for this year’s Percona Live Conference. Thanks to the team at Percona and everyone else involved in keeping the Santa Clara tradition going by organising another great conference this year.

1. The conference opened its arms not only to the “traditional” MySQL community, but also put a focus on MongoDB users.

This year in particular, there was a real intent to provide a place to learn and mingle for those database users who deal with not only one datastore, but manage a mixed database environment. More and more users are called to operate in polyglot database landscapes and thus it was good to see this year’s conference provide a platform for that. Percona themselves of course now serve both the MySQL and MongoDB user community with their tools and offerings, and companies like …

The MariaDB project is pleased to announce the immediate availability of MariaDB Galera Cluster 5.5.49, MariaDB Connector/J 1.4.3, and MariaDB Connector/C 2.2.3. See the release notes and changelogs for details on these releases. Download MariaDB Galera Cluster 5.5.49 Release Notes Changelog What is MariaDB Galera Cluster? MariaDB APT and YUM Repository Configuration Generator Download MariaDB […]

The post MariaDB Galera Cluster 5.5.49 and updated connectors now available appeared first on MariaDB.org.

In this post i will show you how to resize image in laravel application Generally if we are work on big project like ecommerce etc then we need to generate thumbnail image for product or user image etc So in laravel you can do easily using interventionimage package You can also manage resize ima

"cron" is the Unix (Linux, etc) scheduler which runs regularly scheduled jobs. This post is not meant to be the "man" page (it has one of those already), but ideas how to use "cron" in a robust way.

Setting up cron jobsThere are at least *three* ways of configuring cron jobs on a modern Linux system; technically these are extensions, but they're so quasi-standard, they're even (possibly) available on FreeBSD :)

• Per-user "crontab" file. This can be edited using crontab -e, or replaced by crontab . If you are installing system-level software, you probably don't want to use this. Each user can have only one crontab file.
• System-wide "crontab" file, usually /etc/crontab. This is usually managed by the distribution / package manager, and you probably don't want to change this; there is only one.
• Per-package "crontab" files - usually kept in /etc/cron.d. There are multiple files, usually one per …

The MySQL Document Store introduced with version 5.7.12 allows developers to create document collections without have to know Structured Query Language. The new feature also comes with a new set of terminology. So let us create a collection and see what it in it (basically creating a table for us SQL speakin' old timers).

So start the mysqlsh program, connect to the server, change to the world-x schema (database) switch to Python mode, a create a collection (table).

What did the server do for us? Switching to SQL mode, we can use describe to see what the server has done for us.

We have a two column …

The MySQL Windows Experience Team is proud to announce the release of MySQL for Visual Studio 2.0.2 m1. Note that this is a milestone release and not intended for production usage.

MySQL for Visual Studio 2.0.2 m1 is the first development release of MySQL for Visual Studio to add support for the new X DevAPI. The X DevAPI enables application developers to write code that combines the strengths of the relational and document models using a modern, NoSQL-like syntax that does not assume previous experience writing traditional SQL.

For more information about how the X DevAPI is implemented in MySQL for Visual Studio, and its usage, please refer to the MySQL for Visual Studio Quick-Start Guide.

Please also note that the X …

You can get many returns from a Google search for “MySQL Query Best Practices” or “MySQL Query Optimization.” The drawback is that too many rules can provide confusing or even conflicting advice. After doing some research and tests, I outlined the essential and important ones below:

1) Use proper data types

1.1) Use the smallest data types if possible

MySQL tries to load as much data as possible into memory (innodb-buffer-pool, key-buffer), so a small data type means more rows of data in memory, thus improving performance. Also, small data sizes reduces disk i/o.

1.2) Use Fixed-length Data Types if Possible

MySQL can calculate quickly the position of a fixed-length column in a specific row of a table.

With the flexible-length data type, the row size is not fixed, so every time it needs to do a seek, MySQL might consult the primary key …

massassignmentexception is for the security purpose if laravel 5 function When i did start Laravel 5 and first i did try to add user using Usercreatenamehdpassword1w then i found bellow error I was thinking what was wrong but after investigation i found it for our security pu