Percona is glad to announce the release of Percona XtraBackup 2.3.1-beta1 on May 20th 2015. Downloads are available from our download site here. This BETA release, will be available in Debian testing and CentOS testing repositories.
This is an BETA quality release and it is not intended for production. If you want a high quality, …
[Read more]In July 2014, I wrote that we were working on a new native InnoDB data dictionary to replace MySQL's legacy frm files.
This is quite possibly the largest internals change to MySQL in modern history, and will unlock a number of previous limitations, as well as simplify a number of failure states for both replication and crash recovery.
With MySQL 5.7 approaching release candidate (and large changes always coming with risk attached) we decided that the timing to try to merge in a new data dictionary was just too tight. The data dictionary development is still alive and well, but it will not ship as part of MySQL 5.7.
So please stay tuned for updates... and thank you for using MySQL!
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
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 …
[Read more]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.
