Was thinking if i should create something that manage named.conf. The interest in this started when i remembered that to add a zone into the DNS server, i will need to declare the zone in named.conf and create the zone file.

The zone file portion is settled by the Web UI. But right now, the named.conf will still need to be changed manually.

did some finalization of sql schema. and in my attempt to improve the query performance by creating a stored procedure for each view, i had seem to created another big problem.

The cpu load during my test goes as high as 99%. This is bad. Average query time now stands at 0.52 seconds.

I am currently conducting more test and optimize the solution, which otherwise seems to be great.

just got lighttpd and php installed on the vm in preparation of the web console that i will be implementing soon.

trouble was that the vm can’t access the internet. had to download the packages onto my computer before scp it into the vm. so using yum was not possible.

i am now thinking if i should go with one of the php framework (e.g. cakephp) or start of scratch.

testing out if performance would be better if the temporary table created by the procedure is declared to use memory engine. the current implementation seems how have some load issues.

some results of test the algorithm using resource entered in different pattern as test data

finished building the testing tool. I think. It is done in perl, contains a for loop which queries the DNS server for a specific number of time. The response and time taken is logged to a SQL database. The idea is to be able to export it to csv and then to excel for analysis later.

Preliminary results shows good response time. The average response time is 0.017029538 seconds. But this is without load. Going to try to induce some load and carry out the testing. However, the results for the response seems a bit off. Not what i expected. I am guessing that the database had been filled with invalid values from my earlier tests.

WOOHA!

after Matthew’s help in solving the undefined function problem and solving a few problems in calling the MySQL C api function which was causing segfault the build is complete! Along with a improve SQL query to get the resource id.

it seems to be doing what it is suppose to do.

Need to put some triggers(for recalculation of preferences) into the SQL database before starting to test it.

just completed figuring the database structure.

remember i listed the codes that i am intending to change? this is what they were performing. The zone to search and the name of resource would be formatted into the string resulting in something similar to the example listed below:

 
(the text did not want to be displayed properly, so had to use image. )

What i assumed wrongly earlier (or i had not thought of it) was that the query only had to return the A return. But after looking at the output and thinking abut it. It is true that the query should return the full answer (SOA, NS, A, CNAME), like what a normal text based zone file does.

On the other, the SOA and NS record should not be affected by the per resource weight. Hence, there should be some sort of join table, select all the SOA and NS, followed by joining it to the result of a query that select the A record based on the weight.

This is a verbal/train of thought elaboration, the actual sql query might not follow it exactly, but i think it is good enough to bring my point across.