Architecture of WEBM system.

Reference:

http://www.vmcd.org/2014/10/webm_v2-has-been-released/
http://www.vmcd.org/2014/09/webm-mysql-database-performance-web-monitor/

View this PDF:

http://www.vmcd.org/docs/How%20to%20configure%20WEBM.pdf

Dear all - we are growing, and we want you to hop on our train! We recently released product integrations with PagerDuty, VictorOps, Slack, and Hipchat so you can notify your team of all the (important) things. Last month, we announced Heroku support, and our partner program has just launched.

In the words of Baron Schwartz, “Monitoring does not exist in a vacuum, and building strong relationships with other products and companies at a technical and business level is a priority for us. We always planned for this, but we didn’t plan for the demand,” he added. “The response from customers, the opensource community, and other companies has surprised us, and we’re investing even more resources than we’d planned.”

Read the full …

The world’s scientific communities are abuzz today thanks to NASA’s New Horizons probe and its mission to Pluto, which achieved the closest approach of its flyby this morning and started collecting a wealth of new information on our solar system’s tiniest and most distant planet/not-planet. What did NASA share with us earthlings first? A picture, of course. The most glamorous profile ever recorded of Pluto, the King of the Kuiper Belt, graced the front pages of our newspapers and greeted readers with what will surely become an iconic shot. NASA knows that for the layman, nothing is quite as exciting as a spectacular photo of a celestial body, taken at a higher-resolution than ever before. With all that empty space out there a lot of people just want to know, What can we see?

But let’s not forget: New Horizon’s $700,000,000 price tag …

MySQL information_schema comes with useful information about the database instance, status, … etc. which is needed for daily DBA work.
There are some simple queries on the information_schema that I use on my daily basis in which I’m writing this post for my reference and maybe a good reference for someone else too …

Finding tables without Primary or Unique Keys:

PKs are so important, especially, for InnoDB tables as MySQL uses PKs as a clustered index and having no PKs might lead to severe performance problems.

Also having no PKs is one of the main causes of slave lagging problems mainly when using RBR (Row-Based Replication), e.g. if a delete statement on the master will delete 1 million rows on a table without PK, a full table scan will take place. This “might” not be a problem on the master but on the slave 1 million full table scan will take place – because changes to the individual rows are being …

VividCortex, the monitoring solution for the modern data system, introduces the following: integrations with PagerDuty, HipChat, VictorOps and Slack, Heroku support and partner program.

Charlottesville, Virginia (PRWEB) July 14, 2015 – VividCortex, the monitoring solution for the modern data system, expands its offering through new integrations, support and partnerships. As data grows exponentially, the performance of diverse, distributed systems becomes more difficult to monitor and optimize. VividCortex has developed a unique suite of tools to see what is happening on production servers with unmatched detail, and the latest advancements further expand the robust solution.

“Monitoring does not exist in a vacuum, and building strong relationships with other products and companies at a technical and business level is a priority for us,” said Baron …

It’s easier now than ever before to stand up a web server and connect it to a database using node.js and Express. Using node.js to get data out of a relational database used to require that users become well versed in SQL technology.

So the MySQL dev team started on a project to make it trivial (well, easy) to store and retrieve documents from MySQL and deliver them to node.js applications. Without using SQL. The result is  called mysql-js and I’d like to introduce it to you. You can download it today at github.

The project started by looking at storing JSON documents that were relatively simple: each property of the document would be stored in a column in the database. This model allows storing simple documents in a way that could take full advantage of …

Automation software like Puppet, Chef, and Ansible can quickly load software on virtual servers. But how do you get your MySQL database instances loaded on these new servers? And how do you do it securely? Lets start with a fairly common pairing.

Ansible and Vagrant work very well together and the documentation for getting both to work together is rather extensive. BTW the newest version VirtualBox is 5.0 was recently released with a large number of improvements. Follow the documentation at their respective sites to get VirtualBox, Vagrant, and Ansible installed.

The linchpin is the Vagrantfile which controls how Vagrant starts the server. Inside this file we pull in an Ansible playbook.

Speed matters. That’s why you’re willing to pay a dollar more for milk at the convenience store — it’s quicker than waiting in line at the supermarket. And that’s why you will lose business if your database slows down the customer experience.

This is especially true of e-commerce websites. Forty percent of people won’t wait more than three seconds for a mobile shopping site to load. Amazon estimates it would lose $1.6 billion a year if its web pages took one second longer to load. If consumers won’t wait one second for Amazon, they won’t wait for your database to come back online.

And that’s just the direct bottom-line impact. Poor database performance has other negative effects, but you can follow steps to avoid these problems.

Read the full article here.

I've gotten a lot of positive feedback from my post on upgrading temporal columns from MySQL 5.5 to MySQL 5.6 format, both in the blog comments and directly from people who have used my query to identify which columns are candidates to be upgraded to the new format. Based on the feedback and some changes in more recent MySQL releases, I think it's worth doing a follow-up post.

Partioned tables

It was pointed out to me that the SQL query I used in my previous post does not work for partitioned tables. The reason is the join between information_schema.tables and information_schema.innodb_sys_tables in my query. For non-partitioned tables the value in information_schema.innodb_sys_tables.name will be <table_schema>/<table_name>, …

Check Out Our Latest Technical Resources for MySQL, MariaDB, Postgres and MongoDB

This blog is packed with all the latest resources and tools we’ve recently published! Please do check it out and let us know if you have any comments or feedback.

Live Technical Webinar

• What: Become a MySQL DBA - Which High Availability Solution
• When: Tuesday July 28th
• Who: Krzysztof Książek, Senior Support Engineer, Severalnines
• Where: Register Here

In this webinar, we will look at some of the most widely used HA alternatives in …