Database Monitoring Tools QMONITOR__ Database

What Q:qmonitor is.

A:qmonitor is a professional database monitoring platform software for Oracle and MySQL. According to the user set up timely and effectively to the database of the abnormal alarm to facilitate users to see a variety of real-time state curve indicators, and monitoring, performance data statistical analysis, from the transport to the decision-makers from the perspective of multiple levels to generate related reports.

Qmonitor by Hangzhou wo-Fun Network Technology Co., Ltd. (referred to as "Wo-Fun Technology") independent development. WO-Fun technology was founded in June 2012, is the original Alibaba Dba/sa team of the core of the formation of the start-up company, is committed to providing professional database, system-related services and products. The technology area involves Oracle, MySQL, System, and operational dimension automation. Services include architectural design, optimization, implementation, and disaster recovery for databases and systems. Products include Qdata for Oracle (Oracle database hardware and software), Qdata for MySQL (MySQL database software and hardware all-in-one), Qmonitor (database monitoring software). To learn more, visit the official website: http://www.woqutech.com/or pay attention to Sina Weibo: @ Wo-Fun technology q:qmonitor what functions.

A:

1, three types of monitoring objectives: Oracle database, MySQL database, mainframe

2, three levels of perspective: Global View, monitor large Class View, single instance view

3, three major entity functions: Real-time alarm, performance status, Report Center

Real-time alarm contains 23 kinds of alarm detection, for each type of alarm support four parameters set: Alarm polling interval, alarm timeout time, alarm interval, alarm number.

Performance status for Oracle,mysql, the host supports 37,74,21 performance monitoring items respectively, supports six kinds of different precision display, supports three kinds of comparisons: same-Library multiple index comparison, compares with the index multi-Library, same library with the index different time period contrast. Which databases and systems are supported by Q:qmonitor.

A:

Supported databases: Oracle 9i~11g; MySQL 5.0~5.6; Percona; Mariadb.

Supported systems: IBM AIX; HP-UX; Linux:rehl, CentOS, Federa, SUSE, SunOS etc. What services are included in the Q:qmonitor.

A:qmonitor is a database monitoring products, it can directly insight into the user database of the operation of the situation, to find problems and timely feedback to the user. But if customers do not know how to deal with these problems, it is still meaningless.

WO Fun Technology team, not only to provide a product, but also to provide professional database problem-solving services, one-stop solution to customer problems. The following is a one-year service pack, which you can choose to purchase:

1.20 Technical Consultation:

Remote technical Support (provide telephone, QQ, mail and other means) and login service, answer customer consultation database questions, provide technical guidance.

2, 1 times per quarter a total of 4 database patrol:

By analyzing the database information collected by Qmonitor, analyzing the current situation of the customer system, discovering potential problems and giving relevant suggestions to reduce the risk of potential data loss, security intrusion, downtime, performance degradation or resource limitation rescue.

3, 6 times Remote troubleshooting:

For customer database system failures, provide customers with troubleshooting solutions, assist customer engineers to solve related problems, if you need to send engineers to the customer site, need to negotiate a separate contract.

In addition, we provide the following special services, we need to discuss the contract according to the demand separately:

1, Qmonitor product customization development services;

2, database-related architecture design, optimization, implementation services;

3, System-related architecture design, optimization, implementation services.

Specific service content, can refer to: http://www.woqutech.com/?page_id=7. What are the characteristics of q:qmonitor products?

A:

0 Client: Zero intrusion on monitoring targets, minimal performance impact

Distributed architecture: can monitor more than 1000 database instances through horizontal scaling

Functional utility: Functional design is the culmination of the DBA's years of experience

Operation-dimensional automation: Automatic patrol, performance anomaly automatically capture, greatly reduce human cost

Low learning Cost: simple and practical, quick to master

Highly customizable: Adds personalized functionality to user needs

Service integration: Years of experience in the operation of the Internet database operation and maintenance team to provide professional services q:qmonitor itself what services. Is there a license limit?

A:qmonitor includes one-year upgrade of the software itself, technical support services, and database-related services to purchase service packs separately.

A year later, the service charge is charged at 15% of the software sales price.

License limits the number of monitoring targets (including database instances, hosts). The quantity is within 50 according to the list price, more than 50 is discussed separately. Q:qmonitor is applicable to what kind of user.

