[THOUGHTS] MySQL Partitioning

osTicket / osTicket

The osTicket open source ticketing system official project repository, for versions 1.8 and later

osticket.com

GNU General Public License v2.0

3.18k stars 1.65k forks source link

[THOUGHTS] MySQL Partitioning #5804

Open antiuser opened 3 years ago

antiuser commented 3 years ago

Prerequisites

Hi there! What can you think about MySQL partitioning on tables in OST? Im assume this is a case for largest databases

JediKev commented 3 years ago

@antiuser

Rather interesting concept. I haven’t looked too deep but we are somewhat limited with our current ORM. Plus with v2.0 coming up it would be pointless to make major ORM changes. I believe we can discuss this more closer to v2.0 as it will be using a really mature and well documented ORM in which this could be a possibility.

Cheers.

antiuser commented 3 years ago

@JediKev I am very glad of your reaction, of course, we do not use a very large database yet, but someday it will be useful. Now we are working on ISP, we have database partitioning on MySQL (SYSLOG database for switches) and PostgreSQL (for ZABBIX database, if you know) any help! )))