Archive for the ‘ MySQL ’ Category
When I started to use replication (on few tables) I encountered some problems with discrepancy on slave – it was mainly due to filters on slaves. I had to change some queries and everything was almost fine. Soon, I expanded my topology and started to replicate all databases from master. Simultenously, I read in the book “High […]
Functions like mysql_error() in PHP or try/catch blocks and MySqlException in C# are very helpful to discover problems. Unfortunately, inside stored procedure (routine) there is no ready component to catch errors to see what would return SHOW ERRORS. But I have wanted such feature at my EVENT (Event Scheduler)! Hopefully, I realized that I can […]
New problem on MySQL, called “tmc” – “Too Many Connections”. In case of environment with many db users, different applications/services and load balancing the investigation is not simple. First of all I have to clarify some question: there are two types of such event. Error: 1040 SQLSTATE: 08004 (ER_CON_COUNT_ERROR) – this concerns global connections. Error: […]
How to create a mailing list on the base of Postfix? My main goal was to avoid installing Mailman and enable sending bulk emails. With Postfix VDA it was quite simple. My solution is in some way tricky but secure (SMTP Auth) and simple provided that user has been advised adequatly. From user’s standpoint one […]