Forum Replies Created

Log In Register Lost Password
Viewing 2 posts - 1 through 2 (of 2 total)
  • Author
    Posts
  • December 14, 2014 at 4:27 pm in reply to: more than one central-server? #934
    Zeb
    Participant

    Apologies for the delayed reply. As long as the MySQL/MariaDB servers are configured correctly then the replication is fully automatic and should one of them be offline for any period, it will synchronise with the other server once it is back. This allows us to take one of the servers down for upgrades, etc. without any effect on the service.

    I’m sure I have some notes on the configuration somewhere…

    I haven’t used MariaDB yet but will be in the next couple of weeks for a large database (using Piwik).

    We’re moving from MySQL 5.1 to MariaDB 5.5 as the later versions (5.4+, I seem to recall) have multi-threaded support. Otherwise only a single CPU core can be used which seriously affects performance.

    December 9, 2014 at 8:33 pm in reply to: more than one central-server? #817
    Zeb
    Participant

    I have run MySQL in master-master mode with two nodes. It makes no difference which node an operation is performed on, even simultaneous inserts are fine providing the primary key is an AUTO_INCREMENT column. The key thing is to make sure that the following paramters are configured correctly (for example):

    Server 1
    server-id = 1
    auto_increment_increment = 10
    auto_increment_offset = 1

    Server 2
    server-id = 2
    auto_increment_increment = 10
    auto_increment_offset = 2

    Simultaneous inserts on both servers would have insert IDs of 11 and 12. An insert on node 1 then 2 then 1 then 2 would have the insert IDs: 11, 22, 31, 42.

  • Author
    Posts
Log In Register Lost Password
Viewing 2 posts - 1 through 2 (of 2 total)