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

This blog post discusses Orchestrator: MySQL Replication Topology Manager.

What is Orchestrator?

Orchestrator is a replication topology manager for MySQL.

It has many great features:

• The topology and status of the replication tree is automatically detected and monitored
• Either a GUI, CLI or API can be used to check the status and perform operations
• Supports automatic failover of the master, and the replication tree can be fixed when servers in the tree fail – either manually or automatically
• It is not dependent on any specific version or flavor of MySQL (MySQL, Percona Server, MariaDB or even MaxScale binlog servers)
• Orchestrator supports many different types of topologies, from a single …

Get an Early Look at the New NinesControl (beta)

We’re excited to announce NinesControl, a developer friendly service to deploy and manage MySQL, MariaDB and MongoDB clusters using your preferred Cloud Provider.

Building systems for the cloud today means designing an application and database architecture that is both resilient and scalable. However, setting up a database cluster can be time consuming and complex.

What is NinesControl?

NinesControl is a new online service for developers. With a couple of simple steps, you can deploy and manage MySQL, MariaDB and MongoDB clusters on your prefered public cloud.

Sign up up to stay informed and apply for early access

Who is it for?

NinesControl is specifically designed with …

In this tutorial we will explain how to install LiteCart on an Ubuntu 14.04 VPS with Nginx, PHP-FPM and MySQL. LiteCart is a free e-commerce, feature rich e-commerce solution. The framework is constructed to be lightweight and easy for developers to modify and build upon. LiteCart relies on the latest HyperText standard HTML 5, the latest CSS 3 for styling, the jQuery framework for client-side dynamics, and the popular web scripting language PHP for server-side dynamics. REQUIREMENTS We will be using our SSD 1 Linux VPS Hosting plan for this tutorial. UPDATE THE SYSTEM Make sure your server is fully […]

In a previous post I took the new JSON datatype and functions for a test drive, using sample data provided by SF OpenData. Today I will extend that example to include indexing.

Introducing Generated Columns

MySQL 5.7 introduces a new feature called generated columns.…

In this post i show you how to use autocomplete with multiple select option by jquery I think you will did autocomplete for single option using jquery ui plugin but in this post you can learn multi selection autocomplete using jquery ui In bellow preview you can see how will output of your multis

In this tutorials we have learn how to configer a Elastic search in our local systemfollow this step and easily configer an Elastic Searchstrong classstep1 Step 1 Installing Java strongBefore installing OpenJDK with APT update the list of available packages for installation on y

One of GitHub’s niche features is the ability to access a Git repository on GitHub using Subversion clients. Last year we re-architected a large portion of the Subversion bridge to work with our changing infrastructure.

The Problem

A key part of the Subversion bridge is a mapping between Git commits and Subversion revision numbers. The mapping is persisted so that we can produce a consistent view of the repository. A bit of the mapping is exposed via a custom SVN property, git-commit. For example, you can see that revision 2504 of phantomjs is an SVN representation of Git commit 2837f28.

$ svn propget --revprop -r 2504 git-commit https://github.com/ariya/phantomjs
2837f28c739f823f2eff061c8e41cf47654b8016

During the initial development of the Subversion bridge, we chose to store the mapping …