May 25, 2017

Percona

How to Recover the MySQL root Password

MySQL Logo

Forgot your MySQL root password? No problem, you just need to start MySQL with a flag to tell it to ignore any username and password restrictions which might be in place. Once that is done you can successfully recover the MySQL root password by setting a new password.

[Read more...]

How to Install Zabbix on FreeBSD

Zabbix Logo

Zabbix is a very useful tool for availability and performance monitoring. Alerting you by E-Mail, Jabber or SMS once a service is not reachable is one of the key features of Zabbix.

Here is a short list of some features available in Zabbix:

  • auto-discovery of servers and network devices
  • low-level discovery
  • distributed monitoring with centralized web administration
  • support for both polling and trapping mechanisms
  • agent-less monitoring
  • secure user authentication
  • flexible user permissions
  • web-based interface
  • flexible e-mail notification of predefined events
  • high-level (business) view of monitored resources
  • audit log

In this tutorial we show you how to get a Zabbix server, the Zabbix agents and the Zabbix frontend running on FreeBSD.

[Read more...]

How to Backup and Restore a MySQL Database

MySQL Logo

Backing up MySQL databases is an area that is often forgotten. The only time you probably think of backing up your MySQL data is when you change your web host or switch to an other database server. With this instruction we will show you how easy it is to backup and restore a MySQL database.

[Read more...]

How to Install Percona Server with XtraDB on FreeBSD

Percona Logo

With Percona Server you can replace your existing MySQL with a much faster and more consistently relational database management system. Percona XtraDB is an enhanced version of the InnoDB storage engine, designed to better scale on modern hardware, and including a variety of other features useful in high performance environments. It is fully backwards compatible, and so can be used as a replacement for standard InnoDB. This combination offers breakthrough performance, scalability and features such as self-tuning algorithms for extremely high-performance hardware. The storage engine is licensed under GPLv2, and it is absolutely free to use.

[Read more...]