To whom it may concern, this is a quick note to bring the xmondrian project to your attention. Introduction: Open Source OLAP, Mondrian, Pentaho, and JasperSoftMondrian is the open source OLAP engine. Mondrian provides:

• a multi-dimensional view of a relational database (ROLAP)
• a MDX query engine
• Clever, advanced caching layers to speed up OLAP query performance (making it a MOLAP/ROLAN hybrid i.e., HOLAP)
• Standards compliant OLAP data access by providing XML for Analysis (XML/A) and …

I would like to share this post with you you can learn how to use AngularJS in native php In this post you i did example with create read update delete search and pagination of items table I use angularJS MVC with native PHP this way you can easily implement in your project AngularJS is a aw

In this blog, I will answer questions posed in my recent introduction to MySQL troubleshooting basic techniques webinar.

Thank you for attending my March 10 MySQL troubleshooting webinar “Introduction to MySQL troubleshooting: basic techniques,” which is the second in the “MySQL Troubleshooting Webinar” series. The recording and slides for the webinar are available here. Here is the list of your questions that I wasn’t able to answer during the webinar, with responses.

Q: Any known …

I want to share this posts with you because when i was working on native PHP and Ajax Post requestSpecially AngularJS Post request at that time i cant get Post value on form submit Thats why i would like to share you this post I also want to tell you i was working on my Ubuntu 1404 I did try

When i was working on my Laravel application using git bitbucket repository i fatch problem when first i did commit on my master branch and i think i did 3 or 4 commits and my project partner pull also in his local system but we did wrong code in this commit so we required to remove that 3 or 4 c

Git is distributed version control system that is a awesome when ever you are working with git repository if you did commit your code in your local system by mistake then if you want to remove last commit from your project so lets see following examplestrong classexampleExamplestrong

Codership’s first Galera Cluster for MySQL webinar “hit a home run” in the world series of webinars.  One of the attendees said: “The Webinar was one of the best I have attended.  The fluff was minimized and the tech presentation hit a home run” .

Take a look Codership’s Galera Cluster® for MySQL Installation and Quick Start recorded webinar

http://galeracluster.com/videos/galera-cluster-installation-and-quick-start/

There will be other  Galera Cluster for MySQL webinars coming from the developers and experts of Galera Cluster, so stay tuned.

Galera, Galera Cluster and Galera Replication are registered trademarks of Codership.

This is the second and last tutorial blog post on how to use pt-table-checksum / pt-table-sync tools for MySQL replication.

In the first post, I showed you how to use the

pt-table-checksum

  /

pt-table-sync

  tools in a typical MySQL replication setup. In this post, we’ll discuss MySQL replication for more advanced topologies. I will show you how to use these tools in a chained …

Following the recent post on replication performance and efficiency, I'd like to talk about another MySQL feature that has received some treatment in Aurora: the Query Cache.
We'll first discuss the limitations of "traditional" Query Cache implementation, we will then watch a sysbench read-only test take off and go from 250K reads per second to nearly 650K reads per second, all thanks to the improved Query Cache. Have fun!
Query Cache The MySQL Query Cache is a hugely useful feature that caches the result sets of SELECT statements in memory. It makes perfect sense in typical OLTP applications (especially web apps), where queries are quite repeatable because the same piece of data is often selected multiple times by many clients.
The following performance issues are associated with query cache implementation in vanilla …

How do you dig down into the JSON data, say like in comments on a blog post? This is a badly paraphrased question from Peter Zaitsev of Percona at the end of a recent presentation of mine at the Great Wide Open conference. I have to admit I had not done like that with JSON data but it had to be able to be done, right? Surely it can be done. Can't it? Time to dig. I could not find an example of JSON data on a blog with comments. But the good folks at Mongo had an example of a restaurant with grades.

{
  "address": {
     "building": "1007",
     "coord": [ -73.856077, 40.848447 ],
     "street": "Morris Park Ave",
     "zipcode": "10462"
  },
  "borough": "Bronx",
  "cuisine": "Bakery",
  "grades": [
     { "date": { "$date": 1393804800000 }, "grade": "A", "score": 2 },
     { "date": { "$date": …