osTicket is a widely used open source ticket management systems that can be easily configured to create tickets to inquires via emails, web interface, etc… Download It is always advisable to download the latest stable version of osTicket and move it to preferred location to continue the installation process. Configuration & Database creation Move the […]

With MySQL 5.6 coming closer to its release, I got a chance to sneak a look into the Row Based Replication (RBR). 5.6 release of MySQL will be a replication features packed one, and it is for this reason I write  another post on the new enhancements in Row Based Replication(RBR). RBR provides a safe way of replicating between master and slave and thats why RBR enhancements become even more important. RBR in 5.6 is far more optimized than what it was before and we hope it will be fun to deploy, maintain and use.
Folowing are some interesting enhancements in RBR in MySQL 5.6 Replication.
1. Optimized row image:Large data transfer between master and slave while using RBR is a thing of past. Why log complete rows on the master? Why not just the changed colums?  The MySQL 5.6 release enables a DBA to configure the master to log …

I just uploaded slides for MySQL Connect session "Save Your Data: How to Make MySQL Backups" which we did together with Hema Sridharan. Enjoy!

I just uploaded presentation for session "Managing and Troubleshooting MySQL for Oracle DBAs" here.

I also created a guide of EXPLAIN features (URL, which I forgot to put on slide). Here it is.

Today was another good day, but I had a problem with one presentation and keynote.

the "Big Data is a Big Scam: Most of the Time". There is something that is not convincing me in the architecture,

and is mainly base on the lack of numbers and match between requirements and implementation.

The presentation was interesting from some aspects, and the tile approach is probably a good one.

I have enjoy the general idea and I did found awesome the bravery of setting up a circular replication cross geographic regions.

Never the less I remain bewildered by the tiles approach numbers, probably because the presentation was missing of few additional information.

Just to be more clear I was trying to understand better the real number and how works.

As for example if each tile is compose by 1 MySQL node, and …

Another good day today: I attended the keynotes and found them quite interesting.

I especially liked the way Twitter uses MySQL to build up a NoSQL solution. Jokes aside, I took a few notes on things I must analyze and dig in.

The introduction of the Paypal models seemed very interesting, which brought me to attend the presentation later on. It was well constructed and had some good theoretical work, but I was quite disappointed. I found the presentation incomplete and missing real numbers for the MySQL Cluster NDB setup.

I attended the presentation done by Ronald B. It was good — nothing really advanced, but it was on purpose. He was very informative and explanatory for a junior MySQL DBA, and I enjoyed his presentation for the logical approach and construction.

Ronald also highlighted that it was the content of less then a chapter of one of his books and was done on purpose to give an initial understanding of …

What's the best thing to do on a Sunday night? Correct, get a new XAMPP version out to the Internet. Of course, what else? And here it is again, an updated XAMPP.

The most important updates are: Apache 2.4.3, MySQL 5.5.27, PHP 5.4.7, and phpMyAdmin 3.5.2.2.

Yes, last Friday Oracle released a new MySQL 5.5.28. This version is not part of XAMPP. The time was to short to include this also in this release.

Again, we're not able to get also the Mac OS X version updated. Time is the problem. Is there anyone out there with good knowledge about GCC and AMP on Mac OS X?

Get the downloads and more details on the platform specific XAMPP project page.

Industry’s First Unified Database Scalability & Replication Solution Now Available for MySQL Environments PERCONA LIVE – NEW YORK – October 1, 2012 — ScaleBase, the company enabling next generation applications that require big data transactional processing, and Codership, the market leader in synchronous multi-master replication, are teaming up to deliver the industry’s first unified database scalability and [...] Read More

Take the MySQL Connect 2012 Survey

Thanks to everyone who is at the first ever MySQL Connect Conference in San Francisco this weekend! Don't forget to take your Conference and Session Surveys. Your opinions help shape next year's conference.

• Take a survey for each of the sessions you attend and be entered into a drawing for one prize for $200 American Express Gift Certificate.
• Fill in the daily conference survey and be entered into a drawing for one prize for a $500 American Express Gift Card
• Surveys are located here.

Make your opinion count! Take the survey now.

Congratulations to Robin Schumacher from DataStax as …

I was very excited about this session at MySQL Connect by Daniel Austin of PayPal. I have been talking about this session for a few weeks, on 2 different podcasts, and 2 different blog posts. But I was a bit nervous, because the description was fantastic but the talk itself could have fallen apart.

After seeing the keynote, I knew the talk would be fantastic. I was not disappointed.

Big myths about Big Data:
PayPal problem – “How do we manage reliable distribution of data across geographical distances?”

The first thing people think of when they think of “big data” is “NoSQL”. NoSQL provides …