Using MySQL Enterprise Monitor with the MySQL Enterprise Firewall

Using MySQL Enterprise Monitor 3.0.22, the following newly added variables for the MySQL Enterprise Firewall are added : Ref :  http://dev.mysql.com/doc/relnotes/mysql-monitor/3.0/en/news-3-0-22.html

• System Variables:
  
  • mysql_firewall_max_query_size
  • mysql_firewall_mode
  • mysql_firewall_trace
• Status Variables:
  
  • Firewall_access_denied
  • Firewall_access_granted
  • Firewall_cached_entries

For information about MySQL Enterprise Firewall, you can refer to the information on Web  …

State Snapshot Transfer (SST) is a way for Galera to transfer a full data copy from an existing node (donor) to a new node (joiner). If you come from a MySQL replication background, it is similar to taking a backup of a master and restoring on a slave. In Galera Cluster, the process is automated and is triggered depending on the joiner state.

SST can be painful in some occasions, as it can block the donor node (with SST methods like mysqldump or rsync) and burden it when backing up the data and feeding it to the joiner. For a dataset of a few hundred gigabytes or more, the syncing process can take hours to complete - even if you have a fast network. It might be advisable to avoid e.g. when running in WAN environments with slower connects and limited bandwidth, or if you just want a very fast way of introducing a new node in your cluster.

…

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.