MySQL Archives - WIREDGORILLA

How to secure your database | Ubuntu

Cybersecurity threats are increasing in volume, complexity and impact. Yet, organisations struggle to counter these growing threats. Cyber attacks often intend to steal, damage, hijack or alter value-generating data.…

MySQL high availability made charmingly easy | Ubuntu

Web Monkey1 year ago042 mins

In a previous blog, we talked about patterns to run a database in a highly available manner. In this blog, we present our recipe for MySQL high availability.…

Ubuntu in the wild – 22nd of June

Web Monkey3 years ago05 mins

The Ubuntu in the wild blog post ropes in the latest highlights about Ubuntu and Canonical around the world on a bi-weekly basis. It is a summary of all the things that made us feel proud to be part of this journey.…

How MariaDB achieves global scale with Xpand

Web Monkey4 years ago01 mins

distributed SQL. In a distributed SQL implementation, the database is distributed across multiple physical systems, delivering transactions at a globally scalable level. MariaDB Platform X5, a major release that includes upgrades to every aspect of MariaDB Platform, provides distributed SQL and massive scalability through the addition of a new smart storage engine called Xpand.…

12 MySQL/MariaDB Security Best Practices for Linux

Web Monkey7 years ago1 year ago09 mins

MySQL is the world’s most popular open source database system and MariaDB (a fork of MySQL) is the world’s fastest growing open source database system. After installing MySQL server, it is insecure in it’s default configuration, and securing it is one of the essential tasks in general database management.…

cPanel Server : Restoring MySQL SimLink.

Web Monkey15 years ago9 years ago01 mins

If you’re unable to restart mysqld and troubleshooting the cause: if u log into SSH and go to /tmp you may see that there is no simlink To create a simlink you can do the following: cd /var/lib/mysql/ touch mysql.sock…

Turbo charging MySQL by setting up the query cache

Web Monkey15 years ago9 years ago01 mins

To make sure MySQL uses the query cache, there are a few variables you need to set in the configuration file . Usually its my.cnf or my.ini…

Moving mySQL DBs between servers

Web Monkey15 years ago9 years ago01 mins

Moving mySQL DBs from one server to another: mysqldump -uUSER -pPASSWORD txp_database > txp_database.sql puts the entire thing in one nicely portable text file. Read moreKali's stable Docker image is now named kali-last-release | Kali Linux Blogon a new server it takes mysql -uUSER -pPASSWORD txp_database < txp_database.sql…

Taking backup of mysql database using cron

Web Monkey15 years ago9 years ago01 mins

Taking backup of mysql database using cron Create a file called database_backup.sh and also an empty directory called mysql_backup. The database_backup.sh script should have the following info :…

How can I repair corrupt MySQL tables?

Web Monkey16 years ago4 years ago01 mins

How can I repair corrupt MySQL tables? Every so often, MySQL tables have a way of corrupting themselves. MySQL offers a quick and painless method of repairing those tables.…