Index existing data from mysql - I can index the data using curl but
trying to figure out how to do it in one go. Dont want to do through PHP
since size of data is very large.
Sync the data whenever there are any update into the database through
application. Is there a way to achieve this.
How can We use elastic search in PHP
If someone can point to documentation which give some getting started like
stuff that would be great help.
There is no way to index straight from MySQL itself. You will need
some kind of adapter/connector to move the data from MySQL to
Elasticsearch. This is necessary for several reasons, but mainly because
you need to transform the rows into usable JSON documents. That's
something only your application will know how to do. The adapter could be
written in PHP, Python, Perl, etc...any of your favorite dynamic languages
will work.
Synchronizing databases is another job best left to the application
and user. The easiest solution is to have a dual-pipeline: when an update
(or delete or index) arrives at your system, it is sent to MySQL and
Elasticsearch simultaneously. It is usually easier to perform the
operation in parallel rather than sending to the database and then trying
to keep the two synchronized.
That's an awfully broad question! The PHP client quickstart and
docs show the syntax to use the client, which gives you access to all the
Elasticsearch APIs. How you want to integrate Elasticsearch into your
application is entirely up to you, and it is very dependent on your
particular use-case.
-Zach
On Wednesday, February 26, 2014 6:29:14 AM UTC-5, Santosh wrote:
Index existing data from mysql - I can index the data using curl but
trying to figure out how to do it in one go. Dont want to do through PHP
since size of data is very large.
Sync the data whenever there are any update into the database through
application. Is there a way to achieve this.
How can We use Elasticsearch in PHP
If someone can point to documentation which give some getting started like
stuff that would be great help.
There is no way to index straight from MySQL itself. You will need
some kind of adapter/connector to move the data from MySQL to
Elasticsearch. This is necessary for several reasons, but mainly because
you need to transform the rows into usable JSON documents. That's
something only your application will know how to do. The adapter could be
written in PHP, Python, Perl, etc...any of your favorite dynamic languages
will work.
Synchronizing databases is another job best left to the application
and user. The easiest solution is to have a dual-pipeline: when an update
(or delete or index) arrives at your system, it is sent to MySQL and
Elasticsearch simultaneously. It is usually easier to perform the
operation in parallel rather than sending to the database and then trying
to keep the two synchronized.
That's an awfully broad question! The PHP client quickstart
and docs show the syntax to use the client, which gives you access to all
the Elasticsearch APIs. How you want to integrate Elasticsearch into your
application is entirely up to you, and it is very dependent on your
particular use-case.
-Zach
On Wednesday, February 26, 2014 6:29:14 AM UTC-5, Santosh wrote:
Dear All,
I have gone through the link - http://www.elasticsearch.org/
guide/en/elasticsearch/client/php-api/current/_quickstart.html to
understand the setup. Can someone point to the documentation where I can
Index existing data from mysql - I can index the data using curl but
trying to figure out how to do it in one go. Dont want to do through PHP
since size of data is very large.
Sync the data whenever there are any update into the database through
application. Is there a way to achieve this.
How can We use Elasticsearch in PHP
If someone can point to documentation which give some getting started
like stuff that would be great help.
Apache, Apache Lucene, Apache Hadoop, Hadoop, HDFS and the yellow elephant
logo are trademarks of the
Apache Software Foundation
in the United States and/or other countries.
The PHP client quickstart and