Mysql LoadBalancer or Statefulnes?Help?


Anyone can help me with just the general idea or instruct me with this. im a beginner in K8s i know the general idea. But there is somone that wants a website with kubernets and wants it like this. The website on one server(i know how to do this) and the database mysql in another server(they gave ne two servers i can use for the databse. They want it so when a lot of requests are being made to the database it doesnt fail or it delayes them. I created one in my home lab with a ubuntu server joined it to the cluster and deployed a mysql instance with two pods replicas the problem is they share different databases

root@worker1:/mnt/data/mysql# ls

auto.cnf binlog.000002 binlog.index ca.pem client-key.pem '#ib_16384_1.dblwr' ibdata1 '#innodb_redo' mysql mysql.sock private_key.pem server-cert.pem sys undo_001

binlog.000001 binlog.000003 ca-key.pem client-cert.pem '#ib_16384_0.dblwr' ib_buffer_pool ibtmp1 '#innodb_temp' mysql.ibd performance_schema public_key.pem server-key.pem test undo_002

root@worker1:/mnt/data/mysql# cd ..

root@worker1:/mnt/data# cd mysql-1/

root@worker1:/mnt/data/mysql-1# ls

auto.cnf binlog.000003 ca.pem gaia_test ib_buffer_pool '#innodb_redo' mobiread_test2 mysql.sock public_key.pem sys undo_002

binlog.000001 binlog.index client-cert.pem '#ib_16384_0.dblwr' ibdata1 '#innodb_temp' mysql performance_schema server-cert.pem sysdb_mobiread_test2

binlog.000002 ca-key.pem client-key.pem '#ib_16384_1.dblwr' ibtmp1 mobiread_shared_test2 mysql.ibd private_key.pem server-key.pem undo_001

root@worker1:/mnt/data/mysql-1#



so when i login to mysql from one place it shows other databases when i login from another place it shows the other. Can someone please instruct me with the general idea how to do this

THANKS

https://redd.it/1ebyfw2
@r_devops