Checking and repairing mysql replication automatically

Hello! MySQL replication has been known to easily break, as a result of a large multitude of potential causes. Sometimes the replication can even break if an erroneous query is executed on the master server. With all the potential issues that may break replication, we thought it prudent to write an automated check script that […]

https://www.stackstar.com/checking-and-repairing-mysql-replication-automatically/ Security Penetration Testing Series : SQL Injection

I am starting a series of blog posts that detail security related strategies, penetration testing and best practice methodologies. To start our series, I am going to delve into the world of SQL injection techniques and a general overview for those who are looking to learn a little more about this method of injection. There […]

https://www.stackstar.com/security-penetration-testing-series-sql-injection/ MySQL Query Log – diagnosing and debugging mysql

The general query log is a general record of what mysqld is doing. The server writes information to this log when clients connect or disconnect, and it logs each SQL statement received from clients. The general query log can be very useful when you suspect an error in a client and want to know exactly […]

https://www.stackstar.com/mysql-query-log-diagnosing-and-debugging-mysql/ MySQL Replication : Replicating an existing database

I decided to make a revised post detailing the different steps required in order to implement a master / slave replication relationship within two or more MySQL servers.

https://www.stackstar.com/mysql-replication-replicating-an-existing-database/ How to repair damaged MySQL tables

This tutorial gives step-by-step instructions for repairing damaged mysql tables.

https://www.stackstar.com/how-to-repair-damaged-mysql-tables/ How to setup a slave DNS Nameserver with Bind

This need for a DNS master/slave implementation where new zone files are transferred between the master nameserver and the slave became apparent as operations grew and geographic DNS redundancy became apparent.

https://www.stackstar.com/how-to-setup-a-slave-dns-nameserver-with-bind/ MySQL Replication : Setting up a Simple Master / Slave

This simple how-to is intended to setup a simple master / slave mysql replication.

https://www.stackstar.com/mysql-replication-setting-up-a-simple-master-slave/