Come on, go, that we hadn't given to Centreon for a while; today a classic, But well. If we have any Microsoft SQL Server services in our organization, We can't let it go, apart from your availability, we must know its performance!
Well, in case anyone remains unaware… Did you know that there is an excellent PowerShell technical book in Spanish?? If you have Windows machines in your work environment… You have no choice but to get to know this Swiss Army knife. And for me the best way to learn is with this type of technical books.
If we have a database out there with curious data and we want to visualize them in our Home Assistant… This is your post! We will see how we can easily make inquiries to BD, in this example it will be a MySQL where we will integrate it with Hassio, And we'll see in the end how cool it is.
Well, This document is something particular, since it had a series of public IP addresses in a MySQL table, that I would like to visualize it in Grafana. Basically I'm talking about the visits to the blog 🙂 I have a WordPress and I don't have the database in my possession since it's on an external hosting… I leave you the steps I followed to achieve it, I hope it can be useful for other ideas.
Good, I leave you a post where we see how we can exploit the information stored by Citrix in its databases. As I imagine you know, Citrix stores in a database the records of what happens on our Citrix farm, but that is true, as much as you pay, as much as you get, that is, which depends on the Edition we have, Citrix will store information in those databases for 1 week, or 1 month or 1 year. Here we will see how to make our own panels with Grafana and without date limits!
Another marvel of monitoring with Centreon, is that it allows us to make queries to any type of database, in this post we will see how to query a MySQL database, We can launch any type of query that helps us to know the state or value that interests us, then we will be able to know that there are no blockages or that 'something’ He has not stopped writing on his table…
Something super useful is that thanks to Nagios, we will be able to monitor any performance counter of a Windows machine, Yes, any! We just need to know which one! We all know that the Performance Monitor of a Windows is super powerful and we have counters that allow us to analyze any parameter that we surely need. We can take this and centralize it to monitor from Nagios / Centreon.
I'm Oscar Mas and I want to show you how to implement a Mirror system with Witness based on Microsoft SQL Server, which is a perfect and recommended example to have our XenDesktop database in high availability. In this way we will be able to have a mirror with Microsoft SQL failover.
In this document, we'll look at installing a SQL Server cluster 2008 under two Windows Server nodes 2008 R2, we will install both nodes to obtain a SQL Server service in high availability. First of all, you have your Windows cluster 2008 R2 mounted and well configured, to which we will have several disks available for the databases, Logs, backup and MSTDC (We can rely on to create the cluster: HTTP://www.bujarra.com/?p=2290).
PowerGUI is one of the best free tools, especially for those of us who work with PowerShell environments and still do not feel comfortable, it is a graphic tool that allows us to create, edit, import, export our Windows PowerShell-based scripts. In this document we will see how to install it that has nothing and how we can organize our scripts, as well as being able to see how to use scripts for VMware, Exchange, Active Directory, SQL, Routers, communications, Internet, Systems Center, Operations Manager, Xen, Hyper-V, Citrix, Skype, Reporting, Twitter … everything that relies on PowerShell.
Do Tailor-made training
Windows Server – VMware vSphere – Citrix Virtual Apps & Desktops – Centreon
|
We are a consulting firm that cares and pampers
|
 |
|
With quality and added value
|
 |
|
¡Let's work together!
|
 |