A: The normal operation of the database is inseparable from monitoring, a perfect and effective monitoring system can help customers identify problems in advance, make the right decision.

So qmonitor is suitable for all Oracle, MySQL database operation personnel. In the product design process, we have taken into account a number of perspectives, including DBAs, operational executives and even CTO, to get the information and help they need from this product. is q:qmonitor an internet-based product?

A:qmonitor is not internet-based, but is deployed in the same or similar network as the user's database. Internet based monitoring products have a lot of limitations, can not do depth, real-time monitoring, users need to open the database host a certain network permissions.

The "online demo" You see now is just a demo version of a read-only permission run on a virtual machine, which can be slow, but not a problem with the product itself. We are also trying to find a solution. Q:qmonitor have the installation guide?

A:

Qmonitor Installation Guide: http://www.woqutech.com/?page_id=1283 q:qmonitor deployment Convenient. What does a monitored database need to do?

A: The deployment is very convenient, 3 minutes to complete the installation, follow-up will be made one-click installation. The monitored database does not need to have any agents installed, just give the necessary permissions. What are the requirements of the Q:qmonitor operating environment?

A:PC server,redhat/centos/6.2/6.3/x64,8g memory above, hard disk bare space above 300G. Where to download the Q:qmonitor installer.

A:

See online Installation Guide: http://www.woqutech.com/?page_id=1283

To apply for a trial please click: http://www.woqutech.com/?page_id=955 q:qmonitor installation needs what user. Whether the Qmonitor is running under what user.

A:qmonitor installation requires the root user, but for security reasons, Qmonitor is running under the Woqu user, an agreement between the fun tech and qmonitor users. Q:qmonitor installation of the MySQL instance with the root user and storage Qmonitor data acquisition of the user name and password is what.

The A:mysql instance's root user's password is letsg0, you can modify after the installation, proposed modifies the root password to synchronize modifies the alias. The MySQL username for storing qmonitor data is woqu_op, the password is woqu_op, it is not recommended that you modify this username password. If you must modify it, you need to modify the [meta_db] part of the/home/woqu/products/config-files/woqu/woqu.conf. What is the MySQL port installed on Q:qmonitor? The Web program you installed must be 8080 ports.

The A:mysql instance port is 9306, and if you want to modify the port number, modify the [meta_db] part of the alias and/home/woqu/products/config-files/woqu/woqu.conf accordingly.

If you want to modify the startup port of the Web program, you also need to modify the/home/woqu/products/woqu-web/etc/jetty.xml file as follows:

<set name= "Port" ><property name= "Jetty.port" default= "8080"/></set>

Jetty must be restarted after modification.
This is strongly recommended that you do not modify these default configurations. Q:qmonitor contains those processes. Will these processes be set to boot from? If you do not have a power-on from boot, how should the user start on their own?

A:qmonitor contains database processes, daemons, background capture processes, and foreground web processes (Jetty). The installation process does not set the boot up of these processes, it is recommended that Qmonitor be run daily 7*24. If you want to start the process manually, you only need to execute the following command:

Woquenv

Fab start_woqu

Q:qmonitor how to close.

A: Start the process manually by simply executing the following command:

Woquenv

How to remove Fab stop_woqu q:qmonitor.

A: Before removing qmonitor, it is recommended that you close all processes. Then delete the Woqu users and the files in their directories. Whether the database that the Q:qmonitor itself monitors needs to be monitored.

A: It is strongly recommended that this qmonitor MySQL database and host computer also be monitored. Q: If the system error, how to query the background log.

A:

Front Log Address:/home/woqu/products/logs/jetty

Background log Address:/home/woqu/products/logs/qmonitor

Q: If the probation report Lincese expired, what should be done.

A: Wo-Fun technology to provide users with a 30-day free trial period, if the Lincese expired, you need to contact the Wo-fun technology to buy qmonitor products. Q: If the monitoring target alarm, we can not solve what should be done.

A: Discovery system problem is the value of Qmonitor, you can choose to find the company's professional DBA and SA solution, if not resolved, you can opt to buy the technology database consulting and rescue services, but because this service is not included in the Qmonitor itself service content, the need for additional charges. Q: If the monitoring Qmonitor has been running, it is not space is not always a full day.

A: Yes, the most occupied space is the performance acquisition information, a database one year will produce approximately 10-15g data. Q: How to set up Lincese.

A:

Su-woqu

Woquenv

Vim config-files/license/license.conf