mariadb-server

How to set the password

mysql -u root -p 
UPDATE mysql.user SET authentication_string = PASSWORD('s0mePassword'), plugin = 'mysql_native_password' WHERE User = 'root' AND Host = 'localhost';
FLUSH PRIVILEGES;

160 total views, 1 views today

How to run multiple networks from a Mikrotik

5 Port Router?

Since a Mikrotik (example being a 750GL) is a true 5 port router and not just a consumer-grade router (which is actually a router with 4 port switch), you can set them up to run multiple networks, use multiple ISPs for WAN failover, and more.  Why you would want to do any of these things is beyond the scope of this post, but this will show you how to do it.

Let’s take an RB750GL and have it run 4 internal networks instead of one.  Like this:

Continue reading How to run multiple networks from a Mikrotik

1,471 total views, 2 views today

Mikrotik port mapping/forwarding

If you would like to direct requests for a certain port to an internal machine (sometimes called opening a port, port mapping), you can do it like this:

/ip firewall nat add chain=dstnat dst-port=1234 action=dst-nat protocol=tcp to-address=192.168.1.1 to-port=1234

This rule translates to: when an incoming connection requests TCP port 1234, use the DST-NAT action and redirect it to local address 192.168.1.1 and the port 1234 Continue reading Mikrotik port mapping/forwarding

595 total views, 2 views today

Benchmarking InnoDB page compression performance

InnoDB page compression is a feature that really interests me. I wrote this about it recently when describing how to improve the performance of large tables in MySQL:

“Use innodb page compression. For some workloads (particularly those with lots of char/varchar/text data types) compression will allow the data to be more compact, stretching out that performance curve for longer. It may also allow you to more easily justify SSDs which are typically smaller in capacity. InnoDB page compression was improved a lot in MySQL 5.6, courtesy of Facebook providing a series of patches.”

Continue reading Benchmarking InnoDB page compression performance

256 total views, 1 views today