Category Archives: Database

Dimension rrdtool databases with years worth of values

To create an rrd datbase file needs a certain amount of understanding of what you monitor, and for how long the data needs to be kept, and of course, storage space is also a consideration when creating a new rrd … Continue reading

Posted in Database, Monitoring | Tagged , | Comments Off on Dimension rrdtool databases with years worth of values

MySQL Could not find first log file name

When MySQL shows the error “Could not find first log file name in binary log index file” it means that mysql is looking for a bin-log file that is not shown in the bin-log index file. This does not necessary mean the replication is completely broken. Continue reading

Posted in Database | Tagged , | Comments Off on MySQL Could not find first log file name

Restore MySQL replication after error

When you have a replication error that does not allow you to fix it as described in Fix MySQL replication error you need to repair it by restoring the replication completely. Continue reading

Posted in Database | Tagged , | Comments Off on Restore MySQL replication after error

Fix MySQL replication error

When you setup replication you need to make sure that no other data is available in the slave that can cause the data to be inconsistent. But if you run into problems like I had, you might notice that the … Continue reading

Posted in Database | Tagged , | Comments Off on Fix MySQL replication error

Setup mysql master slave replication

MySQL server provides replication functionality to replicate data from a master server to multiple slave servers. The concept behind it is that there is one master server that allows read and write access and one or more slave servers that … Continue reading

Posted in Database | Tagged , | Comments Off on Setup mysql master slave replication

Is MongoDB always faster then MySQL?

This is another classic question you might have come across, but can this question simply be answered with a YES or NO? Well, I would not write about it if the answer was that easy! Continue reading

Posted in Database | Tagged , , , , | Comments Off on Is MongoDB always faster then MySQL?

From what size of data MySQL is not performant any more?

Is this the right Question? Somebody asked me this question and I told myself to write about that topic. This questions are always lacking of of context, but there might be a correct answer. Usually you don’t reach the performance limit of MySQL very easily. Its the wrong questions you ask…
Continue reading

Posted in Database | Tagged , , , | Comments Off on From what size of data MySQL is not performant any more?