'Commentary' Category

• Where is the Language Data?

  December 5, 2014

  Image if you will,  a geographic database of locations and the language/s spoken there with keys to a dictionary of common programa sketchup words with keys the same word in all other languages.   And again image this database was like a wiki, so it could crowd sourced.  You could put in your own home and “English spoken […]

  posted in Commentary, GIS by admin

• Oklahoma City MySQL Group Forming

  July 22, 2014

  I’m excited to learn, just one day before the event, that Oklahoma City has formed a MySQL User Group. OKCMySQL.org July 23, 2014 will be the inaugural meet-up for the OKC MySQL user group. As a special guest speaker, Peter Zaitsev (CEO of Percona and co-author of High Performance MySQL) will be giving a presentation […]

  posted in Commentary by admin

• MySQL Switch project

  October 24, 2013

  As an old firewall developer, I’m dreaming of a MySQL Switch (MySwitch). You can modify an application to change the database destination. Often the application has to be restarted creating down time. Most servers have many applications connected to them. To make a switch to a Slave server everything has to happen together. Some applications start […]

  posted in Commentary by mark

• You upgraded to > 5.1 but did you turn on performance_schema?

  July 26, 2013

  If you’ve upgraded from MySQL 5.1 to a newer version (5.5?  5.6? 5.7?)  Mark Leith shows you why you should turn on performance_schema. Roland Bouman gave us Common_Schema to help improve the SQL user experience.   Mark now lets us look inward at the IO latency to improve the system. Mark has developed a great set of views and procedures to work with performance_schema that can […]

  posted in Commentary, Tips & Tricks by mark

• Percona Live – MySQL Conference

  April 25, 2013

  This is my takeaway from this years MySQL conference in San Francisco. The community believes Oracle has been a good steward of MySQL and delivered some great code in 5.6. Studies from 451 Research show MySQL is on the decline and a lot of this has to do with the ownership my Oracle and growth of no-SQL. Big data, Cloud, […]

  posted in Commentary by Mark Grennan

• Ten years of MySQL developer conference

  April 23, 2013

  This is the tenth year for the MySQL developer conference and my third. I’ll be posting some news about iDB From ScaleArc. Oracle is back this year. Everyone is fighting with developers wanting to move away from MySQL. And there is lots of talk about 5.6 and working in virtual environments.     Tweet

  posted in Commentary by Mark Grennan

• Making a MySQL slave with ZERO downtime

  April 10, 2013

  It’s about time for this year’s MySQL (Percona) conference in San Francisco.  I haven’t written anything in some time.  So, I thought I’d write something we can talk about should you meet me. You need to make a slave of your MySQL server. What if, you’re bonus was tied to database up time or maybe […]

  posted in Commentary by mark

• In place replacement / upgrade – Redhat and Centos

  November 13, 2012

  For many years I have recommended startup companies install and work with CentOS until they need and can afford RedHat Enterprise.  The idea, because the two are binary compatible, the applications the company uses and develops will migrate between the two without changes.  I have even said you can do an inplace migration between them. […]

  posted in Commentary by admin

• ScaleArc’s iDB Reviewed

  August 28, 2012

  Stop coding and start scaling! At the April MySQL conference in San Francisco (2012) I discovered iDB by ScaleArc and was excited by what it can do. After three months of testing and working with ScaleArc I purchased it. What I do The company I work for (WDT Inc.) supplies weather data. From a database […]

  posted in Commentary by mark

• Indexed CSV

  July 26, 2012

  Why is there no index for CSV files?  Indexes are very simple. If the first column of your CSV file is in sorted order you can do a binary search to find your data.  But what if you need to find data in the second or third column? If you have a separate index file […]

  posted in Code, Commentary by mark