Updates from May, 2013 Toggle Comment Threads | Keyboard Shortcuts

  • Jay Versluis 6:38 pm on May 13, 2013 Permalink | Reply
    Tags: , replication   

    Categories: MySQL ( 19 )   

    MySQL Replication Troubleshooting 

    crab-iconSometimes things don’t work out with replication. When I first started experimenting with it I thought this was a “setup and forget about it” kind of job.

    Experience has shown though that you have to regularly triple check and see if things may have broken (despite a good and once working setup).

    Let’s take a look at what you can do when your Slave isn’t replicating anymore. If you want to know more about how to setup replication, have a look at my previous article in which I explain how this works.

    (More …)





     
    • Kanika 12:17 pm on December 8, 2013 Permalink | Reply

      My testdb Lab setup crashed due to low disk space on root dirve on my ec2 Amazon linux systems.

      I have a DB on Mysql servers.

      Does removing the Mysql database on Master & slave & also removing Bin log files from both the servers have any negative impact on replication If I create the databases with the same name in future.

      Any help appreciiated

      • Jay Versluis 1:30 pm on December 8, 2013 Permalink | Reply

        Hi Kanika,

        Removing a database will not delete those log files, it will merely add a log entry that you did it. Re-creating it with the same name in the future will also create a log entry, so as long as the slave does all the same steps it should not have a negative impact in the future. Good luck with the rebuild 😉

  • Jay Versluis 11:41 am on May 11, 2013 Permalink | Reply  
    Categories: Linux ( 99 ), MySQL ( 19 )   

    How to setup MySQL Master/Slave Replication with existing data 

    mysqlThis is a step-by-step guide on how to replicate an existing MySQL server. The server is live and contains data and needs a constant backup companion.

    Many tutorials focus on how to setup replication when no data is present on the system. That’s an ideal solution if you’re building a new setup, but in case you’ve got a server that already has data present then here’s how to accomplish the this:

    1. setup your existing MySQL server (with data) as a Master
    2. export all your databases and user accounts
    3. create a slave and import all your data
    4. start replication

    I’ve done this several times and always forgot to take some notes – until today. Without further ado, let’s replicate MySQL.

    (More …)





     
    • Fabrizio 3:30 pm on May 16, 2013 Permalink | Reply

      A couples of errors:

      mysql# release lock; -> this should be mysql# unlock tables;

      root# mysql -p > everything.sql -> this should be root# mysql -p < everything.sql

      And some code error:

      mysql# CREATE USER 'replicator'@'%' IDENTIFIED BY '***';

      mysql# GRANT REPLICATION SLAVE ON * . * TO 'replicator'@'%'
      IDENTIFIED BY '***' WITH MAX_QUERIES_PER_HOUR 0
      MAX_CONNECTIONS_PER_HOUR 0 MAX_UPDATES_PER_HOUR 0
      MAX_USER_CONNECTIONS 0 ;

      Remove the "" parts

      • Jay Versluis 10:54 pm on May 16, 2013 Permalink | Reply

        Thanks Fabrizio,
        you’re a life saver – not sure how I got those rather crucial commands wrong there. I’ve updated the article. Much appreciated!

    • Nathan 9:53 pm on September 10, 2015 Permalink | Reply

      How to get or open that command line?

      • Jay Versluis 10:33 am on September 11, 2015 Permalink | Reply

        Hi Nathan, that’s a complex subject 😉 These command line tools are commonly referred to as SSH Clients, SSH being the type of connection you typically make between your local system and the remote server. On Mac and Linux systems there’s a built-in tool you can use. It’s called Terminal. On Windows you have to install one, for example PuTTY. You can even get utilities for iOS and Android devices.

        Note that this article discusses two types of connections: the first is to the remote server’s operating system, and the second is to the MySQL server. Although they may be installed on the same system, the command line syntax is very different (shell commands vs. MySQL commands).

    • Angel Cool 8:16 pm on March 30, 2018 Permalink | Reply

      I would totally add –routines flag to that mysqldump command.

      • Jay Versluis 12:35 pm on March 31, 2018 Permalink | Reply

        Thanks for the tip, Angel. What does -routines do?

  • Jay Versluis 1:28 am on May 9, 2013 Permalink | Reply
    Tags: , netbook, samsung   

    Categories: Linux ( 99 )   

    How to install CentOS 6 on a Samsung NC10 

    NC10Today was a rather exciting day for me: I’ve successfully turned my aging Samsung NC10 Netbook into an internal server in our office.

    I bought the little guy in 2009 and he’s been my trusty companion on many jobs before I got an iPad. He still works fine, even though Windows XP was getting weird of late – and admittedly I hadn’t even turned him on in over 8 months.

    Now my trusty pal is running CentOS 6.4 while sitting quietly in a corner next to the ubee modem, serving as an internal Linux server. This is great for testing and automated backups – and in the same spirit as playing with a Raspberry Pi (in a much neater battery powered package).

    Refreshing the NC10 wasn’t a picnic though, and some of the steps are rather involved. Here are my notes, in case I either have to do it again or you want to follow along.

    (More …)





     
  • Jay Versluis 12:05 am on May 1, 2013 Permalink | Reply
    Tags: Autodesk, SketchBook Pro   

    Categories: How To ( 33 )   

    How to switch SketchBook Pro 6 into Full Screen Mode 

    SketchBookPro-LogoThe Mac version of Autodesk’s SketchBook Pro 6 works well on small screen – but since real estate is limited, there is a way to switch the app to Full Screen Mode.

    Rather than the double-arrow in the top right corner though, you’ll have to use the shortcut

    OPTION+CTRL+J

    Don’t ask me why, it’s not very well documented for such an intuitive app. And since I keep forgetting how to do this, here it is in writing.

    Thanks to Eric from Autodesk for this tip (discussion)





     
c
Compose new post
j
Next post/Next comment
k
Previous post/Previous comment
r
Reply
e
Edit
o
Show/Hide comments
t
Go to top
l
Go to login
h
Show/Hide help
shift + esc
Cancel