Posts

MySQL Replication on Oracle Cloud’s “Always Free” Compute Instance

Always Free Compute Instance creation on OCI and MySQL Community Server installation Please refer to my previous blog MySQL Installation on Oracle Cloud’s “Always Free” Compute Instance and repeat same step for second instance.In this blog I used one compute Instance as  Master and Other as Slave. MySQL Replication Classic 1.Need to set following System Variable at /etc/my.cnf (Master Host). datadir=/var/lib/mysql socket=/var/lib/mysql/mysql.sock log-error=/var/log/mysqld.log pid-file=/var/run/mysqld/mysqld.pid server_id=1 bind-address=172.0.2.7 master_info_repository=TABLE relay_log_info_repository=TABLE log_bin=master_binlog binlog_format=row Property Value Description server_id 1 On a replication master and each replication slave, you must specify server_id to establish a unique replication ID master_info_repository TABLE The master info log contains status and current configuration informat...
1 comment
Read more

MySQL Installation on Oracle Cloud’s “Always Free” Compute Instance

Image
I have configured MySQL Replication (Classic and DTID)   on   Oracle Public Cloud “Always Free”   that would like to share . I also would like to mention that It is unofficial  and testing purpose only. 1.Create free Oracle Cloud account You need to go to Oracle's Could Free Website and register. This need you must give your email address and payment method. You won't be charged if you choose the Oracle Cloud free-tier products.         2. Create compute instance         3.Choose SSH key and provide Public Key.       4.After selection of ssh public key it shows like         5.Choose Show Advance Option     6.Choose Management with Proper Fault Domain and choose networking Tab.                 7.Choose Networking launch option. ...
Post a Comment
Read more