Monday, March 26, 2018. Performance, Scalability and Business Continuity. At Effective MySQL we provide resources for the DBA, Developer and Architect to best use MySQL. This includes currently three books in our series, available in print, PDF and Kindle formats. Testing and verifying your MySQL backup strategy presentation.

Wednesday, June 01, 2011. An excerpt from article on mysql for big data. Published in Dow Jones Venture Wire by Scott Denne. Monday, February 07, 2011.

MySQL DBA, Architecture, Dev, Scale, HA, Code. Saturday, January 27, 2018. Spotify Top 200 in mySQL. I do a lot of data analysis lately, and I try to find answers to questions through data for my companies pressing questions. Artist is the artist name. List date is which chart date the artist show up on the top200. Streams is the number of plays following spotify specific rules.

Happy to see this MySQL JSON momentum! Last week at Percona Live Facebook has presented for the first time Docstore. Which is a native JSON implementation in MySQL. Oracle has also presented their MySQL 5. 7 lab release that includes the implementation of a native JSON type. The 2 implementations of Native JSON type are different but they both provide validation of input data and a binary format JSON storage. The Facebook native JSON implementation use a docpath s.

Monday, February 21, 2011. 8221; shows nothing if the last statement used a table and generated no messages. Shows the error, warning, and note messages that resulted from the last statement that generated messages in the current session. Certainly not sounds good if you are serious about your data.