MySQL Workbench is a graphical design tool for MySQL databases. It is used for database server administration, database design, creation, security management and server as well as database maintenance. Install MySQL Workbench on Ubuntu: sk@sk:~$ sudo apt-get install mysql-workbench Add Database Server connection Now open MySQL Workbench from Menu or Dash. The main page of […]
StatusNet is open-source software used to setup micro-blogging site similar to Twitter. In this article, I use CentOS 6.4 to setup this website. My hostname and IP Address are server.unixmen.com and 192.168.1.200/24, respectively. Change these values as per your setup. Prerequisites Install the following prerequisites to install and configure StatusNet: [root@server ~]# yum install mysql […]
Piwik is an open-source and free alternative to Google Analytics tool. It tracks and displays reports about the location of user visits, Where they came from (i.e website, directly, or something else), the visitors browser, screen size, operating system details, what the visitors did on your website, the time of visits and more. In this […]
This article describes you how to upgrade MySQL to MariaDB in ten simple steps. We have already shown you How to Migrate from MySQL to MariaDB on FreeBSD. I assume that you already have installed MySQL latest version and it’s up and running now.
MySQL replication allows you to have multiple copies of data on many systems and data is automatically copied from one database (Master) to another database (Slave). If one server goes down, the clients still can access the data from another (Slave) server database. In this article, let us see how to configure MySQL Master-Slave replication. […]
Monit is a free open-source tool used to manage and monitor processes, programs, files, directories and filesystems on a local or remote LINUX/UNIX systems. Monit conducts automatic maintenance and repair and can execute meaningful causal actions in error situations.