Planet MySQL Planet MySQL: Meta Deutsch Español Français Italiano 日本語 Русский Português 中文
Showing entries 1 to 10 of 22 10 Older Entries

Displaying posts with tag: dns (reset)

The Perfect Server – CentOS 7 (Apache2, Dovecot, ISPConfig 3)
+0 Vote Up -0Vote Down

The Perfect Server – CentOS 7 (Apache2, Dovecot, ISPConfig 3)

This tutorial shows how to prepare a CentOS 7 x86_64 server for the installation of ISPConfig 3 and how to install ISPConfig 3. ISPConfig 3 is a webhosting control panel that allows you to configure the following services through a web browser: Apache web server, Postfix mail server, MySQL, BIND nameserver, PureFTPd, SpamAssassin, ClamAV, Mailman, and many more.

Cloudflare, now offering to be your Single Point of Failure
+0 Vote Up -0Vote Down

There have been many articles about the downtime issue with Cloudflare last week, so I won’t get into the technical details of that. However, there’s the fine print to remember. Consider this a subtle reminder that core Internet infrastructure services like Cloudflare’s DNS-based “Always Online” caching and packet inspection security services do not come with Service Level Agreements even at the “Pro” account level. Even with a Pro account you are paying for a service with no uptime guarantee and you must only hope that it resolves your sites the majority of the time. This is fine, this is what the contract says: no SLA unless you pay for the Business account. An odd naming convention given that most Professionals are using their websites for business and would want the SLA, but I digress.

So,

  [Read more...]
DNSaaS application MySQL HA solution with Percona XtraDB Cluster (Galera)
+2 Vote Up -0Vote Down
I haven't written in a while. Some of the reason is that life has been incredibly busy with two young children. The other reason is that I've been busy at work with my team developing HP Cloud DNS, a service that runs in the cloud, as do the various other applications within the Platform as a Service group that I am part of. After a period of rapid development and deployment, Cloud DNS recently went into private beta . The ability to build an cloud application such as this was primarily that I have a great team (Kiall Mac Innes, Simon McCartney and a great product manger Josh Barry) as well as having chosen the right tools and software solutions. For the deployment side of things, Chef, despite frustrations that I have had before getting my mind around it, was a solution that I knew would make it so we could deploy anywhere, as well as being  [Read more...]
The blog was down yesterday
+0 Vote Up -0Vote Down

The brief outage was due to a scheduled move of the servers to a separate rack and subnet dedicated to our work with the Center for Information Assurance & Cybersecurity (ciac) at the University of Washington Bothell (uwb), and a11y.com

I am currently exercising the new (to us) equipment and hope to winnow the less than awesome equipment over the next quarter. I spent the last six months finding the best in breed of the surplussed DL385 and DL380 chassis we (work) were going to have recycled. The team and I were able to find enough equipment to bring up one of each with eight and six gigs of memory, respectively. These will make excellent hypervisors for provisioning embedded instances of Slackware, Fedora, RHEL, CentOS, Debian, FreeBSD, OpenSolaris, OpenIndiana, FreeDOS, etc.

When I initially configured this xen paravirt environment, I failed to plan for integration with libvirt, so I am

  [Read more...]
Working with IP's in MySQL and MariaDB - Part 2
+0 Vote Up -0Vote Down
Use DNS directly from your database

mysql> SELECT lookup('localhost');
+---------------------+
| lookup('localhost') |
+---------------------+
| 127.0.0.1 |
+---------------------+
1 row in set (0.00 sec)

mysql> SELECT reverse_lookup('127.0.0.1');
+-----------------------------+
| reverse_lookup('127.0.0.1') |
+-----------------------------+
| localhost |
+-----------------------------+
1 row in set (0.00 sec)

This is how you install these functions.
  • Build udf_example.so which is in your mysql source. (make udf_example.so)
  • Copy the udf_example.so file from your build directory to your plugin_dir.
  • Create the lookup and reverse_lookup


















  •   [Read more...]
    MySQL: Disable DNS Lookups
    +0 Vote Up -0Vote Down

    In a small environment, there's very little reason to rely on DNS resolution inside MySQL. You can disable it by adding skip-name-resolve to your my.cnf or by using the --skip-name-resolve command line argument.

    Remember that if you disable DNS lookups, you will need to set permissions using IP addresses rather than host names!

    Clear Windows DNS Server Cache From the CLI
    +0 Vote Up -0Vote Down

    Clearing the Windows DNS Server cache from the command line is an easy task.

    C:\> dnscmd . /clearcache

    The . indicates the local DNS server. You can use this command to clear the cache of remote DNS servers by replacing the . with the hostname or IP address of the remote server.



      [Read more...]
    Don’t forget to monitor your nameservers
    +0 Vote Up -0Vote Down
    As I mentioned in a past article I got my IPv6 connectivity working so started working on setting up various IPv6 services. One of these was to setup my name server so it also worked on IPv6. This worked fine, but recently I lost my IPv6 connectivity but thought no more about it. I’m trying [...]
    Tech Messages | 2010-05-14
    +0 Vote Up -0Vote Down

    A special extended edition of Tech Messages for 2010-04-29 through 2010-05-14:

      [Read more...]
    MySQL – IP vs DNS
    +0 Vote Up -0Vote Down

    A MySQL is running happily on a machine situated in a land far far away. I grant access to a user@machine_aaaaaa (grant select on db.* to ‘user’@'machine_aaaaa’ identified by ‘password’; flush privileges;), send an email to the user saying it should run fine and happily go off my way. Mistake!

    It seems this user can’t connect to the mysql gets access denied:
    Access denied for user ‘user’@'machine_bbbbb’ (using password: YES)

    Note that the machine the user is being seen from is totally different from the one I set up in the grant!! WHY?

    run a reverse lookup on the ip of machine_aaaaa, turns out it shows machine_bbbbb. So I figure a big bad guy messed up /etc/hosts, I was right! `cat /etc/hosts` just to find an entry for machine_aaaaa blehh

    Ok, solution is to remove the entry from /etc/hosts (after


      [Read more...]
    Showing entries 1 to 10 of 22 10 Older Entries

    Planet MySQL © 1995, 2014, Oracle Corporation and/or its affiliates   Legal Policies | Your Privacy Rights | Terms of Use

    Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.