FATAL: Cannot connect to MySQL server on 'localhost': Cacti Error - Solution to the issue while setting-up.

The post Cannot connect to MySQL server on ‘localhost’: Cacti Error first appeared on Change Is Inevitable.

If data is oil for organizations then Database Management System (DBMSs) are the machine it runs; processing data for conscious operational and analytical decisions. This symbiotic relationship is so important one could say the success of modern-day applications and systems— specifically Relational Database Management Systems (RDBMSs)—relies on its success.

RDBMSs are universally preferred for both transaction or analytical processing; stemming from  their reliability for data storage, access, and protection. Also a major factor in choosing RDBMSs is the reputation of solid performance and easy implementation for most applications.

As of now, commercial vendors such as Oracle, IBM, and Microsoft rule RDBMS territory, but this is all changing. Commercial RDBMS products are expensive, with licensing and maintenance costs often draining millions of dollars per year.  For many, especially new or smaller …

Kubernetes is a system for managing containerized applications in a clustered environment. It provides basic mechanisms for deployment, maintenance and scaling of applications on public, private or hybrid setups. It also comes with self-healing features where containers can be auto provisioned, restarted or even replicated. 

Kubernetes is still at an early stage, please expect design and API changes over the coming year. In this blog post, we’ll show you how to install a Kubernetes cluster with three minions on CentOS 7, with an example on how to manage pods and services. 

Kubernetes Components

Kubernetes works in server-client setup, where it has a master providing centralized control for a number of minions. We will be deploying a Kubernetes master with three minions, as illustrated in the diagram further below.

Kubernetes has several components:

…

This is a little quiz (could be a discussion). I know what we tend to prefer (and why), but we’re interested in hearing additional and other opinions!

Given the way MySQL/MariaDB is architected, what would you prefer to see in a new server, more cores or higher clock speed? (presuming other factors such as CPU caches and memory access speed are identical).

For example, you might have a choice between

• 2x 2.4GHz 6 core, or
• 2x 3.0GHz 4 core

which option would you pick for a (dedicated) MySQL/MariaDB server, and why?

And, do you regard the “total speed” (N cores * GHz) as relevant in the decision process? If so, when and to what degree?

What personality characteristics do great DBAs share? What motivates them?

If you’re not sure why you should care, you’re probably not a hiring manager! Hiring and retaining highly skilled people is consistently listed as a top challenge for CIOs. CIOs strongly desire to predict whether someone’s a good fit for a particular role.

Enter the personality profile assessment. These are quantitative tools used by many companies to try to learn as much as possible about candidates during the recruiting process. I thought it would be interesting to know what drives DBAs, so I reached out to a number of great MySQL and PostgreSQL DBAs I know personally and asked them to fill out a pair of free online assessments.

These assessments rank behavioral tendencies in four dimensions, using the DISC model. They also rank motivators (values) in seven dimensions.

At this point I need to add a disclaimer that everything about …

Devart team is proud to introduce a new product line - ODBC Drivers. We believe we can offer the best features, quality, and technical support for database application developers.

Devart team is proud to introduce a new product line - ODBC Drivers. We believe we can offer the best features, quality, and technical support for database application developers.

Devart team is proud to introduce a new product line - ODBC Drivers. We believe we can offer the best features, quality, and technical support for database application developers.

Part 1 of 2: (part two)
If you have used MySQL for a while, you have probably used mysqldump to backup your database. In part one of this blog, I am going to show you how to create a simple full and partial backup using mysqldump. In part two, I will show you how to use MySQL Enterprise Backup (which is the successor to the InnoDB Hot Backup product). MySQL …

Earlier this spring, we upgraded our database cluster to MySQL 5.6. Along with many other improvements, 5.6 added some exciting new features to the performance schema.

MySQL's performance schema is a set of tables that MySQL maintains to track internal performance metrics. These tables give us a window into what's going on in the database—for example, what queries are running, IO wait statistics, and historical performance data.

One of the tables added to the performance schema in 5.6 is table_io_waits_summary_by_index. It collects statistics per index, on how many rows are accessed via the storage engine handler …